Snowflake (ODBC) Connections
You can use the Snowflake (ODBC) connector to read data from and write data to Snowflake in Alteryx One.
This connector is built on the Unified connector framework and uses an Alteryx-managed ODBC driver. No local driver installation is required.
Important
This connector is currently available in Preview and does not yet offer full feature parity with the existing Snowflake connector. Review its capabilities to ensure they meet your requirements before using it in production.
Requirement | Details |
|---|---|
Driver Information | This connection uses an Alteryx-managed Snowflake ODBC driver. |
Driver installation | The driver is provided by Alteryx One. No separate installation is required. |
Connection Type | ODBC |
Support | Read and Write |
Authentication | Basic Authentication |
Prerequisites
Before creating the connection:
Verify that Alteryx One can access your Snowflake account
Add the required Alteryx service IP addresses to your Snowflake network policy, if applicable.
Obtain a Snowflake username and password with access to the required warehouse, database, schemas, and tables.
Configure the Connection
To create a connection:
In Alteryx One, go to Data > New Connection.
Search for and select Snowflake (Preview).
Configure the connection properties.
Select Test Connection.
After the connection test succeeds, select Create.
Connection Details
Once the connection is created, enter the following details in the appropriate fields:
Connection Name: Display name for the connection in Alteryx One.
Connection Description: Optional description of the connection.
Server or Account: Snowflake account identifier or server hostname.
Warehouse: Name of the Snowflake virtual warehouse to use.
Database: Name of the default Snowflake database.
Schema: Optional default schema.
Role: Optional Snowflake role to use for the connection.
ODBC Driver: Alteryx-managed Snowflake ODBC driver.
Credential Information
Credential Type: Select Username and Password. This is the only authentication method currently supported by the Preview connector.
Username: Required. Enter the Snowflake username.
Password: Required. Enter the password associated with the username.
Select Test Connection to verify that Alteryx One can connect using the supplied configuration. If the test succeeds, save the connection.
Authentication Options
The Snowflake Preview connector currently supports Username and Password authentication.
OAuth, key-pair authentication, federated SSO, and other authentication methods are not currently supported by this connector.
Limitations
The connector is currently available in Preview.
Only Basic authentication is supported.
The connector does not yet provide full feature parity with the existing Snowflake connector.
Existing connections and workflows are not automatically migrated to the new connector.
Existing Snowflake Connector
Alteryx One also provides an existing JDBC-based Snowflake connector. If you require capabilities that are not yet available with the Preview connector, see Snowflake Connections.