Snowflake
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Snowflake

  • Dark
    Light
  • PDF

Snowflake connector pulls audit logs from the snowflake database, account_usgae schema from various default audit views provided by snowflake.

Pre-requisites

You will need the following:

  • A valid Snowflake account with the following credentials
    • Username
    • Password
    • Account Name
  • Read snowflake database privileges

Granting privileges

By default, you’re logged in using the SYSADMIN role. However, to view and change account information, you need to switch to the ACCOUNTADMIN role, which is the super admin role.

image.png

  • Navigate to databases tab
  • Click on the snowflake database (Not on the database name), a grant privileges drawer will open.

image.png

  • Grant imported privileges to sysadmin role.

image.png

How to get account name?

  • You’ll have a unique URL with your account name in it to access your Snowflake environment:

  • You can get the account name with the help of the following example. Example: <account_name>.snowflakecomputing.com

image.png

Configurations

The following are the configurations to forward Snowflake Connector audit logs to DNIF.‌

image.png

Filed Description
Connector Name Enter a name for the connector
Connector Type Enter Snowflake Connector
Snowflake Username Enter the name of the Snowflake user
Snowflake User Password Enter the password for snowflake user
Snowflake Account Name Enter the account name for snowflake
Database Views Select the database views you want to get audit logs for. By default, QUERY_HISTORY, SESSIONS and LOGIN_HISTORY are selected, Views can be selected from the provided list;
  • ACCESS_HISTORY
  • AUTOMATIC_CLUSTERING_HISTORY
  • COPY_HISTORY
  • DATABASE_STORAGE_USAGE_HISTORY
  • DATA_TRANSFER_HISTORY
  • LOAD_HISTORY
  • LOGIN_HISTORY
  • MATERIALIZED_VIEW_REFRESH_HISTORY
  • METERING_DAILY_HISTORY
  • METERING_HISTORY
  • PIPE_USAGE_HISTORY
  • QUERY_HISTORY
  • REPLICATION_USAGE_HISTORY
  • SEARCH_OPTIMIZATION_HISTORY
  • SESSIONS
  • STAGE_STORAGE_USAGE_HISTORY
  • STORAGE_USAGE
  • TASK_HISTORY
  • WAREHOUSE_EVENTS_HISTORY
  • WAREHOUSE_LOAD_HISTORY
  • WAREHOUSE_METERING_HISTORY
  • Click Save after entering all the required details and click Test Connection, to test the configuration.

  • A Connection successful message will be displayed on screen along with the time stamp.

  • If the connection is not successful an error message will be displayed. Refer Troubleshooting Connector Validations for more details on the error message.


Was this article helpful?

What's Next