Overview
Snowflake is a cloud-based data platform built for scalable storage, fast querying, and secure data sharing across structured and semi-structured datasets. It separates compute and storage for flexible scaling and supports advanced analytics with strong performance across major cloud providers.
Appian helps you get more from Snowflake by turning raw data into action through low-code applications and AI-powered automation. With Appian’s data fabric, you can connect to Snowflake to enable unified views, streamlined workflows, and faster decisions, all while keeping Snowflake as your system of record.
Use this Appian Connected System to authenticate with OAuth 2.0: Authorization Code Grant in order to access and execute actions on your Snowflake resources. Through the integrations provided in this plug-in, you can select, insert, update, delete, and call a function or stored procedure in any accessible warehouse, schema, or table.
This plug-in was originally authored by Appian's partner, WNS Vuram. It is now maintained by the Appian Technology Partner Team.
Key Features & Functionality
Any updates on the release?
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.
Hi Alex King . We are experiencing the same issue. Looking forward for an update
We are currently having the same issues with OAuth 2.0. The Key Pair Authentication is necessary. Hopefully this works soon. We will be system down if this is not resolved.
Hi! Thanks for your question. Because the Authorization Code Grant routes the end user to a new window to enter their Snowflake login credentials, I do not believe it is suitable for a batch job.Fortunately, we are currently developing a solution for Key Pair authentication, which should support unattended, server-to-server authentication for this use case. This update should be available next week. We apologize for any inconvenience in the meantime.Best,Alex
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?
keitht Hi! Yes, the most recent version supports authorization via OAuth 2.0 Authorization Code Grant.
fredericon Hi! The most recent version of the plug-in supports authorization with authorization code grant. Please let me know if that does not resolve your feature request. Thank you!
harikanthk0004 Hi! Thanks for your question.The most recent version of this plug-in supports OAuth 2.0 Authorization Code Grant as an alternative to the soon to be deprecated Basic Authentication. Does this satisfy your request or would you still benefit from key pair?Thanks,Alex
Hi Jesse! Thanks for posting this issue and your recommendation, we'll look into the cause as soon as possible.