Snowflake - Insert Multiple Rows

[pipedream-component-development]

App

Snowflake - Insert Multiple Rows
https://github.com/PipedreamHQ/pipedream/blob/master/components/snowflake/actions/insert-multiple-rows/insert-multiple-rows.mjs

Actions

Subject: Issue with Snowflake "Insert Multiple Rows" Component - Payload Too Large (413 Error)
Hi!
We are encountering an issue when attempting to insert data into Snowflake using the "Insert Multiple Rows" component. We're consistently receiving a "Payload Too Large" error with a status: 413 (event link).
Here's the relevant error information:
data:

<title>Error</title>

Payload Too Large

status: 413
We are trying to insert approximately 374 rows, with each row containing 77 columns, compacted as a JSON object. This suggests the total payload size is exceeding an internal limit.

[vunguyenhung]

Added it to Pipedream internal backlog, but I would recommend you to limit number of rows to avoid this error

[andrewjschuang]

@vunguyenhung could this action be improved in the component side to avoid the error? Maybe batching or sending the data by chunks

[vunguyenhung]

Hi @andrewjschuang, makes sense. I'll add to component backlog