Avoid Stale Salesforce Data in Snowflake with Sync Out (Beta)

Fresh Salesforce data is vital if you maintain a central Snowflake data lake for processing, analysis, business automation, or storage. For example, give your shipping logistics team the freshest data by merging your account data from your system of record, Salesforce, with your ERP’s shipping data in your data lake. Sync Out for Snowflake exports your raw local Salesforce data via Analytics to Snowflake using the Einstein Analytics connector for Snowflake. With Sync Out for Snowflake, keep your Salesforce data in Snowflake up to date using scheduled Data Sync without the need for a third-party ETL tool.

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, Sync Out 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 in connection with 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 Sync Out for Snowflake in the Einstein Analytics Pilot and Beta Connectors group in the Trailblazer Community.

Why: You can use a Data Prep recipe output node to push data to Snowflake, but this augmentation adds a layer of processing. With Sync Out for Snowflake, you can push the data in the same condition as Analytics received it from Salesforce, with no additional processing time.

How: Contact your Salesforce account representative to enable Sync Out for Snowflake. Turn on Sync Out for Snowflake in Analytics Setup. 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.

Back on the Connect tab, find the local Salesforce connection with data you want to export to Snowflake. For our example, this local connection includes the account object. Select the down arrow (Down arrow.) next to the connection and click Sync Out.

Sync Out option selected from Connect page.

Sync Out runs as the data sync completes for each local object. For our example, after Data Sync pulls data from the account object into Analytics, Sync Out would then push the same account data to Snowflake.