Considerations for Salesforce Connect Adapters for SQL

Understand the special behaviors, limits, and recommendations for using the Salesforce Connect adapters for SQL.

Available in: both Salesforce Classic and Lightning Experience

Available in: Developer Edition

Available for an extra cost in: Enterprise, Performance, and Unlimited Editions

Including COUNT and other aggregation projections in the same SOQL query isn’t supported for the Salesforce Connect SQL adapters for Amazon Athena and Snowflake.
If you plan to write Apex code with custom SOQL queries or Apex SOQL for-loops against data from a Snowflake external data source, we recommend using client-driven pagination. With these types of queries, client-driven pagination ensures that Snowflake returns only page sizes of up to 2,000 rows.

Client-Driven and Server-Driven Paging in the Salesforce Connect SQL Adapter for Snowflake
It’s common for Salesforce Connect queries of external data to have a large result set that’s broken into smaller batches or pages. You decide whether to have the paging behavior controlled by the external system (server-driven) or by the SQL adapter for Salesforce Connect (client-driven).

Product Area