List all tables, database, schema in entire Snowflake account

404

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

Post Comment

nVector07-Apr-20

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