How to Connect to Snowflake

Snowflake is a cloud-based data platform that offers flexible data warehouse offerings.

In Strategy, users can directly connect to Snowflake using shipped drivers and connectors to query Snowflake's data, enabling advanced analytics, dashboard creation, and report generation on Snowflake-stored data, leveraging Strategy's extensive analytical and visualization tools. This seamless integration empowers organizations to make data-driven decisions with real-time insights derived from their Snowflake data warehouse.

Follow Strategy Best Practices for Securing Snowflake Connections to establish secured connectivity to Snowflake in Strategy.

Strategy only supports Standard (username/password), OAuth, Key Pair, and PAT (Programmatic Access Token) authentication modes when connecting to Snowflake. Warehouse pass-through authentication is also supported.

Kerberos, Delegation UID, Integrated, and external browser authentication modes are not supported.

Certified Drivers

Certified Driver	Snowflake ODBC	Snowflake Native JDBC
Linux - Server	Y	Y
Managed Cloud Government	N	Y
Customer Manager Cloud	Y	Y
Managed Cloud Environment	Y	Y
Windows - Server	Y	Y
Windows - Workstation	Y	Y

Supported Authentication Methods

Driver	Standard	OAuth	Key Pair	PAT
ODBC	Y	Y	Y	N
JDBC	Y	Y	Y	N

	Single Sign-On OIDC			SAML
StrategyProduct	Entra ID (formerly Azure AD)	Okta	Generic	Entra ID (formerly Azure AD)
Workstation	Y	Y	Y	N
Library	Y	Y	Y	N
Web	Y	Y	Y	N

Strategy supports SAML SSO when using SAML to login to Strategy but using OAuth to connect with Snowflake.

OAuth IDP

OAuth Workflow	Entra ID (formerly Azure AD)	Okta	PingOne	Generic
Authentication Code	Y	Y	Y	Y
Client Credential	Y	Y	N	N

Supported Features

Feature	TLS Connection	Parameterized Query	Unified Quoting	Timezone
Support Status	Y	Y	Y	Y