Salesforce Docs Portal

Validate and Sync External Data Source Configured for Snowflake

After you create an external data source for Snowflake, synchronize it to map its data to external objects in your Salesforce org.

Required Editions

Available in: both Salesforce Classic and Lightning Experience

Salesforce Connect is available in: Developer Edition and for an extra cost in: Enterprise, Performance, and Unlimited Editions

Files Connect for cloud-based external data sources is available in: Professional, Enterprise, Performance, Unlimited, and Developer Editions

Federated Search is available in: Enterprise, Professional, Unlimited, and Developer Editions

User Permissions Needed
To create an external object from an external data source: Customize Application
  1. From Setup, in the Quick Find box, enter External Data Sources, and then select External Data Sources.
  2. Click the name of the external data source that you created for the Snowflake external system.
  3. Click Validate and Sync.
  4. Select the Snowflake database and schema that contains the tables you want to sync.
  5. Select the data that you want to sync. The Salesforce Connect SQL adapter for Snowflake supports:
    • Tables
    • Dynamic tables
    • Views
  6. Choose whether to run the sync as an asynchronous background job.
  7. Click Sync.
Note
Note Make sure that the external object field names exactly match the table column names in Snowflake. Otherwise, queries to Snowflake cause a runtime error.

After the external object and its fields are created, you must provide additional configuration so Salesforce can access Snowflake to run queries and respect settings configured by the Snowflake administrator. See Manage Qualifiers for Salesforce Connect Adapter SQL for Snowflake.

See Also