We use Google BigQuery to share our data with our partners. This allows us to share data in a secure and scalable way but also allow you to decided how fresh you want the data to be.
BigQuery provides a number of advantages from an integration perspective:
- BigQuery is natively supported by all major BI tools (e.g. Tableau, Looker, PowerBI, Qlik etc.)
- Storage and query costs are separate, this allows Triptease to cover all storage costs and you only pay for the queries you run that are outside the free tier. This allows you to choose between on-demand or scheduled refreshes of your data.
See the Data page for a full list of available data sources.
You will need the following:
- A BigQuery account (either a user and/or service account)
- You can signup for the free tier here
- A BigQuery project where you want the data to be visible
- You can create a project here
Once you have both of those you need to share your BigQuery account with Triptease so we can share the data with you.
NB. Having both a service account and a user account is recommended as it allows you to explore the data as a user and then use the service account for automated processes etc (Like BI Access).
Google BigQuery has a free tier that allows you to run 1TB of queries per month for free. This should easily cover most use cases including querying the data multiple times a day. If however you run complex queries that process most of your data many times a day, you could start to be charged by Google. In this case you will either want to copy the data into your own data-warehouse or enable query caching in your BI tool of choice.
Once Triptease has added your account, you can then follow this link
If prompted click the "ENABLE" button to allow access to Analytics Hub
Then you should see a listing similar to this
Click on the listing and then click "ADD DATA SET TO PROJECT"
Once you have done this you should see a message to "GO TO LINKED DATASET"
From here you can explore the data and write SQL queries directly in your browser.
One you have setup and tested access from BigQuery, you can now use the service account to setup access from BigQuery to your BI tool of choice:
Google Looker Configure BigQuery
Tableau Desktop -> Google BigQuery
Microsoft Power BI Google BigQuery Connection
Qlik Create Google BigQuery Connection