Snowflake is an analytic data warehouse that is fast, easy to use, and pliable. We have built the Snowflake Connected system to employ these benefits in Appian. You can use this connected system to create an integration object that can help perform SELECT, INSERT, UPDATE, DELETE, DROP, TRUNCATE and CREATE SQL operations in the Snowflake Database tables or views on providing Query, Warehouse, Database and Schema details.
To establish the connection, while creating a connected system you will need:
Features and Functionality:
This plug-in is actually not working on cloud environments, in fact it had to be temporary unpublished from the App Market.
We are working with an Appian team looking for a solution since they want to use it with other customer.
The issue with the plug is with some temporary authentication files that the Snowflake JDBC driver itself uses to improve usability, when they are tried to be read / written it fails because is not allowed to access the file system.
The first attempt you used to connect were the correct one and we were planning to make some improvements like the ones you asked for, select the warehouse, database etc
We are so sorry for this issue
Hello AN Global,
Should this plugin work on cloud installations of Appian? It seems to work in on prem installations, but we always get the blow error when trying to leverage it through an integration in our cloud environment and the cloud environment that Appian Support tried it with as well.
Any help would be greatly appreciated.
I have installed the connected system plugin, but am having trouble connecting to Snowflake. My questions are:
We tried the following:
Account Name field in Connected System object:
Queries executed in Integration:
- "USE warehouse DEMO_WH; use database SNOWFLAKE_SAMPLE_DATA; Select * from TPCDS_SF100TCL.CALL_CENTER"
-” Use database SNOWFLAKE_SAMPLE_DATA; Select * from TPCDS_SF100TCL.CALL_CENTER"
- "Select * from SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER"
When we used the non JDBC links, we get the following error: error-result-label
Expression evaluation error : “com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.core.SFTrustManager”
When we use the JDBC Links, we get the follow the following error, and a dictionary with blank message and details: “error-result-label
Snowflake returns the following exception:
No message provided”
In both cases, no values were present under the Request tab of the Integration editor.
The roles and login specified in the Connected System do have the access necessary for the queries in the integration.
Are we using the right type of value in the Account Name field? Is there a place to define the Snowflake warehouse, or should this just be defined in the integration query? Do we need to have a driver for Snowflake installed in our cloud environment?
Any help would be greatly appreciated!
For On-Prem, copy it to the directory: APPIAN_INSTALL/_admin/plugins/
For Cloud environments, you can deploy directly from the admin console
Could you please share supporting documentation for this. In which folder we have to place the JAR file
© 2020 Appian. All rights reserved.