Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME 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
    Customer Churn Predictor Deployment with KNIME and Snowflake
    Snowflake Customer Intelligence CI
    +6
    This workflow is an example of how to deploy a customer churn predictor as Snowflake User…
    knime > Examples > 40_Partners > 07_Snowflake > 03_Snowflake_Model_Deployment
  2. Go to item
    Getting started with Snowflake
    Snowflake DB Database
    +2
    This workflow is an example of how to get started with using Snowflake from within KNIME …
    knime > Examples > 40_Partners > 07_Snowflake > 00_Getting_started_with_Snowflake
  3. Go to item
    Preparing and Exploring Customer Data with KNIME and Snowflake (ETL)
    Snowflake ETL Customer Intelligence
    +5
    This workflow is an example of how to read and transform different data files within KNIM…
    knime > Examples > 40_Partners > 07_Snowflake > 01b_Snowflake_ETL
  4. Go to item
    Load data into Snowflake
    Snowflake Database
    This workflow demonstrates how to load data into Snowflake. It defines a table structure …
    knime > Examples > 01_Data_Access > 02_Databases > 17_Load_data_into_Snowflake
  5. Go to item
    Preparing and Exploring Customer Data with KNIME and Snowflake (ELT)
    Snowflake ELT Customer Intelligence
    +5
    This workflow is an example of how to read different data files in KNIME and upload it to…
    knime > Examples > 40_Partners > 07_Snowflake > 01a_Snowflake_ELT
  6. Go to item
    Snowflake meets Tableau
    Snowflake Data warehouse Hyper
    +3
    This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud …
    knime > Examples > 01_Data_Access > 02_Databases > 11_Snowflake_meets_Tableau
  7. Go to item
    Training and Testing a Customer Churn Predictor with KNIME and Snowflake
    Snowflake Customer Intelligence CI
    +7
    This workflow is an example of how to train a machine learning model in KNIME with data s…
    knime > Examples > 40_Partners > 07_Snowflake > 02_Snowflake_Model_Learning
  8. Go to item
    Providing an Interactive Data App with KNIME and Snowflake
    Snowflake Customer Intelligence CI
    +5
    This workflow is an example of how to turn Snowflake data into an interactive Data App th…
    knime > Examples > 40_Partners > 07_Snowflake > 04_Snowflake_Dynamic_Data_App
  9. Go to item
    KNIME Weather Data Inspection and Visualization
    LinePlot Seasonality AutoCorrelationFunction
    +2
    This workflow does basic data preprocesing of DateTime values and visualizes results. Vis…
    aliasghar_marvi > Public > KNIME Weather Station > KNIME Weather Data Inspection and Visualization
  10. Go to item
    KNIME Weather Data Cleaning and Model Training
    Sarima DataCleaning IoT
    +3
    This workflows reads data from Snowflake database containing sensor readings. Seconds are…
    aliasghar_marvi > Public > KNIME Weather Station > KNIME Weather Data Cleaning and Model Training

No known nodes available

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 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 Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits