Snowflake
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.
Snowflake
Corresponding Salesforce type
NUMBER
NUMBER_TYPE if the precision is < 18, otherwise STRING_SHORT_TYPE
FLOAT
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.
VARCHAR
STRING_SHORT_TYPE if the max length is <255, otherwise STRING_LONG_TYPE
BINARY
Not supported
BOOLEAN
NUMBER_TYPE
(not BOOLEAN_TYPE, because NULL values wouldn't be supported)
DATE
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.
TIMESTAMP
DATETIME_TYPE
TIME
Not supported
VARIANT
Not supported
OBJECT
Not supported
ARRAY
Not supported
Copy link
On this page
Snowflake Account Prerequisites
Authentication Methods
Supported Data Types