Learning objective: Learn how to connect to and upload workflows to KNIME 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 Hub.

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

Transform

Step 3. Upload the data transformation workflow automatically

1. Connect to KNIME Hub using the Space Connector node

   • Select Other space and browse your user space*

2. Upload the workflow with the Workflow Writer node

   1. Add the File System Connection port and connect to the Space Connector

   2. Select the same output location where you uploaded the data transformation workflow manually

   3. Overwrite the workflow that you uploaded manually

   4. Use custom workflow name: Data_Transformation

3. On the workflow page on KNIME Hub, create a new version**.

* You should be connected to a Hub instance from the KNIME Analytics Platform

**Note. You can also create a version directly from KNIME Analytics Platform: Open the uploaded workflow from KNIME Analytics Platform and click on the Workflow menu actions → Version history → Create version.

Step 2. Upload and version the data transformation workflow on KNIME Hub

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

   1. Right click on the workflow in the Explorer and select Upload

   2. Select the hub, the course team, and your user space

   3. Make sure to reset the workflow before uploading

2. Create new version of your workflow on KNIME Hub

   1. On the workflow page, click Versions

   2. In the new menu, click Create version and provide a name and description

   3. Explore what happens when you select this version

Part 2 - Introduction to KNIME Hub

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

Step 1. Connect to KNIME Hub and explore

1. Connect to KNIME Hub from web browser:

2. Explore the KNIME Hub UI. Explore your user space and your team page if you have a Team subscription or a KNIME Business Hub instance

3. If you are connecting to KNIME Business Hub, add its mountpoint to KNIME Analytics Platform

   1. Click the button Preferences at the top-right corner

   2. In the new window, in the list on the left side, select KNIME Explorer

   3. In the same window, on the right, click New

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

   5. Click Apply and Close

   6. The Hub mountpoint appeared in the Home page

   7. Click Connect to connect

Extract a sample