Google Cloud Bucket
Sprinkle requires a Cloud Storage Bucket to store intermediate data and report caches.
Follow the below steps to create and configure a Google Cloud Bucket:
STEP-1: Create a Cloud bucket
Section titled “STEP-1: Create a Cloud bucket”Create a Cloud bucket in the same GCP project, and provide any name like “sprinkle” in the same location/region as your BigQuery project.
STEP-2: Provide Cloud Bucket access to Service Account Storage
Section titled “STEP-2: Provide Cloud Bucket access to Service Account Storage”This bucket should be accessible by BigQuery as well as the 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 the GCP Cloud bucket connection in Sprinkle
- Log into the 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 and paste the contents of the JSON key downloaded from the service account created in the BigQuery setup
- Bucket Name: Name of the bucket created above
- Test Connection
- Create