Snowflake

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

Account Name: Full name of your account (provided by Snowflake). Note that your full account name might include additional segments that identify the region and cloud platform where your account is hosted. ex: <account>.snowflakecomputing.com
Role: Default access control role to use in the Snowflake session. The specified role should be an existing role that has already been assigned to the specified user. If the specified role has not already been assigned to the user, the role is not used when the session. ex: ACCOUNTADMIN, SECURITYADMIN, SYSADMIN, PUBLIC. (Only provide single role)
User: Login name of the user for the connection.
Password: Password of the account

Key Features & Functionality

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

Lokesh 13 days ago

How to insert multiple rows data to snowflake from Appian, via SP
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 21 days ago
v3.1.3 Release Notes
- Fixed a bug in Retrieve intergration
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
devanshiv0003 27 days ago

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?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Machy Llego 28 days ago

error-result-guidance
Cannot invoke "Object.getClass()" because the return value of "java.sql.ResultSet.getObject(int)" is null
java.lang.NullPointerException: Cannot invoke "Object.getClass()" because the return value of "java.sql.ResultSet.getObject(int)" is null

Receiving this error after updating to v3.1.2. It seems like there is an error when trying to query Integers/Numbers with NULL values.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
bferreira 1 month ago

Hello, how can we add a "GROUP BY" clause when using the Retrieve Integration? Where would we type that and what is the syntax?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
jeffh0003 1 month ago

Is is possible to do Count, Group By, or Not Null with this?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 1 month ago
v3.1.2 Release Notes
- 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.
- Updated libraries to the latest version.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Machy Llego 1 month ago

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
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Snehasri S 1 month ago in reply to Lokesh

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.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Lokesh 1 month ago

Hi Team
What is the Max Query timeout limit ?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel