Google BigQuery is a powerful data warehouse for enterprises that requires no infrastructure to manage. Helping you focus on analyzing data to find meaningful insights using familiar SQL.

Kloudio offers users an easy way to leverage Kloudio's reporting with a BigQuery integration that compiles user large datasets from your data warehouse in record time.

The following article will  help you get started:

  1. Create a BigQuery connection on Kloudio
  2. Setup your connection settings
  3. Start creating reports

STEP 1: Create a BigQuery connection

Go to Kloudio Connections and Click the button to create a New Connection. 

You will see the below screen. Click the Setup button under the BigQuery icon.

Enter your Google login information and proceed to Step 2.

STEP 2: Setup BigQuery sync settings

Now it's time to setup your  BigQuery data sync settings. 

This will enable you to sync large datasets.

Kloudio will do this on your behalf by invoking BigQuery APIs as per your configured sync frequency.

a) Connection name
b) Choose an existing database connection: This is where Kloudio will sync your BigQuery data. Once it's synced, it will be available for creating Kloudio reports in builder or SQL mode.
c) Choose a schema name where you'd like your data to be synced
d) You can also optionally use Kloudio's data warehouse in case you don't have any data warehouse to sync your data to.
e) Click Save & Sync

STEP 3: Create Kloudio reports from your BigQuery connection

Once the BigQuery connection is created and synced as per steps 1 and 2 above, you can create reports from large datasets.

This is like creating any other report as explained in the help article here for builder mode reports or the article here for SQL mode reports.

Please ensure you select the connection and schema as used in the BigQuery connection settings from Step 2. 

Feel free to chat with us or drop an email in case you have any questions related to this integration. 

Did this answer your question?