Table Descriptions

Google BigQuery supports setting descriptions on tables but the add-in does not report these by default. Use ShowTableDescriptions to report table descriptions.

Primary Keys

Google BigQuery does not support primary keys natively, but the add-in allows you to define them so they can be used in environments that require primary keys to modify data. Use PrimaryKeyIdentifiers to define primary keys.

Policy Tags

If policy tags from the Data Catalog service are defined on a table, you can retrieve them from the system tables using the PolicyTags column:

SELECT ColumnName, PolicyTags FROM sys_tablecolumns
WHERE CatalogName = 'psychic-valve-137816'
AND SchemaName = 'Northwind'
AND TableName = 'Customers'