# Transferring BigQuery Data to Neo4J

**URL:** <https://community.neo4j.com/t/transferring-bigquery-data-to-neo4j/60141>\
**Category:** Neo4j Graph Platform\
**Tags:** migrated\
**Created:** [July 24, 2022, 1:55pm UTC](https://community.neo4j.com/t/transferring-bigquery-data-to-neo4j/60141 "2022-07-24T13:55:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pinakin](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/pinakin/32/26258_2.png) [@pinakin](https://community.neo4j.com/u/pinakin)\
**Post date:** [July 24, 2022, 1:55pm UTC](https://community.neo4j.com/t/transferring-bigquery-data-to-neo4j/60141/1 "2022-07-24T13:55:07Z")

</div>

Hey Guys,

I have 2 needs as of now where I need some guidance desperately(I am new to Neo4J as well):  
So, for one of my projects, I need to build ETL pipelines within GCP for:  
1. Transferring the Historical data from BigQuery to Neo4J  
2. Transferring the Incremental data from BigQuery to Neo4J

Now, I am done with creating my pipelines in BQ for incremental load.  
How should I proceed?  
I can see some approaches suggesting:  
1. Airflow. Will it work for huge amount of data? Will it be able to scale? Also, I think it will take time to load the data into Neo4J if the data volume is huge.(p.s.: Although, client doesn't have an existing composer instance; so, it will be painful to convince them for the same. If need be, and if there is no option, then I will do it).  
2. The second approach that I could find was using Cloud DataProc where Apache Spark jobs can be written with Neo4J Connector.

Any suggestions on which approach should I follow? If there is any other approach than these, feel free to let me know. It will help me a ton!

Regards,  
Pinakin

---

<div class="post-metadata">

**Author:** ![tard\_gabriel](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/tard_gabriel/32/28033_2.png) [@tard\_gabriel](https://community.neo4j.com/u/tard_gabriel)\
**Post date:** [July 24, 2022, 5:14pm UTC](https://community.neo4j.com/t/transferring-bigquery-data-to-neo4j/60141/2 "2022-07-24T17:14:13Z")

</div>

If your data are that huge, you can also choose to export your tables as neo4j formated csvs in cloud storage then retreive these csv in your neo4j environment and using [neo4j-admin import tool](https://neo4j.com/docs/operations-manual/current/tools/neo4j-admin/neo4j-admin-import/).

It's THE tool for massive data