dbt-labs / dbt-labs/docs.getdbt.com

dbt-athena does not create "__dbt_tmp" table in a certain condition.

Open
#8,158 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
215
Forks
1.2k
Avg merge
1d 15h
Merged PRs (30d)
130

Description

In certain cases, the `__dbt_tmp` table is not created.

Here’s the relevant part of the model configuration:
```python
table_type='iceberg', materialized='incremental', incremental_strategy='merge',
force_batch=True
```

The current logic only creates the __dbt_tmp table when there are records to merge or insert.
If there are no records, the __dbt_tmp table is never created with the config above.
As a result, when the subsequent logic tries to reference this table, the model fails because the expected temporary table doesn’t exist.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.