BQ now supports FK & PK; take into account for diagrams 🙏

[MaximusMcCann]

You can now define Foreign and Primary keys on table columns in BigQuery. Would love to see them interpreted and added to the lovely image output to see connections between tables.

Google docs regarding adding FK and PK constraints. https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#alter_table_add_constraint_statement

Queries to pull the information off the schema about FK & PK.

https://cloud.google.com/bigquery/docs/information-schema-constraint-column-usage

SELECT *
FROM <PROJECT_ID>.<DATASET>.INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE;

https://cloud.google.com/bigquery/docs/information-schema-key-column-usage

SELECT *
FROM <PROJECT_ID>.<DATASET>.INFORMATION_SCHEMA.KEY_COLUMN_USAGE;

https://cloud.google.com/bigquery/docs/information-schema-table-constraints

SELECT *
FROM <PROJECT_ID>.<DATASET>.INFORMATION_SCHEMA.TABLE_CONSTRAINTS;

General spot for BQ schema information: https://cloud.google.com/bigquery/docs/information-schema-intro

[k1LoW]

@MaximusMcCann Thank you for your report!

[MaximusMcCann]

Of course! :)

[markthepixel]

This would be awesome!

[unstoppable-allensun]

Would love to see this feature!

[fruwe]

This would be really helpful!!

[tunguyennnnn]

This would be very helpful!

[sudoryan]

Thanks for the issue! I would like to have this as well

[helfi92]

+1