Sync custom events from Amazon Redshift to OneSignal to trigger automated Journeys and personalized messaging campaigns based on user behavior.
Create dedicated user for OneSignal
Grant permissions to event data
Configure network 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 |
~/.ssh/authorized_keys
UNLOAD
command for efficient bulk data extraction. VPC deployments require an S3 VPC Endpoint to allow Redshift to communicate with S3.
Setup S3 VPC Endpoint:
UNLOAD
command for efficient bulk data extraction, which is optimized for large-scale analytics workloads.