02_Databases
This directory contains 23 workflows.
12_Google_BigQuery_and_Amazon_Athena_will_they_blend
Google BigQuery and Amazon Athena - Will They Blend? In this workflow, we combine data from Genome Wide Association studies in Google BigQuery and Amazon […]
13_DBTransactionExample
The DB Transaction Start and DB Transaction End nodes allow you to model a database transaction, i.e. a unit of work that is either completely processed or […]
14_Theobald_meets_SAP_HANA
This workflow calculates various Key Perfomance Indicators (KPI) based on sales data extracted from two SAP tables via Theobald and SAP Hana. The KPIs are, […]
15_Advanced_Query_Building
Advanced Query Building This workflow shows how to write custom SQL queries using KNIME database nodes with an embedded script editor. These nodes can be […]
16_Database_Structure_Manipulation
Database Structure Manipulation This workflow shows how to move a local data table into a database, and vice versa. Data can be loaded into a database […]
17_Load_data_into_Snowflake
Load data into Snowflake This workflow demonstrates how to load data into Snowflake. It defines a table structure using a DB Table Creator and then […]
18_MongoDB_nodes
MongoDB Nodes This workflow shows the functionality of the MongoDB nodes. It requires you to set up a local MongoDB instance. To do so you can […]
19_MongoDB_Aggregation
MongoDB Aggregation Pipeline This workflow demonstrates aggregation pipelines in MongoDB from KNIME. Aggregation usually works in stages of a pipeline. […]
20_MongoDB_Bulk_Size
MongoDB Bulk Size This workflow demonstrates, bulk size writing operation to Mongo DB Collection. The "Timer Info" shows execution time of both MongoDB […]
21_MongoDB_Run_Command
MongoDB Run Command This workflow shows demonstration of db.runCommand( <some input>). The input is given in the configuration dialogue and rest is […]