Icon

01 Development data pipeline - Connect and upload to KNIME Business Hub - Exercise

This workflow reads a sample of restaurant orders data, cleans and transforms it, and loads the transformed data to the development database. Besides, it captures the data transformation segment and saves it as a separate Data Transformation workflow directly on KNIME Business Hub.
Step 3 : Upload the Data Transformation workflow automatically

  1. Connect to KNIME Business Hub within the workflow

    • Use Space Connector node to connect to your private space on the KNIME Business Hub

    • Set knime-edu-hub as the Hub mountpoint, and select your space (ExerciseSpace-User##)

    • Connect the Space Connector node to the Workflow Writer node

  2. Write the workflow directly to the KNIME Business Hub Space. In the Workflow Writer node:

    • Overwrite if the workflow exists

    • Use custom workflow name: Data_Transformation

  3. On the workflow page on KNIME Business Hub, create a new version and call it, e.g., "v2 Uploaded with the Workflow Writer"



Sample Data
Write Data Transformation workflow to KNIME Business Hub

Learning objective: Learn how to connect to and upload workflows to KNIME Business Hub


Workflow description: This workflow reads a sample of restaurant orders data, cleans and transforms it, and loads the transformed data to the development database. Besides, it captures the data transformation segment and saves it as a separate Data Transformation workflow directly on KNIME Business Hub.


You'll find the instructions to the exercises in the yellow annotations.

Session 2 - Introduction to KNIME Business Hub

Exercise 01 Development data pipeline - Connect & upload to KNIME Business Hub

Data Transformation
Step 1 : Connect to KNIME Business Hub

  1. Receive KNIME Business Hub instance URL and your personal credentials from the trainers

  2. Connect to KNIME Business Hub from web browser:

    1. Open https://edu-hub.knime.com/ in your web browser

    2. Provide your credentials

  3. Explore the KNIME Business Hub UI:

    • Explore your team page (check which spaces are visible to you, the team members, and team deployments)

    • Explore your user space ExerciseSpace-User## (Note that it is private, check for whom else it is visible)

  4. Connect to KNIME Business Hub from KNIME Analytics Platform

    • Click the Preferences button at the top-right corner

    • Choose the KNIME Explorer and

    • In the same window, on the right, click New

    • In the new window, select KNIME Hub, provide the Hub instance URL, click OK

    • Click Apply and Close

    • The Hub mountpoint appeared in the Home page

    • Click Sign in to connect

    • Explore how teams and spaces on the KNIME Business Hub in the web browser correspond to to teams and spaces in the Space explorer in KNIME Analytics Platform

Step 2 : Upload to KNIME Business Hub manually

  1. Upload the Data Transformation workflow created in session 1 to your user space

    • Right click on the workflow in the Space explorer and select Upload to Hub

    • Make sure to reset the workflow before uploading

  2. Create new version of your workflow on KNIME Business Hub

    1. On the workflow page, click History

    2. In the new menu, click Create version and call it, e.g., "v1 Uploaded manually"

    3. Explore what happens when you select this version

"Price" Column to Number
String to Number
"Table ID" Column to Number
String to Number
Remove Duplicates
Duplicate Row Filter
Date&Time
String to Date&Time
Filter relevant cols
Column Filter
by time, restaurant
Sorter
Capture Workflow Start
Capture Workflow End
Read orders Oct 20 forward
CSV Reader
Write theData Transformationworkflow
Workflow Writer
Summarize Timestamp-Hour

Nodes

Extensions

Links