Information
  • Author: Vuram
  • Type: Plug-in (Connected System)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 24.2
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Snowflake

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.
Anonymous
  • in reply to Deepak Raj D

    Our Test environment was upgraded to 24.2 last night and we started getting these exact errors today.  Has there been any response or fixes yet?

  • in reply to Deepak Raj D

    Up

    Also encountering this issue on 3 separate environments. We are on 24.2 already


    snowflakeResultSetSerializableV1 error

    Thank you

  • in reply to Deepak Raj D
    Team,

    Can anyone please help me on this issue?

    Regards,
    Deepak

  • Team,

    We are connecting to Snowflake database through connected system using this plugin in one of our applications. The connected system is successfully getting connected. While using it in a Retrieve Integration operation, it is throwing the below error in our UAT environment which is in 24.2.

    Error Occurred

    error-result-guidance

    JDBC driver internal error: exception creating result java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.RootAllocator at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.create(SnowflakeResultSetSerializableV1.java:586). net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: exception creating result java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.RootAllocator at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.create(SnowflakeResultSetSerializableV1.java:586). in query SELECT ISO_ENGLISH_SHORTNAME_NM FROM VW_MDM_COUNTRY ORDER BY ISO_ENGLISH_SHORTNAME_NM ASC OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY

    We have found out that the same integration is working fine in our DEV environment which is in 24.1. Can someone help us on fixing this issue.

    Regards,

    Deepak

  • in reply to Santhosh Kumar

    Hello,

    Thank you for your reply, we already resolved this issue by including the service name and hostname

    Thanks!

  • in reply to Machy Llego

    Hi  ,

    It seems like SSL Certificate issue. Can you contact Snowflace team to configure your Appian Domain as a trusted. So that this issue will be resolved.

    Best.

  • Hello I am receiving this error can you help check? our current version is 3.0.5 and working with our dev environment but in uat env there are errors please see below:

    Error Occurred

    error-result-guidance

    JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Certificate for <datavault-ubp_uat.privatelink.snowflakecomputing.com> doesn't match any of the subject alternative names: [*.appiancloud.com, appiancloud.com]. net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Certificate for <datavault-ubp_uat.privatelink.snowflakecomputing.com> doesn't match any of the subject alternative names: [*.appiancloud.com, appiancloud.com]. in query SELECT * FROM ITRS_WEEKLY WHERE ((ACTIVE_FLAG = 'Y')) FETCH NEXT 1000 ROWS ONLY



  • in reply to ajaykumarg2793

    Hello would like to ask how you resolved this issue, currently having the same with our env

  • in reply to Mr. Agda

    Hi   

    Thanks for reaching out!

    We were unable to reproduce the issue. Could you please share the table schema you tried to retrieve?

  • in reply to carlosc0012

    Hi   

    Thanks for reaching out!

    We were unable to reproduce the issue. Could you please share the table schema you tried to retrieve?

© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.