Setup Google BigQuery For Data Warehousing


With cloud services today like Google Cloud Platform (GCP) and Holistics, setting up a data warehouse is insanely simple. In this video, we’ll show you how to set up a Google BigQuery data warehouse in 3 minutes, and connect it to Holistics. BigQuery Stores the first 10 GB and processes 1 TB of queried data per month for free, which is pretty excellent for a free tier, so do make use of this.

First, setup and login to your Google Cloud Console. Select or create a project, navigate to BigQuery in your side menu, and create a new dataset. A dataset functions like a “folder” for your data tables that you want to upload.

Create a new BigQuery instance and setup a dataset.

Under the IAM & Admin menu, create a new service account with BigQuery access, to generate a JSON key for connecting BigQuery to Holistics, to manage our data.

Save this JSON file for later. Remember to give this account sufficient BigQuery role privileges, such as BigQuery Admin permissions.

Save your JSON file from your new service account to connect BigQuery later.

Now, to add a new data source to Holistics, just select BigQuery from the dropdown menu, copy your Google Project ID value from your Google console, paste the JSON key in, then test and save your BigQuery data source. That’s it! You’ve setup a data warehouse!

Your BigQuery data warehouse is now connected and ready!

Now you can begin moving data into BigQuery for your analytics. Use our Data Import features, to schedule the automatic import of data from other data sources and databases into BigQuery, to begin building your reports and dashboards.

Moving database tables from MySQL to PostgreSQL

For more information on how to start using Holistics, please have a look at our supporting documentation. If you have other questions you need help with, please feel free to contact us directly here. See you on Holistics!