Icon

Parse SQL Statement for Table Names

Demonstration of experimental SQL Statement Inspector component.

This uses Python to parse a sql statement and break it down into its component parts, whilst attempting to identify what each component is e.g. table name, keyword


@takbb Brian Bates 6 March 2025

experimental component.make sure it works for your use case if used in aproduction environment sample sql queries@takbb componentfeed each rowcollect results with iteration numberupper out= all componentslower out=table/view names Table Creator SQL StatementInspector Chunk Loop Start Loop End experimental component.make sure it works for your use case if used in aproduction environment sample sql queries@takbb componentfeed each rowcollect results with iteration numberupper out= all componentslower out=table/view names Table Creator SQL StatementInspector Chunk Loop Start Loop End

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: BATEB031
Created at: 2025-03-06
On NodePit since: 2025-03-08
Last update: 2025-03-08
Created with KNIME version: v5.3.3

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

Try NodePit Runner!