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.

Mr. Agda 6 months ago in reply to Mr. Agda

Dev environment

Personal Environment
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Mr. Agda 6 months ago

Is there an issue on the plugin? I am trying to retrieve data on snowflake. I tried on our company environment and is always shoring the ResultSet null argument and when I tried on my personal environment it returns the No message provided error
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
rsufaru001 6 months ago

When querying a view in SNOWFLAKE using the "Retrieve Integration" we always get ,in the "totalCount" the total number of rows in the view,regardless of the filtering conditions. We would expect the "totalCount" to change if we apply filtering conditions.

Could you please take a look over this?
- Cancel
- Up +2 Down
- Reply
- More
- Cancel
GA_Alonzo 6 months ago in reply to GA_Alonzo

update: the retrieve function encounter this error. Thank you
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
GA_Alonzo 6 months ago

HI Team,

I've been checking this now. How do I fix this one? The insert process is working fine. I ran the query from the error message on Snowflake and it still works.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 6 months ago
v3.0.9 Release Notes
- Security patch attached.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
vigneshe 7 months ago in reply to ajaykumarg2793

Hi ajaykumarg2793 ,

1. I have downloaded the package now and the files are present inside the ZIP package.
2. And regarding the Add plugin option, we will investigate with the app market team and let you know.

Let us know if you need any information.

Thanks,
Vignesh E
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
ajaykumarg2793 7 months ago in reply to ajaykumarg2793

Any update ?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
ajaykumarg2793 7 months ago in reply to vigneshe

Can i know why it is not longer listing as part of- Add-Plugin - "Appian AppMarket Plugins" search option.

Also please download and check the latest version of the plugin, it says ".zip" file is empty.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
vigneshe 7 months ago in reply to ajaykumarg2793

Hi ajaykumarg2793 ,

Thanks for reaching out!

You are trying to deploy the combined files zip file. Kindly unzip it and you will find the plugin jar. Use that jar file for deployment.

Let us know if you need any information.

Thanks,
Vignesh E
- Cancel
- Up 0 Down
- Reply
- More
- Cancel