dbt-msft / dbt-sqlserver

dbt adapter for SQL Server and Azure SQL
MIT License
205 stars 96 forks source link

Contract Enforcement Error with PK #494

Open jckardos opened 5 months ago

jckardos commented 5 months ago

models:

generates the following error on build/run

'fabric__table_columns_and_constraints' is undefined

in macro create_table_as (macros\relations\table\create.sql) called by macro default__get_create_table_as_sql (macros\relations\table\create.sql) called by macro get_create_table_as_sql (macros\relations\table\create.sql) called by macro statement (macros\etc\statement.sql) called by macro materialization_table_fabric (macros\materializations\models\table\table.sql) called by model apprenticeship_history (models\silver\success_factors\apprenticeship_history.sql)

stephan-meier commented 4 months ago

I get the same error message with every contract I try on Azure SQL DB, even with zero constraints. dbt-core 1.7.12, dbt-sqlserver 1.7.4

mmc00 commented 4 months ago

Sorry previous pull request wasn't test it. It's related with the changes in fabric #500