Source
Python Connector API
Purpose: Constructor for creating a connection to the database. Returns a Connection object. By default, autocommit mode is enabled (i.e. if the connection is closed, all changes are committed).
Snowflake SQL API reference
To submit one or more SQL statements for execution, send a POST request to /api/v2/statements. You can specify that the statement should be executed asynchronously.
Error "Multiple SQL statements in a single API call are not supported" when executing queries from Snowsight
ISSUE: Queries in the Snowsight worksheets fail with the following error:"Multiple SQL statements in a single API call are not supported; use one API call per statement instead."…
About the SQL API endpoints
The SQL API is available at https://account_identifier.snowflakecomputing.com/api, where account_identifier is your account identifier.