Skip to main content

​
What it does

The BigQuery integration imports records from Google BigQuery into Bigdelta. This lets you bring data from your data warehouse into Bigdelta to enrich your customer profiles, power automations, and build more complete analytics.
The direction of this integration is import only — data flows from BigQuery into Bigdelta, not the other way around.

​
How to connect

1

Go to Settings then Integrations

Find the BigQuery card in the data section.
2

Click Set Up

A setup flow will guide you through the connection process.
3

Authenticate with Google

Grant Bigdelta access to your Google Cloud project and the relevant BigQuery datasets.
4

Configure the import

Select which BigQuery tables or views to import and map the fields to Bigdelta’s data model.
5

Wait for the initial sync

Bigdelta imports the selected data. The time required depends on the size of your dataset.
BigQuery integration configuration tab showing workspace objects mapped to datasets and tables with sync status and schedule

​
What data gets imported

BigQuery dataBigdelta dataDetails
Table rows / view resultsRecordsData is imported as records in Bigdelta based on your field mapping
The imported records can be used across Bigdelta — in lists, moments, automations, and analytics.

​
Use cases

  • Import product usage data stored in BigQuery to enrich customer profiles
  • Bring in custom scoring or segmentation data from your data warehouse
  • Combine BigQuery data with billing data for a complete customer view
Map a unique identifier field from your BigQuery data to match records in Bigdelta. This ensures imported data enriches existing customer profiles rather than creating duplicates.