I’m a newbie to this tool. With what i’ve read and tested so-far I was under the false impression of what the ‘relationships’ method of the testing feature does.
I’ve set relationships between tables and when I run the test command those tests are successful (i.e PASS). However, for those tables in the data warehouse i’m developing as of now, there are no PK/FK constraints - I have defined that in postgres myself or figured out where to define that within the models schema.
- What does the dbt-tool actually check for in the case of ‘relationships’?
- Where would I define the PK/FK constraints within the model? Have not seen documentation about this, possibly missed that part.
Short snippet of the schema.yml:
- name: customers
description: A table containing all customers
- name: uid
description: This is a unique identifier in the customer
# - unique
- name: suppliers
description: This is a unique identifier in the supplier table
Thanks in advance!