Kurt Drew

Hi Joe, thanks for jumping on this so fast. The source database is called `ingestion`, where Fivetran is writing to and we want to read from. Our target database, where...

I can confirm that the `campaign_report` table exists in `ingestion.fivetran_reddit_ads`. However, when I ran a few tests I was able to confirm that the packages was not reading from the...

Nothing that stands out to me 😞

I'm glad you are seeing the same error, I find Redshift can be very particular about this kind of thing. Regarding data sharing, it is enabled for the cluster. However,...

I think you are on the right track with dbt-redshift. The view is rather simple: ```sql with source as ( select * from {{ source('fivetran_reddit_ads', 'campaign_report') }} ), renamed as...

Maybe I have something set up wrong, but I am getting the following error: ``` 21:37:24 Database Error in model stg_reddit_ads_campaign_report (models/staging/reddit_ads/campaign_report/stg_reddit_ads_campaign_report.sql) All the relation names inside should be qualified...

The compiled code is: ``` create view "dbt_kurt_drew"."public"."stg_reddit_ads_campaign_report__dbt_tmp" as ( with source as ( select * from None ), renamed as ( select * from source ) select * from...

We have had some issues with table bindings in the past, so in `dbt_project.yml` we put `bind: false` under `models:`