---
schema_version: "1"
id: 1e8392018285848e04da6951945ea0b86c602aef232da9f9ed541650ad0cf772
title: Manage Qualifiers for Salesforce Connect Adapter SQL for Snowflake
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/snowflake_manage_qualifiers.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.snowflake_manage_qualifiers.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 766f7154d434b5f9ba4b09167ce9738af2a2876633b95315d9bde6e43046ccf8
description: 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.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Manage Qualifiers for Salesforce Connect Adapter SQL for Snowflake

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.

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

When you query a Snowflake table, the data catalog and database that you configured determine the table location. To provide additional configuration:

1. From Setup, in the Quick Find box, enter External Data Sources, and then select **External Data Sources**.
2. Select the external data source to edit.
3. Under External Objects, select the synced external object to which you want to add qualifiers, and then click Manage Qualifiers.
    
    <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="d191628e111">Field</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d191628e114">Description</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d191628e111 ">
                  <samp class="parmname">Database</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d191628e114 ">The database that contains the table synced to this
                  object. The database is auto-populated when the external
                  data source is synced.</td>

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

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d191628e114 ">The schema of the database that contains the table synced
                  to this object. The schema is auto-populated when the
                  external data source is synced.</td>

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

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d191628e114 ">
                  <p>Specify the column names that represent a unique key for
                    a row in the synced Snowflake table. The Salesforce Connect
                    SQL adapter uses these column values to build an external ID
                    for external object records in Salesforce.</p>
                  <p>Composite keys
                    can be represented as a comma-delimited list. For
                    example, <code>ORDERID,
                                                PRODUCTID</code>.</p>
                  <p>Keep these considerations
                    in mind when you specify key columns.</p>
                  <ul>
                    <li>Don’t use columns that aren’t unique, such as
                      BOOLEAN columns.</li>
                    <li>Ensure that the combination of key column values
                      represents a unique value in the table.</li>
                  </ul>
                </td>

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

#### See Also

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