[Bug] stg_amazon_ads__ad_group_level_report referenced but does not exist?

[aroder]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

When running dbt compile, I get

    '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

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.

[fivetran-joemarkiewicz]

Hi @aroder thanks for raising this issue.

This is quite curious as I am unsure what the following macros are or where they would be used by the Amazon Ads package

    > in macro dbt_faker_source (macros/dbt_faker_source.sql)
    > called by macro source (macros/dbt_faker_source_override.sql)

Are you by chance doing any source overriding with the package or doing anything else outside of the package that could possibly conflict with the package models/macros?

[fivetran-catfritz]

Hi @aroder checking in on this issue. Have you had a chance to into the other packages?

[fivetran-catfritz]

I am marking the status of this ticket as stale, however if you have any additional comments, you can continue to post in this thread!