dbt build rollback

In-Depth Discussions
, , ,
1

Hello, there!

I think it would be a great feature if dbt build command had a “rollback” option. This would basically revert any changes made during dbt run step if a fail happens during dbt test step. Let me know what your thoughts are and if there is something like this already being worked on.

2

This sounds sort of like a blue/green deploy - you might start there!

3

If you’re in bigquery, you can run a hook after a build, and check if anything failed, and if so - roll back the tables using time travel. I wrote a quick post about this yesterday: