Teradata SQL Parser

Third Party Software

Teradata SQL Parser

Topics related to the Teradata SQL Parser: Metadata Query, Parsing, formatting, analysis of SQL script, customizable SQL formatter, SQL syntax check

Re: Teradata SQL Parser


We have a requirement where I need to find what percentage of queries are querying recent data vs the percentage of queries that are querying historical data.

I went on google to find any sqlparser or some UDF that I can use with terdaata to extract out the where clause of every query in a format of "name=value" pairs that I can further use to get data for my requirement.

Do you know of any UDF/SQL parser that works with teradata?

I found one parser at sqlparser.com but it doesn't seem to be working.

Is anyone else doing this kind of anlaytics on sqltextinfo column of dbc.dbqlsqltbl?