Who gets this? Data Warehouse Push is currently only available in beta for Postscript brands on the Enterprise plan. To begin using Data Warehouse Push, please be sure to first contact your Customer Success Manager.
Data Warehouse Push allows Postscript to automatically send both historical and new data stored in-app, including clicks, order attribution, and more, to your designated data warehouse.
In this article, we'll walk you through the three steps for configuring your BigQuery destination.
IMPORTANT! Once complete, share the credentials with Postscript and we'll handle the rest.
Prerequisites
An active Google Cloud Platform (GCP) account with console Admin access
BigQuery API enabled
Cloud Storage JSON API enabled
A BigQuery dataset created (region must match your GCS bucket)
A Google Cloud Storage bucket (used for data staging; region must match your BigQuery dataset)
Step 1: Create a Service Account
Log in to the Google Cloud Console.
Navigate to IAM & Admin > Service Accounts and select Create Service Account.
Give it a name (e.g.
postscript-bigquery) and select Create and Continue.Assign the following roles:
BigQuery Admin (required for loading and managing data in BigQuery)
Storage Admin (required for staging data through Google Cloud Storage)
Select Done.
Step 2: Generate a JSON Key
From the Service Accounts list, select on the service account you created.
Go to the Keys tab and select Add Key > Create new key.
Select JSON and select Create.
The key file downloads automatically — keep it secure, you'll need to provide it to Postscript.
Step 3: Gather Your Connection Details
Provide Postscript with the following:
Field | Description |
JSON Key File | The JSON key file downloaded in Step 2 |
Project ID | Found on the GCP Console home page |
Project Number | Found on the GCP Console home page (a numeric value, distinct from the Project ID) |
Service Account Email | The email of the service account (e.g. |
BigQuery Dataset ID | The name of your BigQuery dataset |
GCS Bucket Name | The name of your Google Cloud Storage bucket |
Region | The GCP region for your dataset and bucket (e.g. |
Get Support
Have questions? Please feel free to reach out to our wonderful Support team at [email protected] or via live chat. You can also submit a support request here!
Need ongoing channel strategy guidance? Please fill out this form and we'll connect you to one of our certified partners.