BatchOperation
Task to run a batch operation in Snowflake
Last updated
Was this helpful?
Task to run a batch operation in Snowflake
Task version: 1.1.0
Required Frends version: 5.7+
Required .NET version: 8.0
Compatible Agents: Crossplatform
Source code: https://github.com/FrendsPlatform/Frends.Snowflake/tree/main/Frends.Snowflake.BatchOperation
Query : String
Query to perform.
Default: -
Example: INSERT INTO TableName (NAME, AGE) VALUES (:Name, :Age)
JsonData : String
Json data in a specific format
Default: -
Example: [ { "Name": "Matti", "Age": 12 }, { "Name": "Joni", "Age": 34 } ]
ConnectionString : String
Connection string to Snowflake.
Default: -
Example: account=myaccount;host=myaccount.snowflakecomputing.com;user=myuser;db=mydb;schema=public
PrivateKeyFilePath : String
Full file path to the private key (.p8) used for Snowflake key pair authentication.
Default: -
Example: C:\keys\rsa_key.p8
🗝PrivateKeyPassphrase : String
Optional passphrase for the private key file, if the key was generated with encryption.
Leave empty if the key file is unencrypted.
Default: -
Example: MySuperSecret123
ThrowErrorOnFailure : Boolean
Whether to throw an error on failure.
Default: True
Example: true
ErrorMessageOnFailure : String
Overrides the error message on failure.
Default: -
Example: Custom error message
Success : Boolean
Indicates if the task completed successfully.
Example: true
AffectedRows : Int32
Number of affected rows.
Example: 2
Error : Error
Error that occurred during task execution.
Example: object { string Message, Exception AdditionalInfo }
Changelog for Task Frends.Snowflake.BatchOperation.
Ensure FrendsTaskMetadata.json is included in NuGet package
Initial implementation
Last updated
Was this helpful?
Was this helpful?