What happens if I add new columns to my snapshot query?
When the columns of your source query changes, dbt will attempt to reconcile this change in the destination snapshot tableIn simplest terms, a table is the direct storage of data in rows and columns. Think excel sheet with raw values in each of the cells.. dbt does this by:
- Creating new columns from the source query in the destination table
- Expanding the size of string types where necessary (eg.
varchar
s on Redshift)
dbt will not delete columns in the destination snapshot table if they are removed from the source query. It will also not change the type of a column beyond expanding the size of varchar columns. That is, if a string
column is changed to a date
column in the snapshot source query, dbt will not attempt to change the type of the column in the destination table.
0