Map the Fields for a Data Connection

From the row for the newly-created data connection, click the More Options menu (the three dots) and then click Edit Mapping.

The Map Fields screen opens and the file's column names auto-populate.

From the Map Fields screen, perform the following steps and then click Next:

1. For any columns that you do not want to be queryable, slide the Include toggle to the left.

2. If needed, adjust the field delimiter for any fields where the delimiter has not been parsed correctly.

   Note

   This is not common.

3. If you need to add an additional field, click Add Additional Field and then enter a column name. 

   Note

   Once you’ve added a field, you can edit the column label. You can also delete the added field by clicking the delete icon.

From the Add Metadata screen, perform the following steps and then click Next:

1. If you want to create additional datasets where all of the identifiers are resolved to LiveRamp identifiers (RampIDs and/or Known IDs), slide the “Enable Identity Resolution” toggle to the right.

   Note

   This toggle is only displayed if your organization has been enabled for Identity Resolution in LiveRamp Clean Room. For more information, see "Getting Started with Identity Resolution in LiveRamp Clean Room".

2. If the values in a field are encrypted in the source data and must be decrypted during processing, slide the “Encrypted” toggle to the right (leave it to the left for plaintext values).

3. For any column that contains PII data, slide the PII toggle to the right.

   Note

   • If your data contains a column with RampIDs, do not slide the PII toggle for that column. Mark the RampID column as a User Identifier and select "RampID" as the identifier type. If the data contains a RampID column, no other columns can be enabled as PII.

   • Fields labeled as PII are protected from being returned as columns in analytical question results by default.

4. Adjust the data type (field type) for any column where the data type parsed by the system is incorrect (for more information on supported field types, see "Field Types for Data Connections").

   Note

   Make sure to select a field type that accurately reflects the data in that field.

5. For columns that you want to partition, slide the Allow Partitions toggle to the right.

6. If a column contains PII or any other type of identifier, slide the User Identifier toggle to the right and then select the appropriate user identifier type.

   Note

   • When you select "Raw Email" as the user identifier for an email column, those email addresses will be automatically SHA256 hashed. The resulting hashed emails are then available for querying in your clean rooms.

   • If you are using Identity Resolution on this data connection, you must mark the CID field as a User Identifier with Customer First Party Identifier selected.

From the Field Description step, add any desired descriptions for the fields and then click Next.

From the Configure Partition Values screen, perform the steps in “Configure Partition Parameter Values” if you want to configure allowed values for any fields that you have enabled for partitioning. When done, click Next.

From the Schedule Identity Resolution screen, perform the following steps and then click Next:

1. Enter the day of the month (a number from 1 to 28) when you want the monthly full identity resolution refresh to take place.

2. In the Date Range area, enter or select an optional end date (in UTC) for the identity resolution process.

   Note

   The start date defaults to the current date and is not editable.

3. In the Country Data Came From area, select the country where the data originated.

From the Review screen, look over all the configuration details and then click Save.