---
schema_version: "1"
id: e663379041533d7f8e98046f06a96f2be1d37b46e47f3117e56eb373cba4b142
title: Validate and Sync External Data Source Configured for Snowflake
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/snowflake_ext_data_sync_database.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.snowflake_ext_data_sync_database.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 4ec5e69320bda1e2aa54be0e3d63fe42b249c8d24c4222459f304b5ef67adef3
description: After you create an external data source for Snowflake, synchronize it to map its data to external objects in your Salesforce org.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Validate and Sync External Data Source Configured for Snowflake

After you create an external data source for Snowflake, synchronize it to map its data to external objects in your Salesforce org.

### 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>Salesforce Connect is available in: <strong>Developer</strong> Edition and
                for an extra cost in: <strong>Enterprise</strong>, <strong>Performance</strong>, and
                <strong>Unlimited</strong> Editions
              </p>
              <p><span id="snowflake_ext_data_sync_database__files_connect_cloud_editions"><a name="snowflake_ext_data_sync_database__files_connect_cloud_editions"><!-- --></a>Files Connect for
                  cloud-based external data sources is available in:
                  <strong>Professional</strong>, <strong>Enterprise</strong>,
                  <strong>Performance</strong>, <strong>Unlimited</strong>, and
                  <strong>Developer</strong> Editions</span></p>
              <p style="margin-bottom:0;">Federated Search is
                available in: <strong>Enterprise</strong>, <strong>Professional</strong>,
                <strong>Unlimited</strong>, and <strong>Developer</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:49.01960784313725%">
          <col style="width:50.98039215686274%">
        </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="d46816e104">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d46816e104 ">To create an external object from an external data
              source:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d46816e104 ">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 the name of the external data source that you created for the Snowflake external system.
3. Click **Validate and Sync**.
4. Select the Snowflake database and schema that contains the tables you want to sync.
5. Select the data that you want to sync. The Salesforce Connect SQL adapter for Snowflake supports:
    - Tables
    - Dynamic tables
    - Views
6. Choose whether to run the sync as an asynchronous background job.
7. Click **Sync**.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_note.png)

Note Make sure that the external object field names exactly match the table column names in Snowflake. Otherwise, queries to Snowflake cause a runtime error.

After the external object and its fields are created, you must provide additional configuration so Salesforce can access Snowflake to run queries and respect settings configured by the Snowflake administrator. See [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.").

#### 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.")