Using Virtual Graph with BigQuery

Support
1

Hi, we're trying to use the Virtual Graph functionality with BigQuery in Stardog 7.1.1 and we're getting errors when trying to set it up.

Assuming that we've built the docker image based on yours and there is a file /credentials/credentials.json in the server plus the required jars in "/opt/stardog/server/dbms", our JDBC properties file looks like the following:

base=virtual://myGraph
jdbc.url=jdbc:bigquery://https://bigquery.googleapis.com/bigquery/v2;RequestGoogleDriveScope=1;ProjectID=<PROJECT>;OAuthType=0;OAuthServiceAcctEmail=stardog-db@<PROJECT>.iam.gserviceaccount.com;OAuthPvtKeyPath=/credentials/credentials.json;LogLevel=6;LogPath=/log.out;Timeout=60
#jdbc.username=
#jdbc.password=
jdbc.driver=com.simba.googlebigquery.jdbc42.Driver

Running this with the stardog-admin command produces the following:

com/google/api/client/http/HttpResponseException
The detailed stack trace for the error is:
com.complexible.stardog.protocols.http.client.BaseHttpClient$HttpClientException: com/google/api/client/http/HttpResponseException
	at com.complexible.stardog.protocols.http.client.BaseHttpClient.checkResponseCode(BaseHttpClient.java:567)
	at com.complexible.stardog.protocols.http.client.BaseHttpClient.execute(BaseHttpClient.java:385)
	at com.complexible.stardog.protocols.http.client.BaseHttpClient.executeHttpPost(BaseHttpClient.java:710)
	at com.complexible.stardog.protocols.http.client.BaseHttpClient.executeHttpPost(BaseHttpClient.java:694)
	at com.complexible.stardog.protocols.http.client.HttpVirtualGraphAdminConnectionImpl.addOrUpdate(HttpVirtualGraphAdminConnectionImpl.java:215)
	at com.complexible.stardog.protocols.http.client.HttpVirtualGraphAdminConnectionImpl.addGraph(HttpVirtualGraphAdminConnectionImpl.java:162)
	at com.complexible.stardog.virtual.cli.VirtualGraphAdd.performSecure(VirtualGraphAdd.java:108)
	at com.complexible.stardog.cli.admin.SecureStardogAdminCommand.call(SecureStardogAdminCommand.java:61)
	at com.complexible.stardog.cli.CLIBase.execute(CLIBase.java:55)
	at com.complexible.stardog.cli.admin.CLI.main(CLI.java:197)
Caused by: com.complexible.stardog.StardogException: com/google/api/client/http/HttpResponseException
	at com.complexible.stardog.ErrorCodes.parseToThrowable(ErrorCodes.java:59)
	at com.complexible.stardog.protocols.http.client.BaseHttpClient.checkResponseCode(BaseHttpClient.java:534)
	... 9 more

In order to debug we executed the stardog instance locally and ran everything at trace level, but there is no indication whatsoever about what went wrong

2

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.