[Bug] stg_amazon_ads__ad_group_level_report referenced but does not exist?

### Is there an existing issue for this?

- [X] I have searched the existing issues

### Describe the issue

When running `dbt compile`, I get

``` Compilation Error in model stg_amazon_ads__ad_group_level_report_tmp (models/tmp/stg_amazon_ads__ad_group_level_report_tmp.sql)
'dict object' has no attribute 'source.ad_performance.amazon_ads.ad_group_level_report'

> in macro dbt_faker_source (macros/dbt_faker_source.sql)
> called by macro source (macros/dbt_faker_source_override.sql)
> called by macro default__union_data (macros/union_data.sql)
> called by macro union_data (macros/union_data.sql)
> called by model stg_amazon_ads__ad_group_level_report_tmp (models/tmp/stg_amazon_ads__ad_group_level_report_tmp.sql)
```

### Relevant error log or model output

```shell
Compilation Error in model stg_amazon_ads__ad_group_level_report_tmp (models/tmp/stg_amazon_ads__ad_group_level_report_tmp.sql)
'dict object' has no attribute 'source.ad_performance.amazon_ads.ad_group_level_report'

> in macro dbt_faker_source (macros/dbt_faker_source.sql)
> called by macro source (macros/dbt_faker_source_override.sql)
> called by macro default__union_data (macros/union_data.sql)
> called by macro union_data (macros/union_data.sql)
> called by model stg_amazon_ads__ad_group_level_report_tmp (models/tmp/stg_amazon_ads__ad_group_level_report_tmp.sql)
```
```

### Expected behavior

`dbt compile` should not error

### dbt Project configurations

n/a

### Package versions

0.3.0

### What database are you using dbt with?

snowflake

### dbt Version

1.7.3

### Additional Context

n/a

### Are you willing to open a PR to help address this issue?

- [ ] Yes.
- [X] Yes, but I will need assistance and will schedule time during our [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance
- [X] No.