Snowflake is an advanced data platform provided as Software-as-a-Service (SaaS).

Snowflake Account Prerequisites

You must have a Snowflake account, preferably in the same region as your Salesforce account.
  1. 1.
    The Virtual Private Snowflake Edition is not supported, as Salesforce must be able to reach a public endpoint.
  2. 2.
    If you use Network Policies in Snowflake, you must allowlist the Salesforce addresses for your region.
  3. 3.
    You must create a Snowflake user which belongs to a role that can read the tables/views.

Authentication Methods

When using the original (not publicly documented) Snowflake SQL API, the following are supported:
  • Username & Password
  • OAuth
When using the newer official Snowflake SQL API, the following are supported:
  • JWT (certificate based)
  • OAuth

Note on OAuth tokens

By default, Snowflake OAuth refresh tokens only last 90 days, which means the OAuth connection between Salesforce and Snowflake would need to be manually re-authenticated every 90 days, which is generally considered impractical.
To increase this to, for example, 5 years, you must log a ticket with Snowflake support and ask that the maximum OAUTH_REFRESH_TOKEN_VALIDITY for a SECURITY INTEGRATION be raised to 157784630 seconds.

Supported Data Types

The following table describes the current mapping between Snowflake data types and Salesforce.
Corresponding Salesforce type
NUMBER_TYPE if the precision is < 18, otherwise STRING_SHORT_TYPE
Floating point numbers are not supported by Apex, but the adapter converts them to STRING_SHORT_TYPE to allow them to be displayed.
For proper treatment as a number, the Snowflake type NUMBER should be used instead.
STRING_SHORT_TYPE if the max length is <255, otherwise STRING_LONG_TYPE
Not supported
(not BOOLEAN_TYPE, because NULL values wouldn't be supported)
Dates are not supported by Salesforce Connect, but the adapter converts to DATETIME_TYPE (at midnight) for convenience.
This makes them usable but potentially misleading.
Not supported
Not supported
Not supported
Not supported
Copy link
On this page
Snowflake Account Prerequisites
Authentication Methods
Supported Data Types