[BUG] Snowflake connector fails to access API

Type of Connector

Certified Connector

Name of Connector

Snowflake

Describe the bug

Snowflake connector could previously access data by using the Execute SQL Statement activity and return data with no issues. As of Monday 8/21/2023, we are no longer able to retrieve data in any flow that uses this connector. All instances of the connector return the same error.

The API 'snowflakeip' returned an invalid response for workflow operation 'get_warehouses' of type 'OpenApiConnection'. Error details: 'The API operation 'ExecuteSqlStatement' requires the property 'body' to be of type 'Object' but is of type 'String'.'

Is this a security bug?

No, this is not 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 Power Automate Flow
Create an Execute SQL Statement Activity
Create connection to Snowflake
Enter required fields
Run flow
Retrieve results object

Expected behavior

After filling out required fields such as instance and SQL the query should be sent to Snowflake and return a json body containing the results.

Environment summary

Power Automate
Snowflake Connector

Additional context

Error Message: : The API 'snowflakeip' returned an invalid response for workflow operation 'get_warehouses' of type 'OpenApiConnection'. Error details: 'The API operation 'ExecuteSqlStatement' requires the property 'body' to be of type 'Object' but is of type 'String'.'

Start by reproducing the failure with a Power Automate flow using the Snowflake connector's Execute SQL Statement activity. Inspect the request and response around the reported get_warehouses operation; done means the query is accepted and the flow returns the expected JSON results.