GraphAcademy

Aura Fundamentals

Introduction to Neo4j Aura

Getting Started

Tools

Operations

Import data

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 Importer service

importer_main

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.

Adding a data source

importer_source

The data file you have downloaded is a .CSV file, so select CSV as the data source type.

Uploading the data file

importer_drop

Drop in the movies.csv file. You can also use the Upload CSV button to browse and select the file from your local machine.

Data Importer manual

Once the file is uploaded, you will see the Data Importer manual.

importer_manual

Model

You can upload a data model or create one manually. For the purpose of this example, you will create one manually.

importer_bank

Defining the data model

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

Edit data model

Upload CSV file

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.

Define Person nodes

  • Use the label Person

  • Click Map from table (csv file in this case), personId and name

Person node properties

importer_person

Edit Person properties

You can edit the properties of the nodes by clicking on the pencil icon next to each property:

Define ACTED_IN relationship

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.

ACTED_IN relationship properties

importer_actedin

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.

importer_connect

Connect to database

Once you have added the database credentials, click on Connect and wait until the import is done.

importer_result

Import summary

Once the import in complete, you will see a summary of the import results:

Save data model

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.

importer_untitled

Name data model

Give your data model a name, "Movies Model", and Save it.

importer_named

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.

Chatbot

How can I help you today?