Search code examples
amazon-redshiftdbt

Read Redshift external table in DBT

I was trying to read a redshift external table from dbt which I created by reading the data from s3 bucket. In DBT I created a .sql file in the models folder and wrote the below query.

{{ config(materialized="view") }}

select * from <<schema_name>>.<<table_name>>

But getting the following error:

Operations on local objects in external schema are not enabled

Need help !! Thanks in advance.

Solution

  • You're going to want to use the dbt package of macros: dbt-external-tables. You can't read from S3 without it.