Upload demo data to CDF (3 mins)

This unit describes how to upload the sample dataset we'll use throughout the data modeling articles.

Prerequisites

1. Download the demo data and unzip it to a folder on your local computer. The zip file has these files:

   • movies.csv - the top 1000 movies from IMDB.
   • actors.csv - people appearing as actors in the movies.
   • directors.csv - the director of the movies.
   • actor_movie_appearances.csv - the relationships (edges) between the movies and the actors.

2. Make sure you have the necessary capabilities to work with tables and databases in the CDF staging area.

Upload the demo data to the staging area

To upload the demo data to the CDF staging area:

1. Navigate to the CDF portal application > Integrate > Manage staged data.

2. To create a new database, select Create database and name the database Movies.

3. Select Create table, and name it movies. Next, select the Upload CSV file button and select the movies.csv file.

4. Select I know the primary key, select id, and then the Create button.

5. Repeat the steps above to upload the actors.csv, directors.csv and actor_movie_appearances.csv files as new tables in the movies database. Use the filename (without the file extension) as the name of each table.

   

In the next section, you'll use the uploaded data to create a data model.