I am new to dynatrace and working on custom query extension. I want SQL query to execute at 1min interval and provide the metrics. From VS code i deployed the custom extension. Beyond that what is the format to add query to yaml file and start monitoring ?
requirement:
need to get the metrics for following SQL query
select * from (select sql_text, elapsed_time/1000000 from sys.v_$sqlarea order by 2 desc) where rownum < 21;