Snowflake API

A RESTful interface for executing SQL statements and managing data workflows via HTTP requests without persistent drivers.

The Snowflake SQL API provides a lightweight alternative to traditional JDBC or ODBC drivers by exposing a RESTful endpoint for data operations. Developers submit POST requests to the /api/v2/statements resource to trigger queries, manage warehouse scaling, or execute COPY INTO commands for data ingestion. The API returns results in partitioned JSON blocks: an ideal structure for serverless environments (like AWS Lambda) that require stateless, high-speed connections. It supports asynchronous execution and custom timeout settings (up to 3600 seconds) to ensure reliable processing for complex analytical workloads.

https://docs.snowflake.com/en/developer-guide/sql-api/index