Setup
- Adapter:
dbt-fabric 1.10.0post2 (Microsoft Fabric Data Warehouse)
- Elementary version: latest
target.database: e.g. CORE
- Elementary schema configured in a different database (e.g.
AUDIT.dbt_<user>__elementary)
cache_artifacts: true, upload_artifacts_method: diff (defaults)
Symptom
After running dbt run -s elementary, the elementary schema accumulates intermediate tmp views that are never dropped:
dbt_columns__tmp_<19-digit-timestamp__dbt_tmp_vw>
dbt_exposures__tmp_<19-digit-timestamp__dbt_tmp_vw>
dbt_seeds__tmp_<19-digit-timestamp__dbt_tmp_vw>
dbt_sources__tmp_<19-digit-timestamp__dbt_tmp_vw>
dbt_tests__tmp_<19-digit-timestamp__dbt_tmp_vw>
Setup
dbt-fabric1.10.0post2 (Microsoft Fabric Data Warehouse)target.database: e.g.COREAUDIT.dbt_<user>__elementary)cache_artifacts: true,upload_artifacts_method: diff(defaults)Symptom
After running dbt run -s elementary, the elementary schema accumulates intermediate tmp views that are never dropped: