---
schema_version: "1"
id: 2f6e946450fe983a1394f695f300442d9b32198e5a0361ee76aad04994e3cff0
title: Set Up 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_setup.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.snowflake_setup.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 8664e560fa184a99d2534130dfad7c5cbd9f399e94fd8409be8e7eb16560216f
description: Provide users easy access to data stored in Snowflake so that they can build custom applications that combine the power of the Salesforce and Snowflake platforms.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Set Up Salesforce Connect SQL Adapter for Snowflake

Provide users easy access to data stored in Snowflake so that they can build custom applications that combine the power of the Salesforce and Snowflake platforms.

### 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="d88472e74">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">To create and edit external data sources:</td>

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

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">To create and edit external objects:</td>

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

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">To view named credentials:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">View Setup and Configuration</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">To create, edit, or delete named credentials:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">Manage Named Credentials or Customize Application</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">To create and edit custom fields:</td>

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

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">To edit permission sets and user profiles:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">Manage Profiles and Permission Sets</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">To edit another user’s authentication settings for external
              systems:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d88472e74 ">Manage Users</td>

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

Before you begin, review the basics of Snowflake setup and access in the [Snowflake Getting Started guide](https://docs.snowflake.com/en/user-guide-getting-started). We also recommend creating a view or dynamic table in Snowflake to limit the data that you want Salesforce users to be able to access.

- **[Define a Named Credential for Salesforce Connect SQL Adapter for Snowflake](https://help.salesforce.com/s/articleView?id=platform.snowflake_named_credentials_external_credentials.htm&release=264.0.0&type=5)**  
    Create a named credential that specifies the endpoint URL for Snowflake and an external credential to provide the required authentication parameters.
- **[Create an External Data Source for Salesforce Connect SQL Adapter for Snowflake](https://help.salesforce.com/s/articleView?id=platform.snowflake_add_external_data_source.htm&release=264.0.0&type=5)**  
    Connect your Salesforce org to access Snowflake’s interactive query capabilities.
- **[Validate and Sync External Data Source Configured for Snowflake](https://help.salesforce.com/s/articleView?id=platform.snowflake_ext_data_sync_database.htm&release=264.0.0&type=5)**  
    After you create an external data source for Snowflake, synchronize it to map its data to external objects in your Salesforce org.

#### 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.")
- [Manage Qualifiers for Salesforce Connect Adapter SQL for Snowflake](https://help.salesforce.com/s/articleView?id=platform.snowflake_manage_qualifiers.htm&release=264.0.0&type=5 "Tables and databases in Snowflake contain the metadata definitions for the underlying source data schema. To be able to make queries to Snowflake, use qualifiers to specify the key columns that identify records in the Snowflake data source.")