03 Mar 20 · npack · #Snowflake ·   Bookmark   ×

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

npack

posted on 03 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




If i am correct only the Admin will be able to see all the databases in Snowflake. Rest will only show databases which they have access to...

This is a good information. I have only tried using admin account


Community Software by Hittly
Copied