# Bulk Import to Neo4j Cluster without Server Access

**URL:** <https://community.neo4j.com/t/bulk-import-to-neo4j-cluster-without-server-access/69366>\
**Category:** Import / Export\
**Created:** [August 22, 2024, 11:07pm UTC](https://community.neo4j.com/t/bulk-import-to-neo4j-cluster-without-server-access/69366 "2024-08-22T23:07:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![james.matt.west](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@james.matt.west](https://community.neo4j.com/u/james.matt.west)\
**Post date:** [August 22, 2024, 11:07pm UTC](https://community.neo4j.com/t/bulk-import-to-neo4j-cluster-without-server-access/69366/1 "2024-08-22T23:07:41Z")

</div>

Hi all,

I've been working with neo4j on my local using docker containers. It has been very easy and seamless to use the admin import with csv files. I am working to move my project to production servers and I am receiving some pushback from the database team. They do not want to give me access to the neo4j servers, just the database.

So, I wanted to reach out to this community to ask some questions. Is there any other options to use for bulk import, lets say \>1,000,000 records, without access to the base neo4j servers?

From my understanding, the load csv commands still require the files to be in the import directory unless certain database properties are updated. With the security risks associated with exposing a database to outside import, it seems unlikely that this would be used. Is it also a possiblity to temporarily expose the database to outside import and then updating this property afterwards to close off outside import?

Thanks for the help

---

<div class="post-metadata">

**Author:** ![glilienfield](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/glilienfield/32/27534_2.png) [@glilienfield](https://community.neo4j.com/u/glilienfield)\
**Post date:** [August 22, 2024, 11:31pm UTC](https://community.neo4j.com/t/bulk-import-to-neo4j-cluster-without-server-access/69366/2 "2024-08-22T23:31:58Z")

</div>

Load CSV allows files to be read from an http server, so you can host them and read them remotely.

Here are two examples from the documentation:

//Example 1 - website  
LOAD CSV FROM '[https://data.neo4j.com/northwind/customers.csv](https://data.neo4j.com/northwind/customers.csv)'

//Example 2 - Google  
LOAD CSV WITH HEADERS FROM '[https://docs.google.com/spreadsheets/d/](https://docs.google.com/spreadsheets/d/)/export?format=csv'

> **[Importing CSV data into Neo4j - Getting Started](https://neo4j.com/docs/getting-started/data-import/csv-import/?utm_source=Google&utm_medium=PaidSearch&utm_campaign=Evergreen&utm_content=AMS-Search-SEMCE-DSA-None-SEM-SEM-NonABM&utm_term=&utm_adgroup=DSA&gad_source=1&gbraid=0AAAAADk9OYpBlU1_P13eo6Tccr7xoCwW1&gclid=EAIaIQobChMI1I2DiuCJiAMVCExHAR0jXBxlEAAYASAAEgK3qPD_BwE#_reading_csv_files)**
>
> This article demonstrates different approaches to importing CSV data into Neo4j and solutions to potential issues that might arise during the process.

You can use Call Subquery in Transaction to make it more efficient for large datasets.

> **[Importing CSV data into Neo4j - Getting Started](https://neo4j.com/docs/getting-started/data-import/csv-import/?utm_source=Google&utm_medium=PaidSearch&utm_campaign=Evergreen&utm_content=AMS-Search-SEMCE-DSA-None-SEM-SEM-NonABM&utm_term=&utm_adgroup=DSA&gad_source=1&gbraid=0AAAAADk9OYpBlU1_P13eo6Tccr7xoCwW1&gclid=EAIaIQobChMI1I2DiuCJiAMVCExHAR0jXBxlEAAYASAAEgK3qPD_BwE#optimizing-load-csv)**
>
> This article demonstrates different approaches to importing CSV data into Neo4j and solutions to potential issues that might arise during the process.

---

<div class="post-metadata">

**Author:** ![glilienfield](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/glilienfield/32/27534_2.png) [@glilienfield](https://community.neo4j.com/u/glilienfield)\
**Post date:** [August 22, 2024, 11:37pm UTC](https://community.neo4j.com/t/bulk-import-to-neo4j-cluster-without-server-access/69366/3 "2024-08-22T23:37:00Z")

</div>

APOC also has a load json method that takes a url, so if you can convert to a json format this may also be an option.

> **[Load JSON - APOC Documentation](https://neo4j.com/docs/apoc/current/import/load-json/)**
>
> This section describes procedures that can be used to import JSON data from web APIs or files.
