Sprinkle Docs
Search…
Google BigQuery
Guide to integrate your BigQuery with Sprinkle
This page covers the details about integrating BigQuery with Sprinkle.
When setting up BigQuery connection, Sprinkle additionally requires a Cloud bucket. This guide covers the role of all the components and steps to setup.

Step by Step Guide

Integrating BigQuery

STEP-1: Create a Service Account

Create a service account which will be used by Sprinkle to connect to BigQuery
  • Create a Service Account, provide any name like β€œsprinkle”.
  • In the service account, provide permission - BigQuery Admin role
  • Create a JSON key for this service account, and download it

STEP-2: Create a BigQuery dataset

Create a BigQuery dataset, provide any name like β€œsprinkle-dataset”. Sprinkle will create all tables within this Dataset.

STEP-3: Configure BigQuery Connection

  • Log into Sprinkle application
  • Navigate to Admin -> Drivers -> Create Warehouse
  • Select BigQuery
  • Provide all the mandatory details
    • Distinct Name: Name to identify this connection
    • Project Id: GCP Project Id
    • Private JSON key: Copy paste the contents of Json key downloaded in STEP-1
    • Dataset: Name of the dataset created in STEP-2 above
  • Test Connection
  • Create

Create Cloud Bucket

Sprinkle requires a Cloud Bucket to store intermediate data and report caches. Follow the below steps to create and configure cloud bucket:

STEP-1: Create a Cloud bucket

Create a Cloud bucket in the same GCP project, provide any name like β€œsprinkle” in the same location/region as your BigQuery project.

STEP-2: Provide Cloud Bucket access to Service Account Storage

This bucket should be accessible by BigQuery as well as Sprinkle application. So configure the access for the service account (created for BigQuery above)
Bucket -> Add Permissions -> Add Principal (provide the name of service account created in Bigquery setup above) -> Add Role Storage Admin
STEP-3: Configure GCP Cloud bucket connection in Sprinkle
  • Log into Sprinkle application
  • Navigate to Admin -> Drivers -> New Storage
  • Select GCP
  • Provide all the mandatory details
    • Distinct Name: Name to identify this connection
    • Private Key JSON: Copy paste the contents of Json key downloaded from the service account created in BigQuery setup
    • Bucket Name: Name of the bucket created above
  • Test Connection
  • Create
​
Last modified 5mo ago