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:
- Create a BigQuery connection on Kloudio
- Setup your connection settings
- 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.
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.