In the previous lesson, you learned how to connect to an Aura active database instance.
In this lesson, you will learn how to:
-
Use the integrated service for importing data in the Aura console
-
Model your data for import
-
Import data into your Aura instance
Data Source
Before you can add a New data source you need to have a data source file ready.
For the purpose of this lesson, you can use the sample movie data available at this movies.csv on your local machine.
Once you have downloaded that, you can add it to your Aura instance with New data source.
The data file you have downloaded is a .CSV file, so select CSV as the data source type.
Drop in the movies.csv file. This results in
Model
You can upload a data model or create one manually. For the purpose of this example, you will create one manually.
First define the Movie nodes in the details panel:
-
Use the Label Movie
-
Click on Map from table (csv file in this case), movieId and title
Now add and define the Person nodes.
-
Add a blank node using the Add node label button
Upload the CSV file by using the Drag and Drop area or the Upload CSV button.
-
Use the label Person
-
Click Map from table (csv file in this case), personId and name
You can edit the properties of the nodes by clicking on the pencil icon next to each property:
Create and define the ACTED_IN relationship.
-
Drag the relationship from the Person node to the Movie node using the plus-sign when you hover over the edge of the Person node.
-
Name the relationship type as ACTED_IN.
-
Node ID mapping should be automatic.
-
Click on Map from table (csv file in this case), characters.
Note the green checkmark that indicates that an element has been mapped correctly.
Analyse and confirm model parameters
Before Importing, you can analyse and edit the model parameters, as well as confirming the primary key of the nodes.
Import
Use Run import to ingest the data. You will need to connect to the database.
Once you have added the database credentials, click on Connect and wait until the import is done.
Once the import in complete, you will see a summary of the import results:
Close the result window and you will be back at the main data importer screen.
You can now see the imported data source in the list of data sources.
Give your data model a name, "Movies Model", and Save it.
Check your understanding
Data model reuse
Can you reuse a data model created for one instance on another instance within the same project?
-
✓ Yes, models are linked to the project and can be reused for loads on different instances.
-
❏ No, models are linked to the instance and cannot be reused.
Hint
Think about the purpose of the data model and how it is used within the project.
Solution
Yes, you can reuse a data model created for one instance on another instance within the same project. Models are linked to the project, not the instance, allowing for flexibility in how they are used across different instances.
Summary
In this lesson you imported data in an Aura instance using the integrated data importer service, modeled the data, and ran the import.
In the next lesson, you will explore the integrated query tool to interact with your data and write Cypher queries.