With Schema Sync, you can ensure that new fields created in one end system are automatically created in another. The most common use-case in which you would want to use this feature would involve a data warehouse on the receiving end.
We currently support creating fields in the following Synapses:
Pre-requisites
Keep in mind that Schema Sync works on a going forward basis from the time you save your Schema Sync rule. All pre-existing fields have to be created and mapped in Sync Studio.
In this article, we are going to setup a one-way Schema sync between Salesforce and Snowflake for the Account Entity. Let's get started!
Navigate to Schema Studio and select the source synapse. In this example, it's Salesforce.
Now that we are within the context of the Salesforce Schema, let's open up Schema Sync.
You'll see the Schema Sync modal. Click Add Setting.
Select the source Salesforce Entity, in this case, Account.
Now let's pick which end system we want the new Salesforce fields mirrored, in this case, Snowflake.
Since Syncari is involved in exchanging data between the two systems, let's select the Syncari Entity through which this data will flow. In this case, Account.
Now, let's select the To Entity, the entity in the destination system which corresponds to the From Entity.
And finally click Save.
The Schema Sync modal will close upon save. From this point on, any new field created on the Salesforce Account object, will automatically be created on the designated Snowflake object.
Additionally, Syncari will create draft mappings for those new fields.
Be sure to review, test and publish them when you get the chance. Until then, no data will be exchanged between the two systems for those fields.