# Transformation Configuration Setup

## Overview

The Cordial data share provides data on email and SMS subscribe / unsubscribe, regular and triggered campaigns, contacts and sends / bounces / opens / clicks. The Daasity transformation code maps data from the Cordial data share into a Cordial schema and then finally into the Unified Notifications Schema (UNS)

## Feature Dependencies

You must have enabled our [Code Repository](/technical-docs/transform-code/code-repository.md) 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](/technical-docs/workflows-and-scheduling/script-manifest-yaml-files.md) section of our Help documentation to familiarize yourself with our workflow engine and script manifest files.

## Script Manifest File (YML)

### Upstream Transformation Dependencies

{% hint style="danger" %}
This code is dependent on the following data share being setup:

* Cordial

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

* [Initialization](/technical-docs/transform-code/transform-code/initialization-code.md)
  {% endhint %}

### Transformation Code Requirements

{% hint style="info" %}
This Transformation Code is for the Cordial Snowflake Data Share
{% endhint %}

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

```
  cordial:
    scripts:
      # The following scripts need to be modified with the name of the Snowflake Share from Cordial
      - "github://platform-sql-shared/scripts/templates/cordial_ext/100_EXT_cordial_contacts_template.sql"
      - "github://platform-sql-shared/scripts/templates/cordial_ext/101_EXT_cordial_contact_lists_template.sql"
      - "github://platform-sql-shared/scripts/templates/cordial_ext/102_EXT_cordial_events_template.sql"
      - "github://platform-sql-shared/scripts/templates/cordial_ext/103_EXT_cordial_event_properties_template.sql"
      - "github://platform-sql-shared/scripts/templates/cordial_ext/104_EXT_cordial_message_sends_template.sql"
      - "github://platform-sql-shared/scripts/templates/cordial_ext/105_EXT_cordial_message_send_tags_template.sql"
      # End of scripts that need to be modified

      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1101_UNS_BAS_CORDIAL_automations.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1102_UNS_BAS_CORDIAL_campaigns.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1103_UNS_BAS_CORDIAL_contacts.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1105_UNS_BAS_CORDIAL_lists.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1106_UNS_BAS_CORDIAL_contact_lists.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1107_UNS_BAS_CORDIAL_sends.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1108_UNS_BAS_CORDIAL_opens.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1109_UNS_BAS_CORDIAL_clicks.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1110_UNS_BAS_CORDIAL_unsubscribes.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1111_UNS_BAS_CORDIAL_bounces.sql"
      - "github://platform-sql-shared/scripts/base/1000_uns/cordial/1112_UNS_BAS_CORDIAL_spams.sql"
```

### Cordial Schema

The data from the Cordial Snowflake share includes JSON that must be de-nested in order to populate the UNS tables.  The following code must be copied into your own [Code Repository](/technical-docs/transform-code/code-repository.md) and modified to have the name of the data share updated.  This code must be run to de-nest the data and populate the Cordial schema which is used as the source for UNS:

* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/templates/cordial_ext/100_EXT_cordial_contacts_template.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/templates/cordial_ext/101_EXT_cordial_contact_lists_template.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/templates/cordial_ext/102_EXT_cordial_events_template.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/templates/cordial_ext/103_EXT_cordial_event_properties_template.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/templates/cordial_ext/104_EXT_cordial_message_sends_template.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/templates/cordial_ext/105_EXT_cordial_message_send_tags_template.sql>

{% hint style="warning" %}
The Cordial Schema scripts must be modified to use the name of the Snowflake share that Cordial has created.  Look for this block `<'database_share_name'>` within the SQL code and replace this with the name of the database share
{% endhint %}

### Unified Notification Schema

Code to populate the UNS tables:

* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1101_UNS_BAS_CORDIAL_automations.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1102_UNS_BAS_CORDIAL_campaigns.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1103_UNS_BAS_CORDIAL_contacts.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1105_UNS_BAS_CORDIAL_lists.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1106_UNS_BAS_CORDIAL_contact_lists.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1107_UNS_BAS_CORDIAL_sends.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1108_UNS_BAS_CORDIAL_opens.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1109_UNS_BAS_CORDIAL_clicks.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1110_UNS_BAS_CORDIAL_unsubscribes.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1111_UNS_BAS_CORDIAL_bounces.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/1000_uns/cordial/1112_UNS_BAS_CORDIAL_spams.sql>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/cordial/transformation-configuration-setup.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.