Transformation Configuration Setup

This pages provides instructions on what transform code should be added to a script manifest file to transform Sailthru data into the Unified Notification Schema (UNS)

Overview

The Sailthru extractor provides data on email campaigns / automations, contacts, lists, subscribe / unsubscribe, and sends / bounces / opens and clicks. The Daasity transformation code maps data from the Sailthru schema into the Unified Notifications Schema (UNS)

Feature Dependencies

You must have enabled our Code Repository feature in order to both access the Daasity transformation code as well as modify a Script Manifest File enabling this code to execute

We recommend you review the Transformation Configuration section of our Help documentation to familiarize yourself with our workflow engine and script manifest files.

Script Manifest File (YML)

Upstream Transformation Dependencies

This code is dependent on the following integration being installed:

• Sailthru

This code block is dependent on the following upstream code blocks being implemented:

• Initialization

Transformation Code Requirements

To enable the data transformation from the Sailthru schema into UNS, the following code must be run in a workflow:

  uns_sailthru:
    scripts:
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1305_UNS_BAS_SAILTHRU_campaign_sends.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1306_UNS_BAS_SAILTHRU_triggered_sends.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1307_UNS_BAS_SAILTHRU_campaign_opens.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1308_UNS_BAS_SAILTHRU_triggered_opens.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1309_UNS_BAS_SAILTHRU_campaign_clicks.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1310_UNS_BAS_SAILTHRU_triggered_clicks.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1311_UNS_BAS_SAILTHRU_campaign_bounces.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1312_UNS_BAS_SAILTHRU_triggered_bounces.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1313_UNS_BAS_SAILTHRU_campaign_unsubscribes.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1314_UNS_BAS_SAILTHRU_triggered_unsubscribes.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1315_UNS_BAS_SAILTHRU_clients.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1316_UNS_BAS_SAILTHRU_campaigns.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1317_UNS_BAS_SAILTHRU_templates.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1318_UNS_BAS_SAILTHRU_flows.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1319_UNS_BAS_SAILTHRU_profiles.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1320_UNS_BAS_SAILTHRU_profile_lists.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1321_UNS_BAS_SAILTHRU_profile_list_removals.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1322_UNS_BAS_SAILTHRU_profile_vars.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1323_UNS_BAS_SAILTHRU_campaign_abtests.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1324_UNS_BAS_SAILTHRU_extract_shopify_address_profile_vars.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1330_UNS_BAS_SAILTHRU_automations.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1335_UNS_BAS_SAILTHRU_campaigns.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1340_UNS_BAS_SAILTHRU_contacts.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1345_UNS_BAS_SAILTHRU_contact_attributes.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1350_UNS_BAS_SAILTHRU_lists.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1355_UNS_BAS_SAILTHRU_contact_lists.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1360_UNS_BAS_SAILTHRU_sends.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1361_UNS_BAS_SAILTHRU_opens.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1362_UNS_BAS_SAILTHRU_clicks.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1363_UNS_BAS_SAILTHRU_unsubscribes.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/sailthru/1364_UNS_BAS_SAILTHRU_bounces.sql"

Unified Notification Schema

Code to populate the UNS tables:

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1305_UNS_BAS_SAILTHRU_campaign_sends.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1306_UNS_BAS_SAILTHRU_triggered_sends.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1307_UNS_BAS_SAILTHRU_campaign_opens.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1308_UNS_BAS_SAILTHRU_triggered_opens.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1309_UNS_BAS_SAILTHRU_campaign_clicks.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1310_UNS_BAS_SAILTHRU_triggered_clicks.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1311_UNS_BAS_SAILTHRU_campaign_bounces.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1312_UNS_BAS_SAILTHRU_triggered_bounces.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1313_UNS_BAS_SAILTHRU_campaign_unsubscribes.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1314_UNS_BAS_SAILTHRU_triggered_unsubscribes.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1315_UNS_BAS_SAILTHRU_clients.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1316_UNS_BAS_SAILTHRU_campaigns.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1317_UNS_BAS_SAILTHRU_templates.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1318_UNS_BAS_SAILTHRU_flows.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1319_UNS_BAS_SAILTHRU_profiles.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1320_UNS_BAS_SAILTHRU_profile_lists.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1321_UNS_BAS_SAILTHRU_profile_list_removals.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1322_UNS_BAS_SAILTHRU_profile_vars.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1323_UNS_BAS_SAILTHRU_campaign_abtests.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1324_UNS_BAS_SAILTHRU_extract_shopify_address_profile_vars.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1330_UNS_BAS_SAILTHRU_automations.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1335_UNS_BAS_SAILTHRU_campaigns.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1340_UNS_BAS_SAILTHRU_contacts.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1345_UNS_BAS_SAILTHRU_contact_attributes.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1350_UNS_BAS_SAILTHRU_lists.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1355_UNS_BAS_SAILTHRU_contact_lists.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1360_UNS_BAS_SAILTHRU_sends.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1361_UNS_BAS_SAILTHRU_opens.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1362_UNS_BAS_SAILTHRU_clicks.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1363_UNS_BAS_SAILTHRU_unsubscribes.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/sailthru/1364_UNS_BAS_SAILTHRU_bounces.sql