dbt-sqlserver
dbt-sqlserver copied to clipboard
Contract Enforcement Error with PK
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
- type: primary_key
columns:
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)
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
Sorry previous pull request wasn't test it. It's related with the changes in fabric #500