11 Mar 20 · npack · #Snowflake ·   Bookmark   ×

How to find list of Schemas in Snowflake

You can use the below query to get the list of all the Schemas in Snowflake:

select catalog_name as database,
schema_name,
schema_owner,
created,
last_altered
from information_schema.schemata
where schema_name not in ('INFORMATION_SCHEMA', 'PUBLIC')
order by schema_name;

Column names:

  • database - database that the schema belongs to
  • schema_name - name of the schema
  • schema_owner - name of the role that owns the schema
  • created - creation time of the schema
  • last_altered - last altered time of the schema

npack

posted on 11 Mar 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied