Exercise 2 - Manipulate Data with Data Transforms

The goal of this exercise is to showcase the power of Data Transforms to manipulate ingested data. Data Transforms are frequently used to analyze data quality, clean data and run calculations for use with the Customer 360 Data Model.

Step 1: Create Data Lake Objects to Store the Transformed Data

We will use the Coral Cloud Guests Data Lake Object as the starting point and will create a transform to properly format guest phone numbers.

Navigate to the Data Lake Objects tab and click New. Here, you see a variety of ways to create a New Data Lake Object.
Select create Create from a Data Kit and click Next.
Leave the Data Space as “default”, click the DF Style No Case data kit, select Guest Mobile Phone Numbers, and then click Next.
The Data Lake Object Name should be Guest Mobile Phone Numbers (you may have to remove the word “copy” from the name) and the Category should be Other.
Set the Data Type of Phone Number to Text.
Ensure the Primary Key checkbox is selected next to Guest Phone Number Id.
When your screen matches the example below, click Save.
Repeat steps 1-7 to create the Guest Home Phone Numbers DLO.

Step 2: Map Guest Phone Number DLOs to the Customer 360 Data Model

Click on Data Lake Objects in the navigation tab and click on Guest Home Phone Numbers.
Next, click on Start to begin mapping the object.
Click Select Objects to open the list of available data model objects and search for Contact Point Phone.
Select the “+” next to Contact Point Phone to select the data model object. It will have a green checkmark when properly selected. Next, click Done to return to the mapping window.

5. Einstein has automatically mapped an attribute for us, but we have a few more to add. 6. Since we are now experienced at mapping data attributes to our Customer 360 Data Model, go ahead and map the following fields according to the chart below.

Guest Phone Number Field		Contact Point Phone Field
Guest Id	->	Party
Guest Phone Number Id	->	Contact Point Phone Id
Phone Number	->	Formatted E164 Phone Number
Phone Number	->	Telephone Number
Phone Type	->	Primary Phone Type

When you have finished mapping, click Save and Close.
The mapping for Guest Mobile Phone Numbers DLO has already been done for you.

Step 3: Create the Data Transform to Populate Guest Phone Number DLOs

We now need to create the Data Transform that will extract the phone information from the Coral Cloud Guests data lake object and populate the guest phone number data lake objects that we created and added to the Default data space.

Navigate to Data Transforms and click New.
Select Create from a Data Kit and click Next.
Choose Format Guest Phone Numbers and click Next.
The Data Transform will install from the Data Kit and load on the canvas as shown below. Data is brought into the transform by connecting the Coral Cloud Guest data lake object. Next, there is a split that checks for a Mobile Phone or a Home Phone.
Click on the Format Mobile Phone transformation node. There are (4) steps in this transformation:
First, we remove any non-numeric characters from the Mobile column.
Next, we create a unique value by concatenating Guest Id and Clean Phone Number to create Guest Phone Number Id, which will be used as the primary key.
We then set the Phone Type to Mobile.
Lastly, we drop the columns that we no longer need.
Now, click on the Output to Guest Mobile Phone Numbers output node. We can see that we are outputting (4) columns to the data lake object.
Go ahead and click Save. Name the Data Transform Format Guest Phone Numbers and then click Save again. If the name is already present, but you’re unable to save, just add a space to the name and then delete that space.
Click the ← Back to Data Transforms in the upper righthand corner of the screen.
Click the dropdown arrow to the right of the Data Transform and select Run Now.
The Data Transform could take up to 5 minutes to run.