Salesforce integration
Salesforce data, in your warehouse.
A built-in connector both ways: load Salesforce into your warehouse, and push modelled data back with reverse ETL.
name: raw.user
type: ingestr
parameters:
source_connection: salesforce
source_table: 'user'
destination: snowflake
incremental_strategy: merge$ bruin run assets/raw/salesforce.asset.yml
- extract · Salesforce userincremental
- load · snowflake raw.usermerged
- checks · not_null, unique
Loaded and checked. Downstream models can run.
How it connects
Connected in three steps.
Cloud-based customer relationship management (CRM) platform providing sales automation, customer service, marketing analytics, and business process management.
- 01
Add a Salesforce connection with its credentials.
- 02
Pick the tables to load and how: replace, append or merge.
- 03
Bruin runs it on your schedule and checks every load.
- 04
To write modelled data back into Salesforce, point an ingestr asset at it as the destination (reverse ETL).
Tables
16 tables, ready to load.
useruser_roleopportunityopportunity_line_itemopportunity_contact_roleaccountcontactleadcampaigncampaign_memberproductpricebookpricebook_entrytaskeventcustom:<object_name>
Step-by-step
Pick a destination.
Salesforce → Snowflake
Read the guide
Salesforce → Google BigQuery
Read the guide
Salesforce → Databricks
Read the guide
Salesforce → Amazon Redshift
Read the guide
Salesforce → PostgreSQL
Read the guide
Salesforce → ClickHouse
Read the guide
Salesforce → DuckDB
Read the guide
Salesforce → MotherDuck
Read the guide
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
Sources
DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scrapingMove
Data IngestionCRM & sales
More tools, same category.
Frequently asked
Questions about Salesforce.
Does Bruin have a built-in Salesforce integration?
Yes. Built-in ingestr source. Built-in ingestr destination.
Which Salesforce tables can Bruin load?
user, user_role, opportunity, opportunity_line_item, opportunity_contact_role, account, contact, lead, campaign, campaign_member, product, pricebook, and 4 more.
Can Bruin write data back to Salesforce?
Yes, with reverse ETL. A regular ingestr asset reads a warehouse table and writes Salesforce records, matched on a field you choose (destination_table: 'Contact?external_id=Email').
Where can Salesforce data go?
Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect Salesforce?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.