dbt how to create custom table without using CTAS?

Question

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

Answer 1

You can use pre-hook/post-hook.

In pre-hook/post-hook you can write a create table query (or any other query).

In your use case, I would do something like:

{{
   config(
       pre-hook = "create table test (a int)"
   )
}}

select * 
from test