We are working on using the snowflake DB.
I know that there won't be a way for dynatrace to gain visibility into how our queries are performing on their systems, but as we are using their JDBC driver. I'd like to be able to identify how it's performing the same way we can monitor any other external call.
Right now though, here is how this new database shows in our databases console.
|Service main technology||<unknown>|
|Database host name||<host_unavailable>|
I'd appreciate any recommendations that will allow us to be able to fill in some of those "unknowns" with values that at the very least can allow to us to separate out our various instances of this. Right now, I don't have anything I can use to put this neatly into a management zone.
Solved! Go to Solution.
I ended up opening a support ticket on this, the issue here was that they just don't have support for the snowflake JDBC drivers at this time. They assure me it will be added, though not what the timeline for adding it will be.
I forget which version (either 205 or 207) the agent added basic support for the snowflake JDBC driver. For us, I'm now able to use the snowflow hostnames to separate the database calls into their respective environments; which was my primary concern when I opened this thread and the ticket.
Like other SaaS database offerings, the agent is limited to monitoring only the client interactions; nothing from the server-side but that still does provide useful metrics around query timings and performance under scale; plus can alert when failures occur.