Connect your Salesforce org to access Snowflake’s interactive query capabilities.
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 |
| User Permissions Needed | |
|---|---|
| To create and edit external data sources: | Customize Application |
- From Setup, in the Quick Find box, enter External Data Sources, and then select External Data Sources.
- Click New External Data Source, or click Edit to modify an existing external data source.
-
Complete these fields.
Field Description External Data Source A user-friendly name for the external data source. The label is displayed in the Salesforce user interface. Name A unique identifier that’s used to refer to this external data source definition through the API. Type Select SQL. Provider Select Snowflake. Named Credential Enter the named credential URL that you defined for the Snowflake data source. Connection Timeout (Seconds) Number of seconds to wait for a response from the Snowflake external system before timing out. By default, the value is set to the maximum of 120 seconds. Writable External Objects Select this option only if you want to create, edit, and delete data that’s stored in Snowflake. By default, external objects are read only.
Snowflake views are always read only, even if you enable this option for other data stored in Snowflake.
Server Driven Pagination It's common for Salesforce Connect queries of external data to have a large result set that's broken into smaller batches or pages. By default, the Salesforce Connect SQL adapter for Snowflake uses server-driven paging, meaning that Snowflake controls the paging behavior.
To have the Salesforce Connect SQL adapter control the paging behavior (client-driven), deselect this checkbox. See Client-Driven and Server-Driven Paging in the Salesforce Connect SQL Adapter for Snowflake.
- Save your changes.