Execute SQL Statement With Pagination

(Optional) Database in which the statement should be executed. The value in this field is case-sensitive. If you omit this field, the SQL API uses the database from the value of the DEFAULT_NAMESPACE property of the user.

(Optional) Warehouse to use when executing the statement. The value in this field is case-sensitive. If you omit this field, the SQL API uses the value of the DEFAULT_WAREHOUSE property of the user.

(Optional) Set to true to execute the statement asynchronously and return the statement handle.

• If the parameter is not specified or is set to false, a statement is executed and the results are returned if the execution is completed in 45 seconds.

• If the statement execution takes longer to complete, the statement handle is returned.

(Optional) Set to false to return a SQL NULL value as the string "null", rather than as the value null.

(Optional) Values of bind variables in the SQL statement. When executing the statement, Snowflake replaces placeholders (? and :name) in the statement with the provided values.

Example: {"1":{"type":"FIXED","value":"123"},"2":{"type":"TEXT","value":"teststring"}}

(Optional) Session parameters that you want to set for this request.

(Optional) Timeout in seconds for statement execution. To set the timeout to the maximum value (604800 seconds), set timeout to 0.

(Optional) Schema in which the statement should be executed. The value in this field is case-sensitive. If you omit this field, the SQL API uses the schema from the value of the DEFAULT_NAMESPACE property of the user.

(Optional) Role to use when executing the statement. The value in this field is case-sensitive. If you omit this field, the SQL API uses the value of the DEFAULT_ROLE property of the user.