Querying Snowflake from Dynatrace

[subashsagi41]

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

[Taylor-Sanchez · Accepted solution]

Hi @subashsagi41 ,

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

[subashsagi41]

@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?

[dglugla]

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.

[PacoPorro]

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