Understand the special behaviors, limits, and recommendations for using the Salesforce Connect adapters for SQL.
Required Editions
| Available in: both Salesforce Classic and Lightning Experience |
|
Available in: Developer Edition Available for an extra cost in: Enterprise, Performance, and Unlimited Editions |
- Including
COUNTand 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).