Create datasets

In this lesson, you will create datasets to receive your data. You will be excited to know that this is the shortest lesson in the tutorial!

All data that is successfully ingested into Adobe Experience Platform is persisted in the data lake as datasets. A dataset is a storage and management construct for a collection of data, typically a table, that contains a schema (columns) and fields (rows). Datasets also contain metadata that describes various aspects of the data they store.

Data Architects will need to create datasets outside of this tutorial.

Before you begin the exercises, watch this short video to learn more about datasets:

Permissions required

In the Configure Permissions lesson, you set up all the access controls required to complete this lesson, specifically:

• Permission items Data Management > View Datasets and Manage Datasets
• Permission item Sandboxes > Luma Tutorial
• User-role access to the Luma Tutorial Platform product profile
• Developer-role access to the Luma Tutorial Platform product profile (for API)

Create datasets in the UI

In this exercise, we will create datasets in the UI. Let’s start with the loyalty system:

1. Go to Datasets in the Platform UI’s left navigation

2. Select the Create Dataset button
   

3. On the next screen, select Create Dataset from schema

4. On the next screen, select your Luma Loyalty Schema and then select the Next button
   

5. Name the dataset Luma Loyalty Dataset and select the Finish button
   

6. When the dataset has saved, you will be taken to a screen like this:
   

That’s it! I told you this was going to be quick. Create these other datasets using the same steps:

1. Luma Offline Purchase Event Dataset for your Luma Offline Purchase Event Schema
2. Luma Web Events Dataset for your Luma Web Events Schema
3. Luma Product Catalog Dataset for your Luma Product Catalog Schema

Create a dataset using API

Now create the Luma CRM Dataset using the API.

Get the id of the schema to be used in the dataset

First we need to get the $id of the Luma CRM Schema:

1. Open Postman
2. If you haven’t made a request in the last 24 hours, your authorization tokens have probably expired. Open the request Adobe I/O Access Token Generation > Local Signing (Non-production use-only) > IMS: JWT Generate + Auth via User Token and select Send to request new JWT and Access Tokens, just like you did in the Postman lesson.
3. Open the request Schema Registry API > Schemas > List all schemas within the specified container.
4. Update the Accept Header to one of the allowed values, for example application/vnd.adobe.xdm+json
5. Select the Send button
6. You should get a 200 response
7. Look in the response for the Luma CRM Schema item and copy the $id value
   

Create the dataset

Now you can create the dataset:

1. Download Catalog Service API.postman_collection.json to your Luma Tutorial Assets folder. (The Dataset Service API collection is for managing data usage labels on existing datasets)

2. Import the collection into Postman

3. Select the request Catalog Service API > Datasets > Create a new dataset.

4. Paste the following as the Body of the request, replacing the id value with your own:

   {
       "name": "Luma CRM Dataset",
   
       "schemaRef": {
           "id": "REPLACE_WITH_YOUR_OWN_ID",
           "contentType": "application/vnd.adobe.xed-full+json;version=1"
       },
       "fileDescription": {
           "persisted": true,
           "containerFormat": "parquet",
           "format": "parquet"
       }
   }
   

5. Select the Send button

6. You should get a 201 Created response containing the id of your new dataset!
   

You can go back to the Datasets screen in the Platform user interface, you can verify the successful creation of all five datasets!

Additional Resources

• Datasets documentation
• Datasets API (part of Catalog Service) reference

Now that all of our schemas, identities, and datasets are in place, we can enable them for Real-time Customer Profile.