View the schema for a table in Snowflake Open Catalog

A service admin or catalog admin can use the Snowflake Open Catalog web interface to view the schema for a table, including its nested schemas, if applicable. You can view the schema for a table in an internal or external catalog.

  1. Sign in to Snowflake Open Catalog.

  2. From the menu on the left, select Catalogs.

  3. From the catalog object explorer on the left, select the catalog containing the table whose schema you want to view.

  4. From the catalog object explorer, expand the catalog’s namespaces to expose the table whose schema you want to view.

  5. Select the table to display its schema in the center of the page.

  6. If the data type for the Type column in the schema is struct or list<struct >, to view the nested schema for the column, select View nested schema Screenshot that shows the Accounts page in Snowsight..

Language: English