search

dbt-msft / dbt-synapse-serverless

dbt adapter for dbt serverless pools
MIT License
13 stars 6 forks source link

subsequent DBT runs fail with compilation error - found approximate match on model name #2

Open jakub-auger opened 2 years ago

jakub-auger commented 2 years ago

empty synapse serverless instance

dbt run

views get created

try dbt run again

expected behaviour existing views are replaced

actual behaviour

Compilation Error in model my_first_dbt_model (models\example\my_first_dbt_model.sql)
  When searching for a relation, dbt found an approximate match. Instead of guessing
  which relation to use, dbt will move on. Please delete "dbo"."my_first_dbt_model", or rename it to be less ambiguous.
  Searched for: "dbo"."my_first_dbt_model"
  Found: "dbo"."my_first_dbt_model"

  > in macro materialization_view_synapseserverless (macros\materializations\view.sql)
  > called by model my_first_dbt_model (models\example\my_first_dbt_model.sql)

some kind of bug in the name comparison?