Hello DBT, can you kindly advise if there is a way to define “column type” (eg: varchar, date) in dbt?

Because dbt uses “Create Table As Select” statements (CTAS) to create tables in relevant database platforms, instead of doing separate “CREATE TABLE” and then “INSERT” statements, it doesn’t natively have a way to specify datatypes. However, what we do in our dbt models is to force a CAST on every …

Can you define column data types in dbt?

Help

meurant.naude December 17, 2020, 8:17pm 6

We’ve also had a need to cast data types. We unpacked a JSON string.
This is what we did:

Topic		Replies	Views
How to control dbt model's column datatype? Help snowflake , dbt-core	1	2903	June 12, 2024
Declare Column Data Types in python models Help bigquery , python-models , dbt-cloud	0	377	April 25, 2024
Generate table with type parameters in BigQuery Help bigquery	6	967	November 21, 2023
Why is DBT changing datatypes, column lengths and column order Archive	1	3168	December 31, 2021
I don't want dbt to change the column type of an existing table that's loaded incrementally Help incremental	1	803	October 28, 2024

Can you define column data types in dbt?

Related topics