12 May 2023
01:31 PM
- last edited on
17 May 2023
06:44 AM
by
MaciejNeumann
Is there any more documentation about the Custom db query extension, beyond what can be found here?
https://www.dynatrace.com/hub/detail/custom-database-queries
The information about using the Data Explorer for visualization does not appear to be accurate.
Solved! Go to Solution.
There is no other documentation, can you expand on what is not accurate? We can improve the Hub docs if necessary
The documentation screen shot for the data explorer does not match what I see on Dynatrace.
Here is the screenshot from the documentation:
Here is the data explorer screen I see:
Additionally, when I enter "custom.db.query" for the metric, I get the error "no meteric found for custom db query".
Thanks, that is just a slightly older version of data explorer on the docs, but the metric key and everything else is the exact same, some buttons just moved around.
If you don't have a metric something is not correct with the extension, I suggest opening a ticket so we can take a look at the logs.
Thanks for the reply. Regarding the error, it turns out I didn't have a value column populated. Since the field was listed as optional, I thought maybe it didn't need to be there.
I guess my issue is that I don't quite understand how the query results are supposed displayed in the Data Explorer. I suspect the queries need to be written a specific way, in order to be used by the Data Explorer. But there doesn't seem to be much information about this that I can find. The examples in the previous link are very limited.
I will research more.
The queries don't need to be written an specific way, and you do not need a value column populated to get metrics.
Everything you need to get a query working is already documented on the "Configuration" tab of the extension, for instance: