Exercise 4: Ingest Reservations from Amazon S3

Coral Cloud Resorts stores reservations in Amazon S3. In this exercise, you will:

1. Create a data stream that ingests reservations into Data Cloud.

2. Create a custom data model object named Reservation.

3. Create a many-to-one relationship between the Reservation and Individual data model objects.

Step 1: Create the Reservation data stream

In this step, you'll create a data stream that ingests reservations from Amazon S3.

1. Click the Data Streams tab.

2. Click New.

3. Under Other Sources, click Amazon S3, and click Next.

   

4. Configure the data stream with the following values:

   Field	Value
   Connection	Coral Cloud Resorts S3 Connection
   File Type	CSV
   Import from Directory	Leave blank
   File Name	Coral_Clouds_Hotel_Reservations.csv
   Source	Keep default: AwsS3_Coral_Cloud_S3_Connection

   

5. Click Next.

6. Continue configuring the data stream with the following values (keep the default values for all other fields):

   Field	Value
   Data Lake Object Label	Reservation
   Data Lake Object API Name	Keep default
   Category	Engagement
   Event Time Field	Creation Date
   Primary Key	Reservation ID
   Room Number Data Type	Text

   Use the screenshot below to make sure you set all the right values.

   

7. Click Next.

8. Keep the default values, and click Deploy.

9. Make sure the Data Stream Status is Active. When it is, click Refresh Now to populate the Reservation DLO.

10. Keep the default option and click Refresh Now.

Step 2: Create a custom data model object

When you have industry-specific objects that don't have an equivalent in the Customer 360 Data Model, you can extend the Customer 360 Data Model with custom data model objects. In this step, you'll create a custom data model object to represent reservations in the hospitality industry.

1. From the Reservation data stream, click the Start button in the Data Mapping panel.

2. In the data model entities panel, click the Select Objects button.

3. Click the Custom Data Model tab.

4. Click New Custom Object.

   

5. Keep the default selection and click Save.

   

6. Examine the mappings. Because the Reservation custom data model object (DMO) was created based on your Reservation data lake object (DLO), each field in the data lake object has been automatically mapped to its corresponding field in the data model object.

   

7. Click Save & Close.

Step 3: Create the Reservation-to-Individual relationship

In this step, you'll create a many-to-one relationship between the Reservation object and the Individual object.

1. Click the Data Model tab.

2. Click the Reservation data model object (DMO).

3. Click the Relationships tab.

4. Click New.

5. In the Edit Relationships dialog, click the + New Relationship button.

6. Configure your relationship as follows:

   Field	Value
   Field	Contact ID
   Cardinality	N:1
   Related Object	Individual
   Related Field	Individual Id

   

7. Click Save & Close.

8. To visualize the new relationship, click the Data Model tab, click the Display as menu icon, and select Graph.

   

9. Make sure that the Reservation data model object (DMO) has a many-to-one relationship with the Individual DMO.

   

Summary

In this exercise, you created a data stream that ingests reservations from Amazon S3 into a Reservation data lake object (DLO). Because the Customer 360 Data Model doesn't have a standard data model object to represent reservations, you created a custom Reservation data model object. You then defined a many-to-one relationship between the Reservation and the Individual data model objects.