AppDynamics integration with Snowflake application

[Barb_Ostroski]

I have several of our application teams asking if we are able to integrate AppDynamics with the 3rd party application called Snowflake.  Has anyone tried this or been successful with integrating the 2 tools together?  

[Satbir_Singh]

Hi,

AppD doesn't support snowflake data warehouse as supported environment doesn't mention in https://docs.appdynamics.com/22.4/en/database-visibility/database-visibility-supported-environments 

Its not supported Out of the Box but you can explore the extension to monitor it. Please note that these extensions are community supported.

https://developer.cisco.com/codeexchange/github/repo/Appdynamics/SQLMonitor/

Is this SnowFlake appliocation is a java application and is running on a JVM? Is it running on some kind of application server or in standalone mode? Is this application running on-premise and you have access to its startup script? If so, you can follow the steps from https://docs.appdynamics.com/display/PRO45/Java+Agent to instrument it with AppDynamics. 

Basically, all you need to do is to find out a place (application startup script or environment setup script) where you can add AppDynamics JavaAgent specific JVM parameters, setup mandatory configuration parameters in the AppDynamics JavaAgent's controller-info.xml to felicitate the agent-controller communication and restart the JVM.

PS: Snowflake is not in the list of application that is supported by AppDynamics JavaAgent OOTB. So even after adding the instrumentation, though you'll get basic JMX/JVM metrics from the application, there might be BT level custom configuration that needs to be added for the agent to detect Business Transactions OOTN+B from the application.

AppDynamics automatically detects the following types of Business Transactions from the application:

a. Servlet
b. WebService
c. JMS
d. Struts
e. Spring Beans
f. EJB
g. RMI

If your application is not intended to process any of the above types of requests, then as mentioned earlier, we might need to configure custom business transaction rules on relevant class/method to detect BT entry points.

I found one customer who is monitoring it using the extension that I shared. I am not sure if I can share the details of the customer and their overall experience monitoring SnowFlake. You can raise a support ticket to get more details on the implementation part if needed. You can also request AppD account manager to connect with me and I can share the customer contact information with them.

Thanks,

Satbir

[Barb_Ostroski]

Thanks for the document, but I'm looking for information on an active integration experience and would like to get some feedback from that team.  I'd like to short cut the learning experience.  And if it's not possible I'd like to be able to tell my team that.

[Satbir_Singh]

Hi Barb,

If the runtime of the snowflake is java or JVM then you can use the appdynamics javaagent to monitor it.

Refer to the following link to know about how to configure javaagent.

https://docs.appdynamics.com/display/PRO45/Install+the+Java+Agent. 

Thanks,

Satbir