Hub
Pricing About
WorkflowWorkflow

forum 44727 - 01 Practicing with Traditional Databases

Big dataDatabaseH2SqlQuery
+1
mlauber71 profile image
Draft Latest edits on 
Mar 18, 2024 5:33 PM
Drag & drop
Like
Download workflow
Workflow preview
forum 44727 - 01 Practicing with Traditional Databases Exercise 1: Practicing with Traditional Databases In this exercise you'll create a database table, and load and manipulate airline data (US domestic flights in January 2007) in the database. 1) Read the AirlineDataset.table file and connect to the H2 database by executing the nodes below 2) Create a new table "airline" on the database based on the table specs of the local data table. Replace the existing table. Use dynamic settings. 3) Insert the data into the airline database table Perform the following tasks directly on the database using the DB nodes: 4) Filter the data to flights that were not cancelled AND had Austin-Bergstrom International Airport ("AUS") as destination 5) Write the filtered data into a new database table called "airline_Austin" 6) Read the airline_Austin table into KNIME 7) Optional: Delete the cancelled flights directly on the database with the following statement in the DB SQL Executor node: DELETE from "PUBLIC"."airline" where "Cancelled" = 1;

External resources

  • If you want to insert binary / blob data into a H2 database - KNIME Forum (77927)
  • Adapted from this sample workflow "01 Practicing with Traditional Databases - Solution"
  • Medium Blog: KNIME, Databases and SQL
  • (44727) forum entry
  • SQL and Hive - special use cases
  • about using KNIME and database connections
  • KNIME Database Extension Guide
  • more H2 database examples
  • Example how to use H2 database to create table with upload and from scratch
  • Airline Dataset complete
  • Database Structure Manipulation
  • Advanced Query Building
  • Manipulating Data on Databases
  • Accessing Databases
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 4.7.8
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.8

    knime
  • Go to item
    KNIME DatabaseTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.4

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.4

    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits