Icon

Postgres_​Trigger_​Builder_​App

Postgres Trigger Builder App

Companion data app to the Postgres Trigger Builder component which guides the user through the process of building a postgres trigger and python function to call a workflow on their KNIME Server.

Data ConnectionComponent view to gather the followingattributes:DB NameDB URLDB Credentials DB Table SelectionRetrieves a list of tables for selection.The table selected in this step will beused as the destination for the Functionand Trigger. Build Function & TriggerBuilds the query to be submitted to theDB. User selects an available workflowfrom the server and the variousconditons (Trigger) for the function* torun. *see note Note:Currently the API being call in the function is forexecution of the specified workflow on trigger of thefunction. This is a deliberately naive implementation as itis left to the user to define the workflow being call andhow it interacts with the postgres DB. Workflow is meant more to create a template to build offof and introduce the concept of triggers and workflowsinteracting.For example one could have the trigger automaticallycall the workflow upon insertion of new data to runpredictions against the data. Though I'd advise againstperforming the same operation on the table you have thetrigger set on to avoid infinite loop of triggers. DB Insertop > Workflow Called > Workflow Inserts new data > DBInsert op > etc. DB Connection DB Table Selection Build Func/Trigger Data ConnectionComponent view to gather the followingattributes:DB NameDB URLDB Credentials DB Table SelectionRetrieves a list of tables for selection.The table selected in this step will beused as the destination for the Functionand Trigger. Build Function & TriggerBuilds the query to be submitted to theDB. User selects an available workflowfrom the server and the variousconditons (Trigger) for the function* torun. *see note Note:Currently the API being call in the function is forexecution of the specified workflow on trigger of thefunction. This is a deliberately naive implementation as itis left to the user to define the workflow being call andhow it interacts with the postgres DB. Workflow is meant more to create a template to build offof and introduce the concept of triggers and workflowsinteracting.For example one could have the trigger automaticallycall the workflow upon insertion of new data to runpredictions against the data. Though I'd advise againstperforming the same operation on the table you have thetrigger set on to avoid infinite loop of triggers. DB Insertop > Workflow Called > Workflow Inserts new data > DBInsert op > etc. DB Connection DB Table Selection Build Func/Trigger

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: nfriesen
Created at: 2022-08-22
On NodePit since: 2023-02-18
Last update: 2024-05-02
Created with KNIME version: v4.7.0
Tags: postgres

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

Try NodePit Runner!