topic Re: Custom DB query updated documentation in Extensions

Custom Database query updated documentation

screaminscott — Tue, 20 Aug 2024 10:22:26 GMT

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.

Re: Custom DB query updated documentation

david_lopes — Fri, 12 May 2023 22:47:24 GMT

There is no other documentation, can you expand on what is not accurate? We can improve the Hub docs if necessary

Re: Custom DB query updated documentation

screaminscott — Mon, 15 May 2023 21:24:21 GMT

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".

Re: Custom DB query updated documentation

david_lopes — Tue, 16 May 2023 00:40:06 GMT

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.

Re: Custom DB query updated documentation

screaminscott — Tue, 16 May 2023 03:12:16 GMT

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.

Re: Custom DB query updated documentation

david_lopes — Tue, 16 May 2023 14:40:41 GMT

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: