Skip to content

dbt fails to recognize tables already created #215

@rampage644

Description

@rampage644

I found that #209 introduces subtle change (perhaps semantic correct, didn't debug that deep) and subsequent dbt seed and/or dbt run fails.

It tries to get tables list (get_relation) and then fails to match against what is expected:

21:47:17    Compilation Error in seed snowplow_web_dim_ga4_source_categories (seeds/snowplow_web_dim_ga4_source_categories.csv)
  When searching for a relation, dbt found an approximate match. Instead of guessing 
  which relation to use, dbt will move on. Please delete "snowplow"."public_snowplow_manifest"."snowplow_web_dim_ga4_source_categories", or rename it to be less ambiguous.
  Searched for: SNOWPLOW.PUBLIC_SNOWPLOW_MANIFEST.SNOWPLOW_WEB_DIM_GA4_SOURCE_CATEGORIES
  Found: "snowplow"."public_snowplow_manifest"."snowplow_web_dim_ga4_source_categories"
  
  > in macro materialization_seed_default (macros/materializations/seeds/seed.sql)
  > called by macro materialization_seed_snowflake (macros/materializations/seed.sql)
  > called by seed snowplow_web_dim_ga4_source_categories (seeds/snowplow_web_dim_ga4_source_categories.csv)

I figured this has something to do with lowercase normalization.

However, there is potentially another issue at play: show schemas in database, show objects in schemas, show *, is_iceberg from ... begin to behave differently.

Metadata

Metadata

Assignees

Labels

catalogdbtRelated to dbticebergstorage subsystem related, apache iceberg relatedneeds_clarificationthe issue itself needs work

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions