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
Key Features & Functionality
Hi ajaykumarg2793 ,Thanks for reaching out!
Could you please share the version of the Appian environment you are in and the plugin version you are using, and share the image of the connected system you are trying to create? This will make it easier for us to further investigate.Regards,Vignesh E
Hi Team, Currently we are trying to integrate our Appian Dev with Snowflake (both systems are hosted on AWS private cloud).
We have installed the plugin but when trying to create a connected system, we are seeing the below error in Appian, Please review and suggest.
Something went wrong: JDBC driver encountered communication error. Message: Certificate for <*.snowflakecomputing.com> doesn't match any of the subject alternative names <*.snowflakecomputing.com>.
Hi lesliem,Good day!The issue is fixed in the latest version and it is listed now.
Hi lesliem,
Thanks for reaching out. The query to retrieve all data is currently being executed by the plugin. We will fix this issue in the upcoming version.
Regards,Ananthakrishnan S
vigneshe, I am not able to give a valid screenshot of the Request tab because the tab does not refresh with any information before the servers restart.
I have included a screenshot of the activity in Snowflake. You can see that once the initial request runs something is running a query again to retrieving all rows and all data. Even after the successful retrieval into Appian from the PRODUCT_VALUATION_ACCOUTNING_FACT_V01 something ran the next query gathering all data.
Hi lesliem ,We cant reproduce the issue you addressed can you send us more detail and please switch the request tab and check whether the Query is passed correctly.Regards,Vignesh E
Hello,
I am trying retrieve data with a where clause in the Condition field on the integration, but I am having problems structuring it in the field so that it will pull back the data. Every time I try the below query it removes the where clause and pulls back the entire data set and crashes the server. Any help would be appreciated.
Unfortunately this is not possible, we use it expensively and call sql directly through it. In that case, is there a way to fix the datetime issue?
Thank you,
Walker
Hi walkers,You can reach us via team.int.swatcustomdev@vuram.com. And regarding the split up, in version 2.1.0 we have only one integration called "SnowflakeJDBCIntegrationTemplate" after version 3.0.0 that is split into 5 different integrations, RetrieveIntegrationTemplate, InsertIntegrationTemplate, UpdateIntegrationTemplate, DeleteIntegrationTemplate, CallIntegrationTemplate. So you can update the Appian integration to the new one according to your usage.
Regards,Vignesh E