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

system Closed November 6, 2023, 12:26am 3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Change in data type for a field not considered in dbt snapshot Help snapshots	1	1886	November 25, 2022
dbt snapshot fails Help snapshots , bigquery	7	2951	September 18, 2024
I don't want dbt to change the column type of an existing table that's loaded incrementally Help incremental	1	387	October 28, 2024
Migrating a snapshot after adding a check_col Archive	0	2725	July 30, 2019
Snapshot fails when new column added to schema Help snapshots , dbt-cloud , databricks	0	161	February 4, 2025

snapshots when column data type changes

Related topics