Write Your Einstein Analytics Datasets to Snowflake from Recipes (Generally Available)

The Snowflake Output connector lets you push your prepared data from Analytics into Snowflake when you use Data Prep recipes. You design powerful Data Prep recipes that combine data from multiple sources, add formula fields, and transform data into datasets tailored to your business needs. With the Einstein Analytics connector for Snowflake, datasets are liberated from Analytics and written as a table for you without the need to rebuild relationships and business logic. This feature is now generally available.

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: On the Connect tab of the Data Manager, click Connect to Data. Add a connection on the Output Connections tab and configure it with your Snowflake account information.

The Output Connections tab of the Connections section.

Build your recipe with Data Prep. In an Output node, select to write to the Output Connection (1). Choose the Snowflake connection to push data to (2) and the Snowflake object that receives the data (3). Map recipe columns to their equivalent external object columns (4).

Configuring the output node of a recipe to use Snowflake.

Save the recipe. When the recipe runs, Analytics writes the outcome to Snowflake.