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 environmentProvide the credentials to the PostgreSQL database and execute this workflow before the exercise 04.3_Orchestration. This workflow resets the database byoverwriting the customers and statistics tables and sets up 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 CustomersStatisticsload thedemo tableCreate theusage tableCustomersStatisticsUsage Table Reader Create Local BigData Environment Table Reader DB Loader DB Table Creator PostgreSQLConnector DB Writer DB Writer Table Reader DB CredentialsConfiguration Reset the database and set up the local big data environmentProvide the credentials to the PostgreSQL database and execute this workflow before the exercise 04.3_Orchestration. This workflow resets the database byoverwriting the customers and statistics tables and sets up 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 CustomersStatisticsload thedemo tableCreate theusage tableCustomersStatisticsUsageTable Reader Create Local BigData Environment Table Reader DB Loader DB Table Creator PostgreSQLConnector DB Writer DB Writer Table Reader DB CredentialsConfiguration

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-06
Last update: 2024-04-30
Created with KNIME version: v4.7.1
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!