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:
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.
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
© 2020 Appian. All rights reserved.