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?