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.

Hema Kumar over 2 years ago

Hi Team,

While deploying Snowflake Appian plugin in DEV and TEST , we encountered the following error.

The System Has Encountered an Error HTTP Code: 500 APNX-1-4198-019 An Error Has Occurred Expression evaluation error [evaluation ID = e63cc:5ed72] : An error occurred while executing a save: java.util.UnknownFormatConversionException: Conversion = 'D'

Could you please help to resolve the issue.

Regards,

Hema
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Santhosh Kumar over 2 years ago in reply to Scott Rumrill

Hi Scott, Is this issue still up?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Scott Rumrill over 2 years ago

Getting this error when trying to add this plug-in. I've confirmed this error in 2 different environments. Other plug-ins deploy without issue.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket over 2 years ago
v3.0.2 Release Notes
- Security patch updated
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket over 2 years ago
v3.0.0.1 Release Notes
- Security patch updated
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
robk over 3 years ago in reply to Santhosh Kumar

Hi Santhosh -

Thank you for the comment. That's what I was missing, and this works as expected. Thank you!
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Santhosh Kumar over 3 years ago in reply to robk

Hi robk, Let me assist you in providing the input for the Account Name. For instance, if your Snowflake domine is https://abcdef.us-central1.gcp.snowflakecomputing.com, use the string between https:// and snowflakecomputing.com. ie, abcdef.us-central1.gcp. Kindly do comment back if you still face the issue.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
robk over 3 years ago

I loaded this to my cloud instance, and when I put my account name in, which is located in us-east-1, it replies: Something went wrong: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Certificate for <Account Name> doesn't match any of the subject alternative names: [*.us-west-2.snowflakecomputing.com, *.us-west-2.aws.snowflakecomputing.com, *.global.snowflakecomputing.com, *.snowflakecomputing.com, *.prod1.us-west-2.aws.snowflakecomputing.com, *.prod2.us-west-2.aws.snowflakecomputing.com].
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket over 3 years ago
v3.0.0 Release Notes
- Added Query timeout as a new parameter to the Integration
- Snowflake JDBC driver modified as per the security concerns for the Appian cloud environment
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
rohito0003 over 3 years ago

Hi Team ,

Using this plugin I established a connection with snowflake and in the integration i am trying to execute a put statement to load the internal stage with data , but stage is not getting loaded
- Cancel
- Up 0 Down
- Reply
- More
- Cancel