Blog post coming soon...
- Build the fat jar using
gradle clean shadowJar
and copy to your$NEO4J_HOME/plugins
folder. - Set the Project ID and path to credentials file in
neo4j.conf
bigquery.project_id=neo4j-bigquery-test bigquery.key_file=/path/to/credentials.json
- Restart Neo4j
bigQuery.run(query [, useLegacySql])
Run the bigQuery.run
procedure with a query and optionally set the useLegacySql
argument to true.
CALL bigQuery.run('
SELECT id, title
FROM `bigquery-public-data.stackoverflow.posts_questions`
LIMIT 10
') YIELD row
Note: This library currently doesn't handle nested (repeated) elements well. If your query contains nested elements, you will have to un-nest them in the SQL query using UNNEST
.
UNNEST (hits) as hits
It's on the TODO list.