How to find the List of databases in Snowflake

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

select database_name,
       created as create_date,
       database_owner,
       comment
from information_schema.databases
order by database_name;

Column names:

• database_name - database name
• created_date - date the database was created
• database_owner - name of the role that owns the schema
• comment - comment for this database

nVector

posted on 03 Mar 20