cancel
Showing results for 
Search instead for 
Did you mean: 

Most direct way to import a BigQuery RDBMS into a GraphDB

abalter
Node

I have a set of tables in a dataset in BigQuery. I have harmonized all of the column names so that related variables should be obvious. The tables have schema with data types and descriptions.

Is there a straightforward way to ingest this into Neo4j without having to first export to CSV files?

1 REPLY 1

Hi, @abalter !

You can ingest data directly from the RDBMS using apoc.load.jdbc() from the APOC library. See: https://neo4j.com/labs/apoc/4.1/database-integration/load-jdbc/

Additionally, you can use it along with apoc.periodic.iterate() to load the data in batches and in parallel. Example:

CALL apoc.periodic.iterate(
  'CALL apoc.load.jdbc("jdbc:mysql://localhost:3306/northwind?user=root","company")',
  'CREATE (p:Person) SET p += value',
  { batchSize:10000, parallel:true})
RETURN batches, total
Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.