---
schema_version: "1"
id: b0067dd2629457ac6cf3f6b2998413e94fb482a8be8b5fa12f5d106b0e46137a
title: Create an External Data Source for Salesforce Connect SQL Adapter for Snowflake
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/snowflake_add_external_data_source.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.snowflake_add_external_data_source.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 77b3a6e689f0ad041ed60ac6f3d599973ece0c6a74389a3908c61f71ca8ffecf
description: Connect your Salesforce org to access Snowflake’s interactive query capabilities.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Create an External Data Source for Salesforce Connect SQL Adapter for Snowflake

Connect your Salesforce org to access Snowflake’s interactive query capabilities.

### 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 (not for
              high-data-volume external objects)</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> <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d28110e74">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e74 ">To create and edit external data sources:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e74 ">Customize Application</td>

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

1. From Setup, in the Quick Find box, enter External Data Sources, and then select **External Data Sources**.
2. Click **New External Data Source**, or click **Edit** to modify an existing external data source.
3. Complete these fields.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:25%">
              <col style="width:75%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28110e139">Field</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28110e142">Description</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e139 ">
                  <samp class="parmname">External Data Source</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e142 ">A user-friendly name for the external data source. The
                  label is displayed in the Salesforce user interface.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e139 ">
                  <samp class="parmname">Name</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e142 ">A unique identifier that’s used to refer to this external
                  data source definition through the API.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e139 ">
                  <samp class="parmname">Type</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e142 ">Select <strong class="uicontrol">SQL</strong>.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e139 ">
                  <samp class="parmname">Provider</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e142 ">Select <strong class="uicontrol">Snowflake</strong>.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e139 ">
                  <samp class="parmname">Named Credential</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e142 ">Enter the named credential URL that you defined for the
                  Snowflake data source.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e139 ">
                  <samp class="parmname">Connection Timeout (Seconds)</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e142 ">Number of seconds to wait for a response from the
                  Snowflake external system before timing out. By default, the
                  value is set to the maximum of 120 seconds.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e139 ">
                  <samp class="parmname">Writable External Objects</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e142 ">
                  <p>Select this option only if you want to create, edit, and delete data that’s
                    stored in Snowflake. By default, external objects are read only.</p>
                  <p style="margin-bottom:0;">Snowflake
                    views are always read only, even if you enable this option for other data
                    stored in Snowflake.</p>
                </td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e139 ">
                  <samp class="parmname">Server Driven Pagination</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28110e142 ">
                  <p>It's common for Salesforce Connect queries of external data to have a large
                    result set that's broken into smaller batches or pages. By default, the
                    Salesforce Connect SQL adapter for Snowflake uses server-driven paging, meaning
                    that Snowflake controls the paging behavior.</p>
                  <p style="margin-bottom:0;">To have the Salesforce Connect
                    SQL adapter control the paging behavior (client-driven), deselect this
                    checkbox. See <a href="https://help.salesforce.com/s/articleView?id=platform.snowflake_paging.htm&amp;release=264.0.0&amp;type=5" title="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).">Client-Driven and
                      Server-Driven Paging in the Salesforce Connect SQL Adapter for
                      Snowflake</a>.</p>
                </td>

              </tr>
            </tbody>
          </table>
4. Save your changes.

#### See Also

- [Work with External Data Sources](https://help.salesforce.com/s/articleView?id=platform.external_data_sources.htm&release=264.0.0&type=5 "An external data source specifies how to access an external system. Salesforce Connect uses external data sources to access data that's stored outside your Salesforce organization. Files Connect uses external data sources to access third-party content systems. External data sources have associated external objects, which your users and the Lightning platform use to interact with the external data and content.")
- [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.")