Bert's Blog

Here is a quick SQL to pull a listing of the Snowflake Cloud database INFORMATION_SCHEMA tables. The Snowflake metadata table documentation is helpful and a link has been provided below.

SQL Listing INFORMATION_SCHEMA Tables

——————————————–

INFORMATION_SCHEMA for Admin Tables

——————————————–

SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.”TABLES”

where TABLE_SCHEMA like ‘INFO%’

Related References

DOCS » GENERAL REFERENCE » INFORMATION SCHEMA

• https://docs.snowflake.com/en/sql-reference/info-schema.html