topic Re: Querying Snowflake from Dynatrace in Extensions

Querying Snowflake from Dynatrace

subashsagi41 — Fri, 01 Sep 2023 07:54:01 GMT

Hi , How can I run custom database queries to snowflake from dynatrace?

Re: Querying Snowflake from Dynatrace

Taylor-Sanchez — Thu, 31 Aug 2023 18:44:57 GMT

You can monitor Snowflake via Extensions here:

https://www.dynatrace.com/hub/detail/snowflake/

Furthermore, once you've gotten that instrumented, you are also able to collect information here:
https://www.dynatrace.com/support/help/extend-dynatrace/extensions20/data-sources/sql/snowflake-monitoring

Re: Querying Snowflake from Dynatrace

subashsagi41 — Thu, 31 Aug 2023 18:50:21 GMT

@Taylor-Sanchez Thanks for the details, I've configured it and I can get the pre-determined metrics provided by the extension, I wanted to run a custom query against the snowflake database with the connection which I created earlier. Is that possible?

Re: Querying Snowflake from Dynatrace

dglugla — Wed, 28 Feb 2024 12:18:22 GMT

Yes, that's possible.

Please download the extension package of the latest version, unzip the file and you'll see extension.yaml file inside. It describes what queries are executed and how are the result sets processed. Based on that you can create your own extension. Here's the documentation you may also find useful.

Re: Querying Snowflake from Dynatrace

PacoPorro — Wed, 28 Feb 2024 12:54:10 GMT

Check the VScode plugin to help with extension development
https://developer.dynatrace.com/extensions-v2/dynatrace-extensions-vscode/guides/getting-started/