Temporary tables (...__dbt_tmp) are not cleaned after a snapshot run.
Steps To Reproduce
Create and run a snapshot. After the run finishes, the corresponding __dbt_tmp tables remain in the database.
Expected behavior
The __dbt_tmp tables are dropped after a snapshot run.
Screenshots and log output
The output of dbt --version:
Core:
- installed: 1.7.11
- latest: 1.8.2 - Update available!
Your version of dbt-core is out of date!
You can find instructions for upgrading here:
https://docs.getdbt.com/docs/installation
Plugins:
- teradata: 1.7.2 - Up to date!
The operating system you're using:
Windows 11
The output of python --version:
Python 3.11.3
Describe the bug
Temporary tables (
...__dbt_tmp
) are not cleaned after a snapshot run.Steps To Reproduce
Create and run a snapshot. After the run finishes, the corresponding
__dbt_tmp
tables remain in the database.Expected behavior
The
__dbt_tmp
tables are dropped after a snapshot run.Screenshots and log output
The output of
dbt --version
:The operating system you're using: Windows 11 The output of
python --version
: Python 3.11.3