Snowflake Guide
It only takes a few minutes to get started with Satori. What you need is:
- 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
- Login to Satori's management console at https://app.satoricyber.com.
- In the Data Stores view, select Add Data Store.
- Select the Snowflake option.
- Enter an informative name for the data store, for example: Sales Data Warehouse.
- 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. - Satori will automatically choose the correct public cloud vendor and region.
- Click Create. You will be redirected to the Data Stores list.
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
.
SAML-based Single Sign-On (SSO)
SMAL-based SSO is supported by Satori for Snowflake. Please follow the following guides on how to configure SSO with Snowflake and Satori:
- Configure Okta Single Sign-On (SSO) for Snowflake with Satori.
- Configure AzureAD Single Sign-On (SSO) for Snowflake with Satori.
- Google Cloud Identity (coming soon)