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
Snowflake will begin blocking single-factor password authentication by November, 2025. Will the plugin be updated to handle MFA or key-pair authentication?
https://www.snowflake.com/en/blog/blocking-single-factor-password-authentification/
Hi with version 3.1.3 of the plugin and 24.3 of Appian we are experiencing some weird behavior. After a server restart we get an error in the integrations saying [success:false,result:[],error:[title=Error Occurred, message=No suitable driver found for jdbc:snowflake://accountID.snowflakecomputing.com, detail=java.sql.SQLException: No suitable driver found for jdbc:snowflake://accountID.snowflakecomputing.com in query CALL PROD.EDW.GET_WORKORDER_DETAILS('81027108')],authType:[name=authType, value=SnowflakeConnectedSystemTemplate, timestamp=2/4/2025 11:04 AM PST]] (account id was removed for this post)The only way we have found to fix this is we have to click the 'Test Connection' button in the connected system details for each server instance.
How to insert multiple rows data to snowflake from Appian, via SP
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?