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 …

[image] josh: – All of these 5 fields excluded from the star are already in the dimension. I’m wondering what is the best practice of where to do this casting? For example, my first step is always to create a base_ table that renames columns. Seems like that would be the right place to do th…

We do this casting on every single model. The issue of ensuring that datatypes are what we expect they are is not just an issue for models that are immediately adjacent to sources but for every single model along the way. From an engineering perspective we never want to assume - we always want to ve…

We’ve also had a need to cast data types. We unpacked a JSON string. This is what we did: [image] Auto pivot JSON string using schema.yml in BigQuery Show and Tell Let me start by giving you some background and apologies if the background is longer than the so…

Can you define column data types in dbt?

Help

joellabes Split this topic September 7, 2022, 3:45am 5

A post was split to a new topic: Casting column datatypes based on a seed

Topic		Replies	Views
How to control dbt model's column datatype? Help snowflake , dbt-core	1	3280	June 12, 2024
Declare Column Data Types in python models Help bigquery , python-models , dbt-cloud	0	408	April 25, 2024
I don't want dbt to change the column type of an existing table that's loaded incrementally Help incremental	1	985	October 28, 2024
Generate table with type parameters in BigQuery Help bigquery	6	1012	November 21, 2023
How to populate TYPE in the dbt Docs? Help dbt-docs , dbt-cloud	5	2876	April 9, 2025

Can you define column data types in dbt?

Related topics