Gain Insights on Data Directly in Snowflake (Beta)

Run explorations on your data in Snowflake warehouse without loading data into Salesforce or preparing it in datasets. After you set up a live connection to Snowflake, you can run queries on the Snowflake schema associated with the connection in real time. You can even build dashboard charts and tables based on the queries that you run on Snowflake 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.

Note

Note

As a beta feature, Einstein Analytics Salesforce Direct Data for Snowflake is a preview and isn’t part of the “Services” under your master subscription agreement with Salesforce. Use this feature at your sole discretion, and make your purchase decisions only on the basis of generally available products and features. Salesforce doesn’t guarantee general availability of this feature within any particular time frame or at all, and we can discontinue it at any time. This feature is for evaluation purposes only, not for production use. It’s offered as is and isn’t supported, and Salesforce has no liability for any harm or damage arising out of or about it. All restrictions, Salesforce reservation of rights, obligations concerning the Services, and terms for related Non-Salesforce Applications and Content apply equally to your use of this feature. You can provide feedback and suggestions for the feature in the Trailblazer Community.

Who: Exploring Snowflake data using a live connection requires the Explore External Data Directly permission.

How:
  1. To opt your org into the Salesforce Direct Data for Snowflake (Beta), select Enable Einstein Analytics Direct Data for external data sources in the Analytics Settings page.
  2. On the Connect tab of the Einstein Analytics data manager, click Connect to Data.
  3. Click Add Connection on the Live Connections tab and enter its settings.

    Add Connection for Einstein Direct Data for Snowflake

    When setting up the connection, use the Analytics app setting to control which Salesforce users, roles, and groups have access to explore Snowflake data with the connection. When done, click Save or Save and Test.

    Note

    Note

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

From the All Items tab in Analytics Studio, users can view the Snowflake connections under Live Data.

Live Data section in Einstein Analytics Datasets
To begin exploring, click a connection under Live Data and select a data object that is available with the connection.

In the beta release, Direct Data for Snowflake includes these features.
  • Charts, values, and pivot tables
  • Fields panel
  • Query actions
  • Filtering on measures, dimensions, and absolute and relative dates
  • Filter logic and aggregate filters