Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Snowflake Connector
NodeNode / Source

Snowflake Connector

DB Connection
Drag & drop
Like
Copy short link

This node creates a connection to a Snowflake database using the selected Snowflake JDBC driver. For further information about Snowflake 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.

Node details

Output ports
  1. Type: DB Session
    DB Connection
    Snowflake DB Connection.
Microsoft Authentication (Dynamic Inport)

To use this input port, you must enter the scope you want to use into the Others field of the Microsoft Authentication node. The scope is specific to the setup of your 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 Microsoft Authentication node. Depending on your database setup you might need to specify additional JDBC parameters which are described in the Snowflake documentation.

  1. Type: Microsoft Credential

Extension

The Snowflake Connector node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

No known nodes available

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits