Gain Insights on Data Directly in Snowflake (Beta)

Run explorations on your data in Snowflake warehouse without having to load 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 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: To explore Snowflake data using a live connection, users need the Explore External Data Directly permission.

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

    Here, use the Analytics app to control which Salesforce users, roles, and groups have access to explore Snowflake data from 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 Dataset tab, users can view the Snowflake connections under Live Data. Live Data section in Einstein Analytics DatasetsTo begin exploring, they can click a connection and select a data object that is available with the connection.