DBT Snapshots Erroring With “[42S01][ODBC Driver 18][SQL Server]There is already an object named ‘table_name__dbt_tmp’ in the database.”
When running “DBT snapshot” after the initial run I get the error in the title. The object does already exist as it should, because isn’t that the point of DBT snapshots. To check the source table and update the snapshot table if there has been a change to capture slowly changing dimensions?
Am I missing something here and using them incorrectly or is the error arising due the __dbt_tmp part, I cannot find the table with that suffix in the DB?
Full Error: (’42S01′, “[42S01] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]There is already an object named ‘table_name__dbt_tmp’ in the database. (2714) (SQLMoreResults)”)
Read more here: Source link
