I have been creating snapshots of a table fine. However, recently, one column changes data type from number to boolean, so the snapshot run has been failing ever since, returning this error Expression type does not match column data type, expecting NUMBER(38,0) but got BOOLEAN Is there a way to jus…

dbt will upcast column types when possible (e.g. changing from a varchar(20) to varchar(100) when the column gets larger). But it can’t safely convert a number column into a boolean column. Let’s say the column you’re having issues with is called impacted_column. You could do a couple of things: M…

snapshots when column data type changes

Help

Topic		Replies	Views
Change in data type for a field not considered in dbt snapshot Help snapshots	1	2075	November 25, 2022
dbt snapshot fails Help snapshots , bigquery	7	3388	September 18, 2024
Ephemeral models, snapshots and new columns Help snapshots , ephemeral-models	0	425	February 26, 2025
Snapshot fails when new column added to schema Help snapshots , dbt-cloud , databricks	0	521	February 4, 2025
Snapshot DBT_CAHNGE_TYPE Metadata column Help snapshots , snowflake	0	122	March 25, 2025

snapshots when column data type changes

Related topics