Warning: Cannot Select – Doesn't Support LIMIT

Issue

It's not possible to select a table in the Schema tab. The following warning appears:

Cannot select - Doesn't support LIMIT.

Environment

Connector: Salesforce

Resolution

It's not possible to select tables that don't support LIMIT. See our unsupported data types for more information.

Cause

Salesforce objects that don't support LIMIT can't be paginated. Querying these objects would return all records in the object. If there are too many records, the API request may time out.