Plug-in (Connected System)Free

Snowflake

by Appian Corporation

Description

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.

This plug-in was originally authored by Appian's partner, WNS Vuram[link: https://appian.com/partners/partner-program/all-partners/wns-vuram]. It is now maintained by the Appian Technology Partner Team.

Features

Use this Appian Connected System to authenticate and to access and execute actions on your Snowflake resources. TThrough 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.

Supported Authentication Methods include Key Pair, Programmatic Access Token, Authorization Code Grant, and Basic Authorization. Refer to the documentation for instructions on configuring each.

Release notes

V4.1.2: --> Anonymized Usage Tracking To continuously improve our Snowflake integration, we are now collecting basic, anonymized telemetry on plugin usage. This helps our team focus on refining the features you use most, while strictly ensuring no identifiable or sensitive data is ever collected.

Version history (27)

4.1.1

V4.1.0:

  • 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.

4.1.0

V4.1.0:

  • 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.

4.0.0

V4.0.0:

  • 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.

3.1.4

V3.1.4: Updated security patch.

3.1.3

V3.1.3:

  1. Fixed a bug in Retrieve intergration

3.1.2

V3.1.2:

  1. Fixed a bug where the date is offset based on time zone offsets when the Snowflake DataSource and the Appian environment are functioning in different time zones.
  2. Updated libraries to the latest version.

3.1.1

Fixed plugin compatibility issue with Appian 24.2.

3.1.0

  1. Bug fixes.
  2. Updated the value returned in totalCount parameter in the response – Returns the number of rows selected using the given query.

3.1.0

  1. Bug fixes.
  2. Updated the value returned in totalCount parameter in the response – Returns the number of rows selected using the given query.

3.0.9

Security patch attached.

3.0.8

Bug fixes

3.0.7

Bug fixes

3.0.6

Security patch attached

3.0.5

Included Sample Application and documentation. Changed the location of Connected system logo in the package from root directory to resource directory.

3.0.4

Security patch updated

v3.0.3

Fixed deployment issue

v3.0.2

Security patch updated

v3.0.0.1

Security Patch updated

3.0.0.0

Added Query timeout as a new parameter to the Integration. Snowflake JDBC driver is modified as per the security concerns for the Appian cloud environment.

2.1.0

What’s new in 2.1.0 : Added Query timeout as a new parameter to the Integration.

2.0.0

Updated plug-in name in properties for "Create Connected System" window in Appian Designer Updated plug-in file name

2.0.0

Hi Meenakshi,

Please update Appian versions, functionality, technical files, plug-in version, and this comment / new version info section.

2.0.0

Whats new in 2.0.0 :

  • Queried data from Snowflake will be returned in the integration as Dictionary format.
  • Added Warehouse, DB and Schema as the optional parameters.
  • Result will contain the total number of rows returned from Snowflake.
  • Result will contain the column metadata.

Note: Snowflake JDBC driver is modified as per the security concerns for Appian cloud environment.

1.2.0

Hi Meenakshi,

Please update Appian versions, functionality, technical files, plug-in version, and this comment / new version info section.

1.0.0.1

Bug fixed: Fix the way that Snowflake driver is loaded

1.0.0.0

The issues were solved, thanks for you help

1.0.0.0

We have already Pre approved this Plug In, but we did it through our client account Lime Network SRL de CV, after check with our Appian pre sales contact he recommended us submit the plug in from our partner account (AN Global), I hope it does not cause any problem

Resources