Icon

04.0_​Reset_​DB&Big_​Data_​Environment

This workflow resets the database by overwriting the customers and statistics tables and sets up a local big data environment and loads the usage data into it.





Reset the database and set up the local big data environmentExecute this workflow before the exercise 04.3_Orchestration. This workflow resets the database by overwriting the customers and statistics tables and setsup a local big data environment and loads the usage data into it. NOTE: In the Create Local Big Data Environment node, configured working directory is the Home directory of the current user. If you want to use other directory,change the settings before the execution. Make sure to provide the same directory in all the following exercises of this lesson. Session 4 OrchestrationExercise 04.0 Reset DB & Big Data Environment Customersload thedemo tableCreate theusage tableCustomersUsage Table Reader Create Local BigData Environment DB Loader DB Table Creator DB Writer Table Reader SQLite Connector Reset the database and set up the local big data environmentExecute this workflow before the exercise 04.3_Orchestration. This workflow resets the database by overwriting the customers and statistics tables and setsup a local big data environment and loads the usage data into it. NOTE: In the Create Local Big Data Environment node, configured working directory is the Home directory of the current user. If you want to use other directory,change the settings before the execution. Make sure to provide the same directory in all the following exercises of this lesson. Session 4 OrchestrationExercise 04.0 Reset DB & Big Data Environment Customersload thedemo tableCreate theusage tableCustomersUsageTable Reader Create Local BigData Environment DB Loader DB Table Creator DB Writer Table Reader SQLite Connector

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Lada.Rudnitckaia
Created at: 2021-09-30
On NodePit since: 2023-04-14
Last update: 2024-04-30
Created with KNIME version: v4.7.2
Tags: EducationData engineeringData engineerBest practicesbig dataELT

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!