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
-
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
-
Use the label Person
-
Map from table (csv file in this case), personId and name
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.
-
Use the relationship type ACTED_IN
-
Node ID mapping should be automatic.
-
Map from table (csv file in this case), characters
Note the green checkmark that indicates that an element has been mapped correctly.
Import
Run import is the next step, and it needs a connection to the database.
Connect and wait until the import is done.
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.
Check your understanding
Data importer solves data importing?
Which of these best describes the data importer?
-
❏ Production tool that can be used to schedule massive data imports at frequent intervals.
-
✓ A tool that gets you started quickly with data importing in a Neo4j database. Comes with a visual modeling aid.
-
❏ A demonstration of Neo4j ETL capabilities.
Hint
Think about the purpose of the data importer and its typical use cases.
Solution
A tool that gets you started quickly with data importing in a Neo4j database. Comes with a visual modeling aid. The data importer is designed to help users quickly and easily import data into a Neo4j database, especially for those who are new to Neo4j or graph databases in general. It provides a user-friendly interface and visual modeling capabilities to facilitate the import process.
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.