Sync custom events from Azure Synapse to OneSignal to trigger automated Journeys and personalized messaging campaigns based on user behavior.
Create dedicated login for OneSignal
<your-database>
with your actual database name containing event data.Grant read permissions
<your-schema>
with your actual schema name containing event data. Repeat this command for each schema you want OneSignal to access.Configure firewall access
Connect to OneSignal
CENSUS
OneSignal Field | Description | Required | |
---|---|---|---|
name | event_name | Event identifier | Yes |
external_id | user_id | User identifier | Yes |
timestamp | event_timestamp | When event occurred | No |
properties | event_data | No |
user_id
for optimal query performanceGRANT SELECT, VIEW DEFINITION ON SCHEMA::<schema>
statement for each schema containing event data.
sp_set_firewall_rule
to add OneSignalβs IP addresses. Contact OneSignal support for the current IP ranges.