I agree with the edge case. Great insight! Although I am using this as a buffer table, I would prefer retaining a month’s data in production.
As much as I have understood, on_run_start
will run every time dbt run
is executed. So won’t the table be dropped and recreated each time dbt run
is executed?