How it works

image
image

What is the SNOWFLAKE Database?

SNOWFLAKE is a system-defined, read-only shared database, provided by Snowflake. The database is automatically imported into each account from a share named ACCOUNT_USAGE.

For more details, see What Is The SNOWFLAKE Database from the Snowflake documentation

image

Enabling Account Usage for Other Roles

By default, the SNOWFLAKE database is available only to the ACCOUNTADMIN role.

To enable other roles to access the database and schemas, and query the views, a user with the ACCOUNTADMIN role must grant the following data sharing privilege to the desired roles:

IMPORTED PRIVILEGES

For more details, see Enabling Account Usage for Other Roles from the Snowflake documentation

image

Objects used by Nadilytics

A user with an ACCOUNTADMIN role runs a short script only once to:

  • Create a new role NADILYTICS_ROLE and grant him privilege to access the SNOWFLAKE database
  • Assign the NADILYTICS_ROLE to a new user NADILYTICS_USER
  • Create a dedicated warehouse NADILYTICS_WH to be used when querying the SNOWFLAKE database views
image

Turn your metadata into actionable insights!

image