Skip to content

Snowflake Guide

Screenshot

It only takes a few minutes to get started with Satori. What you need is listed here:

  • Access to Satori's management console.
  • The hostname of your Snowflake data store, for example: abc123.snowflakecomputing.com.

Adding a Snowflake Data Store to Satori

  1. Login to Satori's management console at https://app.satoricyber.com.
  2. In the Data Stores view, select Add Data Store.
  3. Select the Snowflake option.
  4. Enter an informative name for the data store, for example: Sales Data Warehouse.
  5. Enter the hostname of your Snowflake account, for example: abc123.snowflakecomputing.com. You can find the hostname of your account by looking at the address bar in the browser when logging in to Snowflake.
  6. Satori will automatically choose the correct public cloud vendor and region.
  7. Click Create. You will be redirected to the Data Stores list.

Allowing Connectivity between Satori and Snowflake

For Satori to work properly, the data access controller needs to be able to connect to your Snowflake account. By default, Snowflake accepts connections from any IP address, but organizations can limit that access based on their security policies.

To allow Satori to connect to your Snowflake account follow these steps: 1. Go to the Satori management console. 2. In the Data Stores view, select the Snowflake data store for your Snowflake account. 3. Go to the Settings view, and copy the Satori IP address of the data access controller from the Data Store Summary section. 4. Login to your Snowflake account directly using the *.snowflakecomputing.com hostname. 5. Make sure you are using the ACCOUNTADMIN role. 6. Go to Account and select the Policies view. 7. Create a new policy or update an existing one and allow access to the Satori IP address copied previously.

Snowflake Access Control and Satori

To learn how to leverage Snowflake's native access control capabilities with Satori read the Snowflake Access Control and Satori guide.

SAML-based Single Sign-On (SSO)

To learn how to leverage your existing SAML-based SSO to Snowflake with Satori read the Snowflake SSO.

Connecting to Snowflake using Satori

To connect to Snowflake using Satori use the Satori hostname that was generated by the management console which can be found under Satori Hostname in the data store settings view, for example: abc123.us-west-1.a.p0.satoricyber.net.

Connecting with the Snowflake Classic UI

For username/password authentication open a browser and connect to your Satori hostname, for example: abc123.us-west-1.a.p0.satoricyber.net. Enter your username and password and click Login.

Connecting with Snowsight

To connect with Snowsight, follow the instructions to connect to the Snowflake Classic UI. Once logged-in to the classic UI, click on the Preview App link to connect to Snowsight.

Connecting with SnowSQL

To connect with SnowSQL, add the host parameter to the command. For example:

snowsql -a abc123 -u john@example.com -h abc123.us-west-1.a.p0.satoricyber.net

Connecting with Python

To connect with Python, add the host parameter to the connect function. For example:

con = snowflake.connector.connect(
  user="john@example.com",
  password="**********",
  account="abc123"
  host="abc123.us-west-1.a.p0.satoricyber.net"
)

Connecting with the JDBC driver

To connect with the JDBC driver, override or add the host parameter in the JDBC URL. For example:

jdbc:snowflake://abc123.us-west-1.a.p0.satoricyber.net/?user=john@example.com&...

Connecting with the ODBC driver

To connect with the ODBC driver, override the server parameter with the Satori hostname. For example: abc123.us-west-1.a.p0.satoricyber.net.

Connecting with Tableau

Tableau uses the ODBC driver to connect to Snowflake. Override the server parameter with the Satori hostname. For example: abc123.us-west-1.a.p0.satoricyber.net.

Connecting with Looker

Looker uses the JDBC driver to connect to Snowflake. Override the Remote Host:Port parameter with the Satori hostname. For example: abc123.us-west-1.a.p0.satoricyber.net:443.

For additional integration options with Looker, see here.

Connecting with Power BI Desktop

Power BI Desktop uses the ODBC driver to connect to Snowflake. Override the Server parameter with the Satori hostname. For example: abc123.us-west-1.a.p0.satoricyber.net.

Connecting with Redash (redash.io)

Redash uses the Python connector to connect to Snowflake. Override the host parameter with the Satori hostname, under additional options. For example: abc123.us-west-1.a.p0.satoricyber.net.

Connecting with Superset

Superset uses the Python SQL Alchemy connector to connect to Snowflake. Add a host parameter to the connection URL with the Satori hostname. For example: &host=abc123.us-west-1.a.p0.satoricyber.net.