---
schema_version: "1"
id: 2033558d0b755ac0a854bce1ed5b764a87a17cb8df0fc4da39dc9687fec0ddbb
title: Considerations for Salesforce Connect Adapters for SQL
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/snowflake_considerations.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.snowflake_considerations.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 4874bcd569669593194b0f7cae465d2ff57b0850a3c06fa7c82f2cd48726eb4c
description: Understand the special behaviors, limits, and recommendations for using the Salesforce Connect adapters for SQL.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Considerations for Salesforce Connect Adapters for SQL

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

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition">
      <colgroup>
        <col>
      </colgroup>
      <tbody>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning
            Experience</td>

        </tr>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">
            <p>Available in: <strong>Developer</strong> Edition</p>
            <p style="margin-bottom:0;">Available for an extra cost
              in: <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong>
              Editions</p>
          </td>

        </tr>
      </tbody>
    </table>

- 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](https://help.salesforce.com/s/articleView?id=platform.snowflake_paging.htm&release=264.0.0&type=5)**  
    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).

#### See Also

- [Salesforce Connect](https://help.salesforce.com/s/articleView?id=platform.platform_connect_about.htm&release=264.0.0&type=5 "Salesforce Connect provides seamless integration of data across system boundaries by letting your users view, search, and modify data that’s stored outside your Salesforce org. For example, perhaps you have data that’s stored on premises in an enterprise resource planning (ERP) system. Instead of copying the data into your org, you can use external objects to access the data in real time via web service callouts.")
- [Salesforce Connect SQL Adapter for Snowflake](https://help.salesforce.com/s/articleView?id=platform.snowflake_sql_adapter_about.htm&release=264.0.0&type=5 "Query structured data stored in Snowflake and combine it with the customer 360-degree view captured in Salesforce.")
- [Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_adapter_about.htm&release=264.0.0&type=5 "Provide your users access to Amazon Athena’s capability to analyze data directly in Amazon Simple Storage Service (Amazon S3) and integrate AWS-hosted data in Salesforce applications.")