cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Snowflake JDBC Monitoring

joel_wilson
Newcomer

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.


Detected namesnowflake
Typedatabase
Service main technology
<unknown>
Process technology
<unknown>
Database name
snowflake
Database vendor
<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.

6 REPLIES 6

ChadTurner
Leader

Hey @Joel W. were you able to make any progress with this?

-Chad

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.

thanks for the update Joel!

-Chad

Hello @joel_wilson,

 

Has there been any update on your end regarding this?

 

Mahalo,

Aka

ChadTurner
Leader

Per @Joel W. " 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. "

-Chad

joel_wilson
Newcomer

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.