Strategy One
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
| 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
| Entra ID (formerly Azure AD) | Okta | Generic |
|---|---|---|
| Y |
Y |
Y |
Supported Features
| Feature | TLS Connection | Parameterized Query | Unified Quoting | Timezone |
|---|---|---|---|---|
| Support Status |
Y |
Y | Y | Y |