[Core] Foreign key constraints support to (with ref) + to_columns

[jtcohen6]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

https://docs.getdbt.com/reference/resource-properties/constraints

What part(s) of the page would you like to see updated?

Copied from dbt-labs/dbt-core#10414 (comment)

Model-level constraint example syntax:

models:
  - name: my_model
    constraints:
      - type: foreign_key
        columns: [id]
        to: ref('my_model_to') | source('source', 'source_table')
        to_columns: [id]
    columns:
      - name: id
        data_type: integer

Column-level example syntax:

models:
  - name: my_model
    columns:
      - name: id
        data_type: integer
        constraints:
        - type: foreign_key
          to: ref('my_model_to') | source('source', 'source_table')
          to_columns: [id]

Additional information

This is already available in dbt Cloud Versionless

This will be available in dbt Core (OSS) v1.9

[nataliefiann]

Hiya @jtcohen6 / @MichelleArk

I hope you're well.

Just so I have an understanding here, can you let me know what you'd like updating on this please? Would it be just to add the example syntaxes to the doc: https://docs.getdbt.com/reference/resource-properties/constraints

Kind Regards
Natalie