Most direct way to import a BigQuery RDBMS into a GraphDB

Neo4j Graph Platform Import / Export
1

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?

2

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
1 Like
3

Doesn't work for AuraDB:

CALL apoc.load.driver("com.mysql.jdbc.Driver");

Neo.ClientError.Procedure.ProcedureNotFound
There is no procedure with the name `apoc.load.driver` registered for this database instance. Please ensure you've spelled the procedure name correctly and that the procedure is properly deployed.