Custom extension for Databases

hi all,

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;

Please help me out. Thanks

If someone has the custom query extension yaml file with SQL query monitored, pls provide to use it as template

Hi,

You have a SQL data source reference. It might be helpful.

Best regards

Have you tried the doc skeleton?

On top of the other links people already shared, I recommend this video for a step by step guide:

Thank you all, got exactly what I wanted.

Is it possible to define a variable for the interval (10 minutes) and use it in the query?