The problem I’m having
I am getting an error in compiled Snowflake when declaring a Contract Primary Key
PS C:\repos\dbt\Snowflake\dbt_ic1> dbt --version
Core:
- installed: 1.7.14
- latest: 1.7.14 - Up to date!
Plugins:
- snowflake: 1.7.3 - Up to date!
Some example code or error messages
models:
- name: AutoAccidentInfo
config:
contract:
enforced: true
constraints:
- type: primary_key
columns: IcSiteID, EmsBillingAreaCode, EmsTripNumber, EmsAutoAccidentSequenceNumber
Run-time code:
primary key (I, c, S, i, t, e, I, D, ,, , E, m, s, B, i, l, l, i, n, g, A, r, e, a, C, o, d, e, ,, , E, m, s, T, r, i, p, N, u, m, b, e, r, ,, , E, m, s, A, u, t, o, A, c, c, i, d, e, n, t, S, e, q, u, e, n, c, e, N, u, m, b, e, r)
Error:
15:41:14 Database Error in model EMS_IC1_EmsAutoAccidentInfo (models\IC0-IC1\EMS\Intermediate_IC1_EMS\EMS_IC1_EmsAutoAccidentInfo.
sql)
001003 (42000): SQL compilation error:
syntax error line 15 at position 41 unexpected ‘,’.
syntax error line 15 at position 42 unexpected ‘,’.
syntax error line 15 at position 45 unexpected ‘,’.
syntax error line 15 at position 101 unexpected ‘,’.
syntax error line 15 at position 102 unexpected ‘,’.
syntax error line 15 at position 105 unexpected ‘,’.
syntax error line 15 at position 146 unexpected ‘,’.
syntax error line 15 at position 147 unexpected ‘,’.
syntax error line 15 at position 150 unexpected ‘,’.