---
schema_version: "1"
id: 62551d5d9683639c4f84fdea19fc364400b7a0c1118d90798180ec650ed1d8ab
title: 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_sql_adapter_about.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.snowflake_sql_adapter_about.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 6c2301c5d0c639bc9118d3206ac2f6e445fe3b069ec260394633f6b564797740
description: Query structured data stored in Snowflake and combine it with the customer 360-degree view captured in Salesforce.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Salesforce Connect SQL Adapter for Snowflake

Query structured data stored in Snowflake and combine it with the customer 360-degree view captured in Salesforce.

### 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>

In many cases, Salesforce is the system of record for core customer information and sales, and details of all the customer’s orders are stored in Snowflake for scale reasons. With the Salesforce Connect SQL adapter for Snowflake, sellers or support agents have easy access to invoice, payment, shipment, and return data.

- **[Map Salesforce External Object Fields to Snowflake Data Types](https://help.salesforce.com/s/articleView?id=platform.snowflake_external_object_datatypes.htm&release=264.0.0&type=5)**  
    External object fields can be mapped to Snowflake data table columns with scalar types such as strings and numbers. External object fields can’t be mapped to columns containing complex or semi-structured data types such as a variant, object, or array.
- **[Set Up Salesforce Connect SQL Adapter for Snowflake](https://help.salesforce.com/s/articleView?id=platform.snowflake_setup.htm&release=264.0.0&type=5)**  
    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.
- **[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

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