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:
- From Setup, in the Quick Find box, enter External Data Sources, and then select External Data Sources.
- Select the external data source to edit.
-
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.
- Save your changes.