Initialise snapshot with data from a dimension table


We are trying to migrate tables from mssql into snowflake, some of these tables are dimensions tables from the source tables, with columns similar to the ones dbt snapshots have (dbt_VALID_FROM, dbt_VALID_TO, dbt_SCD_ID).

We have started using dbt to get the data from snowflake, create models to do some transformations and use snapshots. The problem we have is that we want to create snapshots for the source table and then continue using the snapshots with the data from snowflake, so we keep the history we had.

We have created staging files to get the data from the source tables, then created models to do the transformations and finally the snapshots. But the problem is that we get duplicate column name ‘dbt_VALID_FROM’ when creating the snapshot from the dimension table. Is there a way to initialized a snapshot using data from a history table and replacing the columns dbt_VALID_FROM, dbt_VALID_TO, dbt_SCD_ID with the ones we have (keeping the dbt column names)?

Thanks in advance!!

I managed to fix my problem.
We created a model using our source table and doing transformation of the timestamp columns to be the same as dbt_VALID_FROM, dbt_VALID_TO. Then we copy the table into a snapshot, and then run our snapshot using the current data as a source

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