Export OneSignal message event data to Snowflake for analytics.
OneSignal Snowflake integration overview
IMPORT SHARE
and CREATE DATABASE
roles.
ACCOUNTADMIN
role for accepting the share.snowflake-data-sharing@onesignal.com
Copying Snowflake account identifier
Snowflake data share notification email
Snowflake private sharing interface
CREATE DATABASE
or IMPORT SHARE
. We suggest switching to the ACCOUNTADMIN
role.
It will take some time for the data to be replicated. Snowflake will follow up with an additional email once the data is available. You should see a dialog that looks like this
Data replication status dialog
Database configuration dialog
Data share setup completion
snowflake-data-sharing@onesignal.com
to request to deactivate your data share with OneSignal.
Column Name | Type | Description | Example |
---|---|---|---|
event_id | UUID | A unique ID that represents the event | dc76df03-287c-403a-aabd-b2d4fe44e5c6 |
event_kind | string | The type of event that occurred. The list of event kinds can be found here. | message.email.opened |
event_impression_timestamp | unix_timestamp | The time that Onesignal processes the event | 1684951205 |
subscription_id | UUID | A unique ID that represents the device/subscription | 6e8b6978-75a4-4882-878c-2d15a78c2409 |
subscription_language | string | The language of this subscription | en |
subscription_timezone | integer | The specified timezone of this subscription | -25200 |
subscription_device_type | string | The type of device this subscription uses. | SMS |
onesignal_id | UUID | The onesignal_id of the user that made the impression | dc76df03-287c-403a-aabd-b2d4fe44e5c6 |
external_id | string | The external_id of the user that made the impression | MyExternalId |
message_id | UUID | A unique ID that represents the message | dc76df03-287c-403a-aabd-b2d4fe44e5c6 |
message_name | string | The human-readable id of the Notification/Message | Campaign 1 |
message_title | string | The Title of the Notification/Message.English only at this time | Bonus 50 coins when you play! |
message_body | string | The Body of the message. (Truncated) English only at this time. | Play against your friends and earn an additional... |
snowflake-data-sharing@onesignal.com
with any requests for additional categories of data!