As part of the series of product updates on AgilePoint NX v8.0 Software Update 2 release, the next one I would like to share is about the Snowflake Integration. The following process activities have been added
- Insert Records
- Update Records
- Query Records
- Delete Records
- Store Procedure
Snowflake provides SaaS based data storage and online analytics services as part of its ‘data warehouse-as-a-service’ offering. It is important to note that our connector and corresponding activities are generic since they does not target any specific product/solution of Snowflake, but works on the common table APIs. This will help application developers integrate with any kind of table and stored procedure available in Snowflake.
This video covers end to end scenario for how to configure business process to perform supported Snowflake operations which includes basic concepts like activity configuration, runtime execution etc.
Note: Please note that this video is recorded while this feature is in beta version. Some of the labels and icons might change by the time it goes GA but the general concept of configuring these activities would remains the same.