Gain Insights on Data Directly in Snowflake (Generally Available)

Run explorations on your data in the Snowflake data platform without loading data into Salesforce or requiring data preparation. After you set up a live connection to Snowflake, you can run queries on Snowflake data associated with the connection in real time. With Einstein Analytics Direct for Snowflake, you can even build dashboard charts and tables based on the queries that you run on this data.

Where: This change applies to Einstein Analytics in Lightning Experience and Salesforce Classic. Einstein Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

How: By default, Enable Einstein Analytics Direct Data for external data sources is turned on in the Analytics Settings page.
  1. On the Connect tab of the Einstein Analytics data manager, click Connect to Data.
  2. Click Add Connection on the Live Connections tab and enter its settings.

    Add Connection for Einstein Direct Data for Snowflake

    When done, click Save or Save and Create Dataset.

    Note

    Note

    When creating connections to Snowflake, we recommend using a Snowflake user account with read-only access to maintain data security.

  3. In the data manager, click the Data tab.
  4. On the Live Datasets tab, click, Create Dataset. Select the connection and enable a Snowflake source table that is available with the connection.Select source table in Snowflake
  5. Name the live dataset and assign it to an Analytics app. Use the app to control which Salesforce users, roles, and groups have access to explore Snowflake data with the connection. When done, click Create Live Dataset.
  6. To begin exploring, click the live dataset from the Datasets tab in Analytics Studio.