List databases in Snowflake

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

0
There are no comments. Click here to write the first comment.