Skip to main content

BigQuery Connection Documentation

This guide explains how to access Kickbite data in BigQuery.

Written by Juan Garzon

All Kickbite customers have access to the aggregated datasets without any additional fees. You can use this to build internal reports or build agents.


To get access, please request from [email protected]. For that, you will need a Google/Gmail account. After that, the Kickbite team creates a ticket and then will inform you when the access has been granted. You will receive instructions and documentation.

After access, connect to the Project

  1. Open BigQuery Studio

  2. Click Add data

  3. Select the Star project by name

  4. Enter:

kickbite-view

Available Dataset

Inside the project kickbite-view, You will have access to the data set:

Main Views

Inside the dataset, you will find 4 main views:

kickbite-view.[client_placeholder].ds_channels
kickbite-view.[client_placeholder].ds_marketing
kickbite-view.[client_placeholder].ds_social
kickbite-view.[client_placeholder].ds_other


Important Note on Query Location

When running queries, make sure the data location is set to:

europe-west3

If the query location is set incorrectly, BigQuery may return an error.

Did this answer your question?