Loading
Extend Salesforce with Clicks, Not Code
Manage Qualifiers for Salesforce Connect Adapter SQL for Snowflake

You are here:

  1. Salesforce Help
  2. Docs
  3. Extend Salesforce with Clicks, Not Code

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

Available in: both Salesforce Classic and Lightning Experience (not for high-data-volume external objects)

Available in: Developer Edition

Available for an extra cost in: Enterprise, Performance, and Unlimited Editions

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.
    Field Description
    Database The database that contains the table synced to this object. The database is auto-populated when the external data source is synced.
    Schema 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.
    Key Column Names

    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.

    Composite keys can be represented as a comma-delimited list. For example, ORDERID, PRODUCTID.

    Keep these considerations in mind when you specify key columns.

    • Don’t use columns that aren’t unique, such as BOOLEAN columns.
    • Ensure that the combination of key column values represents a unique value in the table.
  4. Save your changes.

See Also

 
Loading
Salesforce Help | Article