Avoid Stale Salesforce Data in Snowflake with Sync Out (Beta)
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.
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.
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 () next to the connection and click Sync Out.
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.