SQL Parser

The SQL Parser transform lets you parse SQL statements from a field.

Usage

The transform will parse the provided SQL statements and return the following fields:

Schema: the schema name used for a table and column in the provided SQL statement
Table: the table name used from a schema in the provided SQL statement
Column: the column name used from a table and column in the provided SQL statement

The SQL Parser transform uses JqlParser to parse SQL queries. Check their documentation for more details.

Option	Description
SQL Parser	The name to use for this transform
Timeout (ms)	The timeout in milliseconds (defaults to 30 minutes)
Use backslash as escape char	JSQLParser allows for standard compliant Single Quote '.. Escaping. Additional Back-slash \.. Escaping needs to be activated by setting this option.
Use square brackets in query	JSQLParser interprets Squared Brackets [..] as Arrays, which does not work with MS SQL Server and T-SQL. Please use this option to instruct JSQLParser to read Squared Brackets as Quotes instead.
Allow complex parsing (slower)	Allow Complex Parsing (which allows nested Expressions, but is much slower)
Allow unsupported statements	JSQLParser is a RDBMS agnostic parser with a certain focus on SQL:2016 Standard compliant Queries and the “Big Four” (Oracle, MS SQL Server, Postgres, MySQL/MariaDB). This option allows the SQL parsing to use unsupported statements. Check the docs for more information and examples on how to write portable SQL.
SQL field	The field that contains the SQL statements to be parsed.
Exclude Strings	Exclude certain strings from the parsing. These strings will be (temporarily) removed from the SQL before parsing. Typical examples of strings to exclude are instructions to your databases’ SQL engine that are not necessarily part of the “real” SQL statements to be parsed.