In my SQL server source I have an Orders table with an OrderID as primary key (auto increment)
When I take a snapshot of the Orders table, it runs fine the first time.
The second run with “dbt snapshot” I get the error Identity Insert failed. My guess is because in the generated snapshot table the Order ID was also assigned auto increment.
