Examples | Heatmap Table Function and Macro | Teradata Vantage - Example: Using the tdheatmap Function - Analytics Database - Teradata Vantage

You can use the tdheatmap function to return just a few important columns, like the table name, cylinder ID, and temperature.

SELECT date TheDate,
       t1.ampnumber,
       dbase.databasenamei DatabaseName, 
       tvm.tvmnamei TableName, 
       to_byte(t1.cylinderidmsw) || to_byte(t1.cylinderidlsw) CylinderId,
       t1.temperature
FROM TABLE(tdheatmap(2)) AS t1,
     dbc.tvm tvm,
     dbc.dbase dbase
WHERE t1.starttableiduniq = tvm.tvmid
AND   tvm.databaseid = dbase.databaseid;