PREP 500: Ingesting CSV Data into Adobe Experience Platform

Prerequisites

You need to setup DBvisualizer:

PREP 400: DBVisualizer SQL Editor Setup for Data Distiller

Scenario

The goal of this exercise is to ingest test data into the Adobe Experience Platform so that you can do the modules. Note that the CSV file upload approach as shown here only works for smaller-sized datasets (1GB or less). If you need larger-sized test data, you will need to use a dedicated connector or the Data Landing Zone. To see how to use the Data Landing Zone, check this out:

PREP 501: Ingesting JSON Test Data into Adobe Experience Platform

Source Files

Download the following file locally to your machine.

72KB

Movie_data.csv

Ingesting CSV Files into the Adobe Experience Platform

1. Navigate to Adobe Experience Platform UI->Workflows->Create Dataset from CSV File.

1. Configure the name of the dataset as Movie data

1. Drag and drop the CSV file into the Add data box. You can also navigate to the file by using the "Choose File" button as well.

1. Once the data is loaded, you will see a data preview.

1. Click Finish to complete the upload.

2. Navigate to AEP UI->Datasets to locate the dataset Movie data. You will notice that the manual upload of the CSV file by you has caused the file to be ingested in batch with a Batch ID and 1000 records are ingested. On the right side panel, observe the table name that shows it as movie_data. The SQL engine in Data Distiller will be using this table name to query against the data, not the Dataset name.

1. Preview the dataset by clicking on the Preview dataset button in the top right corner. You will get a dataset preview that looks like this:

Query the Dataset

Execute the following code:

select * from movie_data 

The result you will get will look like this: