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
Hello,
I am having an issue where a date time in Snowflake is stored as ET, but when I query it using the snowflake integration in Appian, it lists the timezone in EDT and the time is 4 hours earlier than the time in Snowflake. For example,
Hi walkers,Thanks for reaching out,Can you please share with us what integration you are trying to use? Because the integrations were split up and updated after version 3.0.0. If so please update it with the help of the document that is in the download package of the plugin.Please feel free to reach us if you still face any issues.Regards,Vignesh E
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