.png?height=120&name=Mozart%20Data%20Logo%20-%20Purple%20(2).png)
Descriptions in Information Schema (Snowflake users only)
We have improved the capabilities for data documentation and cataloging. When you create table or column descriptions, they will now be accessible not only on the Mozart App, but also through the information schema. This means you can easily query the descriptions using any BI tools or export them to Google Sheets, allowin you to create an internal data catalog for your stakeholder teams!
To view your table descriptions: you can use the following sample query from the information schema. The table descriptions will be displayed as comments:
SELECT
table_schema,
table_name,
comment -- the table description
FROM information_schema.tables
WHERE comment IS NOT NULL
To view your column descriptions: you can use the following sample query from the information schema. The column descriptions will be displayed as comments:
SELECT
table_schema,
table_name,
column_name,
comment -- the table description
FROM information_schema.columns
WHERE comment IS NOT NULL
Example of accessing the table & column descriptions in the table 'shopify.collection_product':