Snowflake

Frends.Snowflake.BatchOperation / 1.1.0

Summary

Applies one parameterised statement once per element of a JSON array, so a set of rows is written by a single Task rather than by a loop.

Typical use — writing a batch the Process already holds, without a round trip per row

Details

Frends version
5.7 and newer
Agent
Crossplatform
Target framework
net8.0

Essential parameters.

Name Type Default Example Description
Query String INSERT INTO TableName (NAME, AGE) VALUES (:Name, :Age)

Query to perform.

JsonData String [ { "Name": "Matti", "Age": 12 }, { "Name": "Joni", "Age": 34 } ]

Json data in a specific format

An unhandled error has occurred. Reload 🗙