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.
Connect Salesforce
- On the nav bar, click Browse → Semantic Layer.
- In the sidebar, select Live data sources, then click Add.
- Select Salesforce.
- Enter a Name, such as
Salesforce. - Click Continue to Salesforce, sign in and allow access.
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.”