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?

USE ROLE ACCOUTADMIN;

SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SCHEMATA;

IronBat89

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