Apoc.load.jdbc with bigquery

Neo4j Graph Platform Procedures & APOC
1

Hello there

Neo4j 4.2.2
apoc-4.2.0.0-all.jar

I'm using apoc.load.jdbc with the most recent bigquery driver.
I tired to make the following query work:

CALL apoc.load.jdbc('jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=nth-fiber-170600;OAuthType=0;OAuthServiceAcctEmail=neo4j-apoc@nth-fiber-170600.iam.gserviceaccount.com;OAuthPvtKeyPath=/var/lib/neo4j/plugins/nth-fiber-170600-ec1c59e774f6-jdbc.json', 'SELECT action_type FROM `patents-public-data.ebi_chembl.action_type` LIMIT 10', [], {autoCommit:true}) YIELD row
RETURN row

But I got this error:

Failed to invoke procedure apoc.load.jdbc: Caused by: com.fasterxml.jackson.core.JsonParseException: Illegal unquoted character ((CTRL-CHAR, code 10)): has to be escaped using backslash to be included in string value
at [Source: (FileInputStream); line: 5, column: 180]

It means that something is wrong in the key file provided ( I got it from a google service account). I attached a modified ( some letters and numbers changed ) version of it.

I checked, indeed the line 5 "private_key" is a bit different, and Neo4j is complaining about the end, a not standard one, but what I can do, if I modify it the key doesn't work anymore.

Thank you
qvs-project-200000-ec1c59e774f6-jdbc.json.txt (756 Bytes)

2

Update : The private key in my json file was wrong
This is how your json file should look like:

{
"type": "service_account",
"project_id": "project-id",
"private_key_id": "key-id",
"private_key": "-----BEGIN PRIVATE KEY-----\nprivate-key\n-----END PRIVATE KEY-----\n",
"client_email": "service-account-email",
"client_id": "client-id",
"auth_uri": "Sign in - Google Accounts",
"token_uri": "https://accounts.google.com/o/oauth2/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/service-account-email"
}