[BUG] Snowflake Integration using COPY INTO Statements

[IlyaAspirent]

Type of Connector

Certified Connector

Name of Connector

Snowflake (Preview)

Describe the bug

Attempting to submit a copy into statement to snowflake via power automate. When submitting the query, I receive an error message of:

The API 'snowflakeip' returned an invalid response for workflow operation 'Submit_SQL_Statement_for_Execution' of type 'OpenApiConnection'. Error details: 'The API operation 'ExecuteSqlStatement' requires the property 'body/data/0/6' to be of type 'String' but is of type 'Null'.'

It looks as though the connector requires there to be data received; however, with a copy into statement, I am only posting data.

Is this a security bug?

Yes, this is a security bug

What is the severity of this bug?

Severity 1 - Connector is broken or there's a very serious issue

To Reproduce

Create a flow that submits a table to snowflake.

Expected behavior

There should be some sort of response message that avoids the error generation so that the flow does not break. Additionally this prevents the ability to write error handling against the completion of the sql component.

Environment summary

Install Method (e.g. pip, interactive script, apt-get, Docker, MSI, edge build) CLI version (paconn --version) OS version Shell Type (e.g. bash, cmd.exe, Bash on Windows)

Additional context

I am able to see that the table is being written to; however, power automate shows this section of the flow as a failed because it is looking for the response data to populate into the body section of the JSON.