Source
Snowflake SQL API reference
This topic documents the operations, requests, and responses for the SQL API.
External function Error assuming AWS ROLE
ISSUE: Calling an external function returns the message below. The AWS IAM role (API Role) is valid, with correct privileges and a valid trust relationship with the Snowflake IAM User and External ID.
Improper JSON format response in SQL API
CAUSE: SQL API response was generating the wrong JSON format.In the ResultSet object in the response, the results are in the data field.