public
Last active

Setting up your local BIG QUERY SAIKU

  • Download Gist
gistfile1.txt
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Just copy over the jars in here into your local saiku:
 
saiku-server/tomcat/webapps/saiku/WEB-INF/lib
 
The "biq" file goes into:
saiku-server/tomcat/webapps/saiku/WEB-INF/classes/saiku-datasources
 
the bigquery.mondrian.xml goes into
saiku-server/tomcat/webapps/saiku/WEB-INF/classes/
 
CREATING A USER FOR BIG QUERY:
You will have to do the following to access the datasets:
Go to: https://code.google.com/apis/console/
Register
Set up the Google Big Query under Services
Create a new service account.
Download the key
Put the email address of that service account as the username into the biq file
Set the path to the key file as password in that file

Hi,
I'm hopeful to use Saiku with Google BigQuery and this is the only configuration reference I can find so far. Could you please post further details, e.g., which jar files you used and the "biq" file you reference? Thanks

UPDATE: Found details via Twitter: https://twitter.com/SaikuAnalytics/status/268750786136260609

Hi,
Are there any additional steps to be configured on Windows?

Tried this on windows 7 with Saiku, but wouldn't work. Either get a ArrayIndex out of bounds or java.lang.FieldError:BIGQUERY.

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.