Problem
Getting error while building model to create view… reading data from redshift spectrum.
I thought dbt_external_tables package will be able to help … and made changes accordingly … but no luck… Any guidance will help
ERROR:
Redshift adapter: Redshift error: External tables are not supported in views
Package documentation used:
https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/
Changes tried but didn’t work.
1> added packages.yml file
2> added below in models/staging/_src_sanitise.yml
added S3 location
added column defination of source as mentioned in package docs. i.e.
columns:
- name: campaign_id
data_type: bigint
- name: origin_campaign_id
data_type: bigint
- name: is_recurring
data_type: boolean
- name: name
data_type: string
- name: timezone