Skip to content

Yo dawg, I heard you like queries so we put some BigQuery in your query so you can query BigQuery from your query

Notifications You must be signed in to change notification settings

adam-cowley/neo4j-bigquery

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Neo4j & BigQuery

Blog post coming soon...

Installation

  1. Build the fat jar using gradle clean shadowJar and copy to your $NEO4J_HOME/plugins folder.
  2. 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
    
  3. Restart Neo4j

Usage

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.

About

Yo dawg, I heard you like queries so we put some BigQuery in your query so you can query BigQuery from your query

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages