Skip to content
adapters.io

Salesforce to BigQuery integration for analytics-ready CRM data

The Salesforce to BigQuery integration from Adapters loads accounts, contacts, opportunities, and activity from Salesforce into BigQuery tables on an incremental schedule, so your warehouse stays analytics-ready without draining Salesforce API limits. Field mapping takes about a minute and no code is required.

Try it in the live demo

Field mapping auto-plugged · tap a port to rewire

5 sample records ready

Last updated July 2026

What running Salesforce to BigQuery by hand costs you

  • Full object exports burn Salesforce API calls and hit daily governor limits during business hours.
  • Hand-built Python loaders break the moment someone adds a custom field or renames an object.
  • Stale CRM data in BigQuery means Looker Studio dashboards and models report last week, not today.

The field mapping, out of the box

These cables are pre-wired when you pick the pair. Rewire any of them, or add your own, in the same visual data mapping tool you use for every adapter.

Input / SALESFORCE

Account.Id
dim_account.account_id
Account.Name
dim_account.account_name
Opportunity.Amount
fct_opportunity.amount
Opportunity.StageName
fct_opportunity.stage
Opportunity.CloseDate
fct_opportunity.close_date
SystemModstamp
fct_opportunity.loaded_at

Transforms included

Incremental loads use the Salesforce SystemModstamp watermark so each run only moves changed rows into BigQuery; Salesforce field types cast to BigQuery column types, currency stays NUMERIC, timestamps land as TIMESTAMP in UTC, and tables partition by load date so dbt models and Looker Studio read a clean, deduplicated table without scanning the whole history.

How it goes live

Three steps, minutes end to end, covered by flat data integration pricing from $49 a month.

STEP 01

Pick the pair

Connect Salesforce and BigQuery with scoped credentials. About a minute each.

STEP 02

Confirm the mapping

The cables above are pre-wired. Adjust any field, preview the transform on sample records, done.

STEP 03

Schedule the sync

Hourly down to every minute, with retries, alerting, and a full log on every run.

Try it in the live demo Preloads SALESFORCE → BIGQUERY with sample records

More pairs from the API connector library

stripe quickbooks integration shopify netsuite integration salesforce hubspot integration airtable google sheets sync postgres to snowflake sync shopify quickbooks integration salesforce netsuite integration paypal quickbooks integration square quickbooks integration stripe netsuite integration hubspot quickbooks integration quickbooks to xero migration shopify xero integration salesforce to snowflake integration square netsuite integration hubspot xero integration postgres to bigquery netsuite to snowflake integration quickbooks to bigquery integration stripe to snowflake integration shopify to snowflake integration quickbooks to snowflake integration hubspot to snowflake integration netsuite to bigquery integration stripe to bigquery integration shopify to bigquery integration paypal to snowflake integration square to snowflake integration square to bigquery integration netsuite to postgres integration salesforce to postgres integration xero to snowflake integration hubspot to bigquery integration xero to bigquery integration paypal to bigquery integration stripe to postgres integration snowflake to bigquery migration shopify to postgres integration hubspot to postgres integration bigquery to snowflake migration quickbooks to postgres integration xero to postgres integration square to postgres integration paypal to postgres integration snowflake to postgres

Browse the full api connector library, or request a pair you do not see.

Salesforce and BigQuery, finally in agreement

Map the pair once and let it sync on schedule. Flat price from $49 a month, no per-task fees.

Try the live demo