With Schema Sync, you can ensure that new attributes 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 attributes in the following Synapses:
Prerequisites
Schema Sync works on a going forward basis from the time you save your Schema Sync rule. All pre-existing attributes have to be created and mapped in Pipeline Studio.
In this article, we are going to setup a one-way Schema sync between Salesforce and Snowflake for the Account Entity.
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, click Schema Sync.
You'll see the Schema Sync modal. Click Add Setting.
Select the source Salesforce Entity, in this case, Contact.
Select the end system we want the new Salesforce attributes mirrored, in this case, Hubspot.
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, Contact.
Now, let's select the To Entity, the entity in the destination system which corresponds to the From Entity, in this case, Contact.
And finally click Save.
The Schema Sync modal will close upon save. From this point on, any new attribute created on the Salesforce Account object, will automatically be created on the designated Snowflake object. Additionally, Syncari will create draft mappings for those new attributes.
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 attributes.