Examples - Advanced SQL Engine - Teradata Database

The following query returns a JSON document with feature name array for each FeatureUsage column in DBC.DBQLogTbl.

• The FeatureUsage VARBYTE column.
• The associated QueryID that maps into DBC.DBQLogTbl's QueryID.

  SELECT JsonTbl.QueryID (FORMAT '--Z(17)9'), JsonTbl.FeatureUsageJSON
  FROM TABLE(TD_SYSFNLIB.TD_DBQLFUL(DBC.DBQLogTbl.QueryID,DBC.DBQLogTbl.FeatureUsage))
  AS JsonTbl ORDER BY JsonTbl.QueryID;

This returns a JSON document with a list of features that the request used.

To avoid a complex SQL query, use DBC.QryLogFeatureUseJSON:

SELECT QueryID, FeatureJSON 
FROM QryLogFeatureUseJSON ;

Output of a request with five different features: