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;
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