Here you will have to write SQL queries to select the data you want to join to a Segment User. Here are some ideas of data you should select.
User with product usage properties
User with the organization they are associated to
User with the classification coming from a User Classification model
4. Create your first Sync
Now head to the Sync page and click the Add Sync button.
In the " What data do you want to sync?" section
For the Connection, select the data warehouse you connected in step 2
For the Source, select the model you created in step 3
Next up is the "Where do you want to sync data to?" section
Pick the name of Segment service from step 1 as the Connection, right now the object we can sync to is limited to User
For the " How should changes to the source be synced?" section
Update or Create will be preselected as it is supported
Pick the right mapping key, we can sync based on userId from the Segment Identify call or to the device: AnonymousId
Finally, select the fields you want to update in the Mapper in the "Which Fields should be updated?" section.
Here simply map the fields from your model to the Segment User Properties you want to sync to. You can specify specific properties or "Sync All Properties" such that new columns in the source table will be created on the Segment User object according to the normalization rule you apply
The end result should look something like this:
Click the Next button to see the final preview which will have a recap of what will happen when you start the sync.
That's it! In 4 steps, you've connected Segment and started syncing user properties data from your warehouse 🎉
🗄 Supported Objects
Segment support is pretty straight forward!
Contact us if you want Census to support more objects for Segment.