Snowflake DB 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.

Options

Database dialect
Choose the registered database dialect here.
Use latest driver version available
If selected, upon execution the node will automatically use the driver with the latest (highest) driver version that is available for the current database type. This has the advantage that you do not need to touch the workflow after a driver update. However, the workflow might break in the rare case that the behavior of the driver e.g. type mapping changes with the newer version.
Database driver
Choose the JDBC driver to connect to the database here. You can select a specific version of the registered drivers via the drop-down list. Additional drivers can be registered via KNIME's preference page "KNIME -> Databases".
Full account name
Specifies the full name of your account (provided by Snowflake). Note that your full account name might include additional segments that identify the region and cloud platform where your account is hosted e.g. xy12345.us-east-2.aws, xy12345.us-central1.gcp or xy12345.west-us-2.azure.
The domain .snowflakecomputing.com will be appended automatically to the full account name.
Virtual warehouse
Specifies the virtual warehouse to use once connected, or an empty string. The specified warehouse should be an existing warehouse for which the specified default role has privileges.
After connecting, the USE WAREHOUSE command can be executed with the DB SQL Executor node to set a different database for the session.
Access role
Specifies the default access control role to use in the Snowflake session initiated by the driver. The specified role should be an existing role that has already been assigned to the specified user for the driver. If the specified role has not already been assigned to the user, the role is not used when the session is initiated by the driver.
For more information about roles and access control, see Access Control in Snowflake.
Default database
Specifies the default database to use once connected, or an empty string. The specified database should be an existing database for which the specified default role has privileges.
After connecting, the USE DATABASE command can be executed with the DB SQL Executor node to set a different database for the session.
Default schema
Specifies the default schema to use for the specified database once connected, or an empty string. The specified schema should be an existing schema for which the specified default role has privileges.
After connecting, the USE SCHEMA command can be executed with the DB SQL Executor node to set a different schema for the session.
Authentication type
The type of the used authentication.
  • None: No authentication is required.
  • Username: Username-based authentication. No password required.
  • Username and Password: Username and password based authentication.
  • Password: Password based authentication. No username required.
  • Kerberos: Kerberos ticket based authentication
Credentials
The credentials used for the authentication.
JDBC parameters
Input mapping by name
Columns that match the given name (or regular expression) and database type will be mapped to the specified KNIME type.
  • Column selection type: The option allows you to select how the column is matched.
    • Manual: Use the exact name of the column
    • Regex: Allow regex expressions to select multiple columns
  • Column name: The name or regex expression.
  • Database type: SQL type to map from.
  • Mapping to: Datatype to map to.
Input mapping by type
Columns that match the given database type will be mapped to the specified KNIME type.
  • From type: SQL type to map from.
  • To type: Datatype to map to.
Output mapping by name
Columns that match the given name (or regular expression) and KNIME type will be mapped to the specified database type.
  • Column selection type: The option allows you to select how the column is matched.
    • Manual: Use the exact name of the column
    • Regex: Allow regex expressions to select multiple columns
  • Column name: The name or regex expression.
  • Source type: Datatype to map from.
  • Mapping to: SQL type to map to.
Output mapping by type
Columns that match the given KNIME type will be mapped to the specified database type.
  • From type: Datatype to map from.
  • To type: SQL type to map to.
Additional settings
This tab allows you to define KNIME framework properties such as connection handling, advanced SQL dialect settings or logging options. The available properties depend on the selected database type and driver. For more information about the supported parameters see the KNIME Database Extension Guide.

Input Ports

Icon…

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.

Output Ports

Icon
Snowflake DB Connection.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension KNIME Snowflake Integration from the below update site following our NodePit Product and Node Installation Guide:

v5.9

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 5.10.0.v202511281349
On NodePit since: 2025-11-27
Last update: 2025-12-03
Tags: StreamableModern UIHidden

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!