Snowflake

RE: Snowflake

Jesse Knight — Mon, 29 Sep 2025 14:58:14 GMT

Hello Appian Team!

We were previously on a super old version of this plugin that allowed a direct SQL statement. We're unable to migrate all of our queries to the new plugin because it doesn't support SQL queries like one would expect from a Snowflake connector via the statements REST API. For example:

`SELECT DISTINCT {...}`

`SELECT abc.col1, xyz.col2 FROM ABC abc JOIN XYZ xyz ON {...}`

Can we please get a plugin update to support basic SQL?

Are there current workarounds for these that do not involve creating a view in Snowflake? Our developers only have, and will always only have, a read only role into Snowflake.

RE: Snowflake

Appian AppMarket — Tue, 23 Sep 2025 22:00:00 GMT

v4.1.0 Release Notes

- Added connected system support for Key Pair and Programmatic Access Token Authentication methods. Instructions on configuration can be found in the attached documentation.

- Fixed a bug in the integrations when migrating from previous V3 Snowflake Plug-Ins.

RE: Snowflake

nandinib0009 — Wed, 17 Sep 2025 10:17:48 GMT

Is Key Pair authentication supported? We have snowflake backed record (web service backed record), but the data sync is failing due to the OAuth 2.0 Authorization Code Grant, as the system is unable to authorize the request.

RE: Snowflake

Guy — Mon, 08 Sep 2025 14:48:27 GMT

Hi, am I right in thinking that because this is uses OAuth 2.0: Authorization Code Grant, if we want a scheduled batch job to run a smart service node that calls this integration/connected system, then we need to authorize the connected system using a particular user, and assign the node to always run as that user?

RE: Snowflake

Jesse Knight — Wed, 03 Sep 2025 18:27:14 GMT

Hello,

Just a heads up for anyone trying to refactor from other plugins into this one using existing Basic credentials - there's an issue with basic auth right now, so you might need to skip right into the Authorization Grant method.

I keep getting an UnsupportedOperation exception:

Digging into this further, it appears that the SnowflakeConnectedSystemTemplate is setting SF_CS_TYPE to CS_TYPE_CC rather than CS_TYPE_BASIC, which then causes the SnowflakeUtility constructor to throw the exception.

Any chance a fix could be put in for this? Also pretty happy that Key Pair is potentially a future consideration since it's in the types list.

RE: Snowflake

Appian AppMarket — Fri, 08 Aug 2025 22:00:00 GMT

v4.0.0 Release Notes

Added connected system support for OAuth 2.0: Authorization Code Grant, using Snowflake as the Identity Provider. Instructions on configuration can be found in the attached documentation.
Updated a package to resolve a CVE.
Transferred ownership and authorship of this plug-in to the internal, Appian Technology Partnerships team.

RE: Snowflake

Joshua.Newman — Wed, 06 Aug 2025 15:16:07 GMT

Every time the server needs a restart, i.e. upgrade, general maintenance, etc., we have to go into the Connected System and click Test Connect for this plugin to work. We are on the latest version 3.1.4. I created a ticket with Support and they said this was a known issue with your plugin. Is there any plan to fix this issue?

RE: Snowflake

harikanthk0004 — Fri, 13 Jun 2025 11:23:16 GMT

Hi Team,

Is there a plan to enable key pair authentication to this plug-in.

Thanks,

RE: Snowflake

fredericon — Wed, 09 Apr 2025 08:33:55 GMT

Hello,

Is there any plan to update the plugin to handle MFA or key-pair authentication?

Thanks

RE: Snowflake

keitht — Wed, 19 Feb 2025 16:20:29 GMT

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/

RE: Snowflake

Appian AppMarket — Tue, 18 Feb 2025 23:00:00 GMT

v3.1.4 Release Notes

Updated security patch.

RE: Snowflake

Ethan Allnutt — Thu, 06 Feb 2025 18:48:36 GMT

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.

RE: Snowflake

Lokesh — Fri, 13 Dec 2024 09:51:35 GMT

How to insert multiple rows data to snowflake from Appian, via SP

RE: Snowflake

Appian AppMarket — Wed, 04 Dec 2024 23:00:01 GMT

v3.1.3 Release Notes

Fixed a bug in Retrieve intergration

RE: Snowflake

devanshiv99 — Thu, 28 Nov 2024 13:43:48 GMT

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?