Skip to content

Instantly share code, notes, and snippets.

@pstoellberger

pstoellberger/gist:4073088

Created November 14, 2012 16:22
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pstoellberger/4073088 to your computer and use it in GitHub Desktop.
Save pstoellberger/4073088 to your computer and use it in GitHub Desktop.
Download ZIP
Setting up your local BIG QUERY SAIKU
Raw
gistfile1.txt
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
@ackdesha
Copy link

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

@mreddimasi
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment