dbt-sqlserver icon indicating copy to clipboard operation
dbt-sqlserver copied to clipboard

Contract Enforcement Error with PK

Open jckardos opened this issue 11 months ago • 2 comments

models:

  • name: apprenticeship_history description: cust_apprenticeships config: unique_key: apprenticeship_history_hk contract: enforced: true constraints:
    • type: primary_key columns:
      • apprenticeship_history_hk name: pk_apprenticeship_history

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)

jckardos avatar Mar 26 '24 20:03 jckardos

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

stephan-meier avatar May 06 '24 10:05 stephan-meier

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

mmc00 avatar May 08 '24 21:05 mmc00