dbt how to create custom table without using CTAS?

user_12168607 0
Viewed 1632

I want to create an empty table with specific columns and data types, I don't have any reference table from where I can do SELECT * FROM . The following link has an image which I intend to do Please find the attached image

dbt sql
1 Answers

DBT isn't allowed to create an empty table(empty table with no CTAS). To create custom columns reference a table and add your columns as follow:

Select ID, cast(NULL AS NEW_COLUMN) FROM <REFRENCE_TABLE>

If you want to create a table with values which not frequently change use seed instead. Documentation link

user_121686070
Related