Skip to content

Snowflake Overview

Satori supports two types of integrations with Snowflake: proxy-based Snowflake integration and native Snowflake integration. By offering both Snowflake Proxy and Snowflake Native, Satori ensures that your organization has the flexibility to design your systems according to your requirements.

What is the Snowflake Native Integration?

In the Snowflake Native integration, users connect directly to Snowflake while the DAC controls access to data and enforces security policies by configuring roles and security policies directly on Snowflake.

What is the Snowflake Proxy Integration?

In the Snowflake Prox integration, users connect to Snowflake via the Satori Data Access Controller (DAC) which intercepts queries to control access to data and enforce security policies, such as dynamic masking or row-level filtering.

Important Considerations

Review the following considerations before making a choice on which integration option is best for your organization.

Native Snowflake Integration

The following considerations apply to the native Snowflake integration:

  • Admin User - Requires setting up an admin user for the Satori DAC on the Snowflake account.
  • Personal Credentials - For user-specific auditing, access controls and policies, users must connect to Snowflake with their own, personal credentials.
  • Snowflake Enterprise - Requires the Snowflake Enterprise Edition for dynamic masking or row-level security.

For more information on the native Snowflake integration go to the Snowflake Native Guide

Proxy-Based Snowflake Integration

The following considerations apply to the proxy-based integration:

  • Host Parameter - Requires adding the host parameter when connecting to Snowflake. Make sure your client tools support this option.
  • Limitations - Does not support Python Worksheets or Streamlit applications.

For more information on the proxy Snowflake integration go to the Snowflake Proxy Guide