statements

Creates, updates, deletes, gets or lists a statements resource.

Overview

Name	statements
Type	Resource
Id	snowflake.sqlapi.statements

Fields

Name	Datatype	Description
code	string
createdOn	integer	Timestamp that specifies when the statement execution started.‌ The timestamp is expressed in milliseconds since the epoch.‌
data	array	Result set data.
message	string
resultSetMetaData	object
sqlState	string
statementHandle	string
statementStatusUrl	string
stats	object	these stats might not be available for each request.

Methods

Name	Accessible by	Required Params	Description
get_statement_status	SELECT	User-Agent, statementHandle, endpoint	Checks the status of the execution of the statement with the specified statement handle. If the statement was executed successfully, the operation returns the requested partition of the result set.
submit_statement	SELECT	User-Agent, endpoint	Submits one or more statements for execution. You can specify that the statement should be executed asynchronously.
cancel_statement	EXEC	User-Agent, statementHandle, endpoint	Cancels the execution of the statement with the specified statement handle.

SELECT examples

Submits one or more statements for execution. You can specify that the statement should be executed asynchronously.

SELECT
code,
createdOn,
data,
message,
resultSetMetaData,
sqlState,
statementHandle,
statementStatusUrl,
stats
FROM snowflake.sqlapi.statements
WHERE User-Agent = '{{ User-Agent }}'
AND endpoint = '{{ endpoint }}';