Google BigQuery - data

Google BigQuery is a serverless, cost-effective enterprise data warehouse that works across clouds and scales with your data. You can use built-in ML/AI and BI capabilities to gain insights at scale. BigQuery’s serverless architecture lets you analyze your data using SQL queries or assess your data where it lives. Connect BigQuery with Blueshift to sync customer data, catalogs, events, and campaign reports.

Capability comparison

Capability	Direct integration
Import customer data, events, and catalogs	✓
Export campaign reports	✓
Real-time sync	✓

---

Direct integration with BigQuery

With direct integration, Blueshift can import customer data, catalogs, and real-time events from BigQuery to build a 360-degree view of your customers. You can also export campaign activity reports to BigQuery and analyze them with BI tools.

Service Account

Blueshift requires credentials for a Service Account with the BigQuery User and BigQuery Data Editor roles. This grants permissions to run BigQuery jobs, write to datasets, and read table metadata. We recommend using a dedicated Service Account for Blueshift.

To create a Service Account, follow the Google documentation.

Service Account Key

Create and download a JSON Service Account Key. This is required to authenticate Blueshift’s access. After adding it to Blueshift, delete the local copy of the key for security.

For details, see Creating and Managing Service Account Keys.

Back to top ↑

---

Set up integration

To give Blueshift access to the data in BigQuery, complete the following steps:

Step 1: Create an adapter in Blueshift

• Sign in to the Blueshift app and click App Hub in the left navigation menu.
• Go to All Apps, search for, and select BigQuery.
• You can also go to Data Warehouse Apps and select BigQuery.
• Click Configure to view all configured adapters.
• Click +ADAPTER to add an adapter.
• Add a Name for the adapter. If you have multiple adapters, the name helps you identify the integration.

Step 2: Provide connection details

Field	Details
Project ID	The GCP/BigQuery project from which you want to import data.
Default Dataset ID	The dataset within the project from which you want to import data.
Credential JSON	The Service Account key JSON file generated in the prerequisites step.

Step 3: Authenticate & save

• Paste or upload your JSON Service Account Key.
• Click Check Access Status to verify connectivity.
• Once verified, click Save to complete setup.

Back to top ↑

---

Import data

Complete the prerequisites and set up the direct integration first. After the setup is complete, you can create a task to import data into Blueshift.

Once you have set up the integration, you can start importing the recommendation feeds, customer data, catalogs, and event data.

Export data

Export campaign activity reports from Blueshift to BigQuery to analyze campaign performance using BI or advanced analytics tools.

Back to top ↑

---