All Forums Third Party Software
mybudy 5 posts Joined 01/11
04 May 2011
Teradata SQL Parser

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

suhailmemon84 47 posts Joined 09/10
29 Jan 2013

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 but it doesn't seem to be working.
Is anyone else doing this kind of anlaytics on sqltextinfo column of dbc.dbqlsqltbl?

You must sign in to leave a comment.