Skip to main content
The Salesforce live data source reads opportunities, accounts, leads and contacts from your Salesforce org, one table each. Salesforce computes counts, sums and averages with SOQL, so most questions take one API call. It’s a level 4 integration: its API runs its own query language, including totals.

Before you start

  • Live data sources enabled for your organization. See Live data sources.
  • Admin role in the Lightdash project.
  • A Salesforce user with the “API Enabled” permission and read access to the objects you want to query.
  • A production org, such as a company org or a Developer Edition org. Sandbox orgs aren’t supported.
If Salesforce shows a Request button instead of connecting, your instance doesn’t have a Salesforce Connected App. On a self-hosted instance, configure one.

Connect Salesforce

  1. On the nav bar, click Browse → Semantic Layer.
  2. In the sidebar, select Live data sources, then click Add.
  3. Select Salesforce.
  4. Enter a Name, such as Salesforce.
  5. Click Continue to Salesforce, sign in and allow access.
Lightdash checks that the user can read at least one of the objects, then adds Opportunities, Accounts, Leads and Contacts tables to Explore. A table whose object the user can’t read keeps only its built-in fields. Connecting also scans each object’s own fields, including custom fields. Scanned fields start hidden. Turn on the ones you want, and scan again after adding fields in Salesforce.

Fields

Long text areas, multi-select picklists and hidden fields aren’t available.

Supported features

Limits

A query with metrics is one call to Salesforce. A list of records without metrics takes one call for every 2,000 rows. When a query has more rows than these limits, Lightdash shows an error rather than a partial result. Calls count toward your org’s daily API limit.

Example questions

  • “Open pipeline amount by stage.”
  • “Opportunities won per month this year, by owner.”
  • “Leads created last week by source.”

Troubleshooting

The org has used its API calls for the last 24 hours. Salesforce limits API calls per org. Try again later or ask your Salesforce admin about the limit. The API isn’t enabled for this user. Give the user the “API Enabled” permission, then choose Sign in again. A field doesn’t exist. The field was renamed or removed in Salesforce. Scan the source again.