0

I want to import a CSV file into Memgraph Cloud. I'm using 2GB free instance.

I tried to use LOAD CSV for a file located on AWS S3, but Memgraph Lab returns "Query failed: Load CSV not allowed on this instance because it was disabled by a config."

Is this limitation of the free version? Which options are available for loading data into Memgraph Cloud?

KWriter
  • 1,024
  • 4
  • 22

1 Answers1

1

This is not related to the fact that you are using a free version of Memgraph Cloud.

Memgraph Cloud doesn’t support importing data from CSV files directly. Both the LOAD CSV clause and the CSV Import Tool require access to the local file system, and this is not possible when it comes to Memgraph Cloud.

There are two options you could try out:

  1. Import the data programmatically by connecting to the instance via driver. This way, you could use each entry in your CSV file to execute a Cypher CREATE query.

  2. Using the .cypherl bulk import 2 in Memgraph Lab. You can transform your CSV entries into Cypher CREATE queries and save them to a file with the extension .cypherl. Such a file can be imported by going to Memgraph Lab → Datasets tab → Select or drag and drop a file.

You can look up documentation on the Memgraph website.

KWriter
  • 1,024
  • 4
  • 22