Source
Snowflake SQL API reference
This topic documents the operations, requests, and responses for the SQL API.
ARRAYS_ZIP
Returns an array of objects, each of which contains key - value pairs for an nth element in the input arrays.
About the SQL API endpoints
The SQL API is available at https://account_identifier.snowflakecomputing.com/api, where account_identifier is your account identifier.
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.
Step 2: Create the proxy service (Google Cloud API Gateway) in the console
Snowflake does not send data (HTTP POST requests) directly to a remote service. Instead, Snowflake sends the data to a proxy service that relays the data from Snowflake to the remote service (i.e. GCP Cloud Function) and back again.
Python Connector API
The Snowflake Connector for Python implements the Python Database API v2.0 specification (PEP - 249). This topic covers the standard API and the Snowflake - specific extensions.
Threads API
…the thread was last updated (milliseconds since UNIX epoch). An update includes adding any new messages to the thread.