CONNECTOR · SALESFORCE
Salesforce — Bulk API exports of accounts, opportunities, leads.
CONNECTOR · SALESFORCE
Salesforce
Bulk API exports of accounts, opportunities, leads.
- categorySource · CRM
- freshness targetHourly via Bulk API; near-real-time via Streaming if licensed.
- auth modelConnected app + OAuth refresh token.
- sync modeBulk API extract → staging.
TABLES SYNCED
Account, Contact, Lead, Opportunity, OpportunityLineItem, Campaign.
SCHEMA · SAMPLE
schema.sqlSQL
CREATE TABLE sfdc.opportunity (
Id TEXT PRIMARY KEY,
AccountId TEXT,
Amount NUMERIC,
StageName TEXT,
CloseDate DATE,
IsWon BOOLEAN
);QUERY · SAMPLE
query.sqlSQL
SELECT StageName, COUNT(*) AS n, SUM(Amount) AS pipeline
FROM sfdc.opportunity
WHERE CloseDate >= CURRENT_DATE - INTERVAL 0
GROUP BY 1 ORDER BY 3 DESC;OPS NOTES
API limits will throttle a naive backfill. We chunk by CloseDate windows and respect the rolling 24h limit.
Wire a real pipeline to your warehouse
30-min stack review. We come back with a scoped plan, an owner, and a freshness contract. No SDR, no slide deck.