# Redshift error: External tables are not supported in views

**URL:** <https://discourse.getdbt.com/t/redshift-error-external-tables-are-not-supported-in-views/17287>\
**Category:** Help\
**Tags:** redshift, dbt-cloud, views\
**Created:** [December 10, 2024, 10:00am UTC](https://discourse.getdbt.com/t/redshift-error-external-tables-are-not-supported-in-views/17287 "2024-12-10T10:00:43Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![santosh2k2](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/santosh2k2/32/4997_2.png) [@santosh2k2](https://discourse.getdbt.com/u/santosh2k2)\
**Post date:** [December 10, 2024, 10:00am UTC](https://discourse.getdbt.com/t/redshift-error-external-tables-are-not-supported-in-views/17287/1 "2024-12-10T10:00:43Z")

</div>

**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/](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