06 Apr 20 · IronBat89 · #Snowflake ·   Bookmark   ×

List all tables, database, schema in entire Snowflake account

I tried with below approach to find list of all schema in entire account but it's not returning all available schema from all databases. What is the right way to this using ACCOUNT_USAGE?




posted on 06 Apr 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

The approach is correct. You can use the ACCOUNT_USAGE to get the centralized object metadata across databases.

By Default, Only ACCOUNTADMIN can access it by default. Once you login as account admin > Go to the Databases > Grant USAGE Permission to PUBLIC

Then you will see the SNOWFLAKE database in the database explorer and able to run the queries against it

Community Software by Hittly