Query structured data stored in Snowflake and combine it with the customer 360-degree view captured in Salesforce.
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 |
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
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
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
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.