Snowflake Connector

This node creates a connection to a Snowflake database using the selected Snowflake JDBC driver.

To get started with Snowflake in KNIME have a look at the KNIME for Snowflake Users collection that provides you with links to important KNIME nodes, example workflows and further resources such as the KNIME Snowflake Extension Guide.

For further information about Snowflake in general see the Snowflake documentation.

This node uses the selected driver's JDBC URL template to create the concrete database URL. Field validation in the dialog depends on whether the (included) tokens referencing them are mandatory or optional in the template.

Output ports

1. Type: DB Session
   DB Connection
   Snowflake DB Connection.

Microsoft Authentication (Dynamic Inport)

This input port allows you to connect a credential port with an OAuth access token for authentication.

To use Snowflake OAuth you can use the OAuth2 Authenticator node.

For External OAuth the predecessor node depends on the configured identity provider e.g. for Microsoft Entra ID, you can attach the Microsoft Authenticator node. In the Authenticator node choose one of the OAuth2 authentication types and enter the custom scope you want to use. The scope is specific to the setup of your Azure Entra ID (formerly Azure Active Directory). For further details on how to create a scope or where to find it see the Snowflake documentation.

When available the node will set the authenticator as well as token JDBC parameter automatically based on the information from the connected Authenticator node. Depending on your database setup you might need to specify additional JDBC parameters which are described in the Snowflake documentation.

For further details on how to configure the connector node for the different supported authentication methods see the Authentication section of the KNIME Snowflake Extension Guide.

1. Type: org.knime.credentials.base.CredentialPortObject