Overview
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, CALL FUNCTION or STORED PROCEDURE operations in the Snowflake Database tables or views.
To establish the connection, while creating a connected system you will need
Key Features & Functionality
Hi Vuram team, we have downloaded the latest plugin ,but checking the jar files, we could see some files showing component version(maybe some meta data reference) as 3.19.0, which is not latest as per the release of the plugin , can we expect new version release with this addressed?
error-result-guidanceCannot invoke "Object.getClass()" because the return value of "java.sql.ResultSet.getObject(int)" is nulljava.lang.NullPointerException: Cannot invoke "Object.getClass()" because the return value of "java.sql.ResultSet.getObject(int)" is nullReceiving this error after updating to v3.1.2. It seems like there is an error when trying to query Integers/Numbers with NULL values.
Hello, how can we add a "GROUP BY" clause when using the Retrieve Integration? Where would we type that and what is the syntax?
Is is possible to do Count, Group By, or Not Null with this?
Hello Snowflake Team,We're having an issue in Retrieve Integration on Snowflake Connected system for DATE Metadata. For example, querying a date 11/08/2024 will give us a result of 11/07/2024. We are using 24.3 Appian Environment with the plugin version of Snowflake 3.1.1
Hi Lokesh,Thanks for reaching out!!The maximum query timeout in Appian Integration is 300 seconds, while the default timeout is 30 seconds. In Snowflake, the maximum timeout is 604800 seconds.
Hi Team What is the Max Query timeout limit ?
Can you please share exact steps followed to fix the issue? Seems this is frequent error and any detailed steps to fix it will help a lot.