Runtime error at Nessie table creation in dbt-dremio

Dremio University
1

I get this error when I try creating a table in Nessie via dbt–> “Runtime Error in model places (models/raw/places.sql)
ERROR: A non-view table with given name [Nessie.test.places] already exists in schema [Nessie.test]”

Surprisingly, the table does get created in Nessie, but as an outcome of this error the subsequent model runs are skipped causing a failure in dbt run

I have used on_run_start config to drop table if exist and it doesn’t make any difference. I have added a snap of dremio table, config in code and dbt_project.yml for reference.

Error
Error1846×918 92.2 KB

Note:
Dremio version: 25.0
dbt-dremio version: 1.7.0

@AlexMerced can you please help!

2

@Ragul Can you please query information_schema."tables" and see if this table has an entry there?

3

Yes, it does have an entry in the information_schema.“tables”

image
image1246×409 31.1 KB

4

Hi there,
Am also haveing the simalar issues despite using incremental materialization in the config.

{{ config(
    database="Nessie",
    schema='EID',
    materialized='incremental',
    unique_key=['Name'],
    incremental_strategy='append'
)}}

have you managed to find a workaroud?

5

@ddione @Ragul Looks like the drop did not happen completely and on the Dremio side the table still shows as a PDS. Let me check on this and get back to you