Query below lists databases on Snowflake instance.

Query

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

Columns

• 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

Rows

• One row represents one database
• Scope of rows: all databases on Snowflake instance
• Ordered by database name

Sample results