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.
I found one parser at sqlparser.com but it doesn't seem to be working.
Do you know of any UDF/SQL parser that works with teradata?
Is anyone else doing this kind of anlaytics on sqltextinfo column of dbc.dbqlsqltbl?
It will be a very complex awk command. There are several types of complex queries and the where clause can be anywhere. Not sure if this is an ideal solution to achieve what I need.
Plus we certainly want to build further on these kinds of analytics and make it a generic utility.
Anyone else has done this before?