results

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

Overview

Name	results
Type	Resource
Id	snowflake.sqlapi.results

Fields

The following fields are returned by SELECT queries:

fetch_result

Name	Datatype	Description
code	string	(example: 000123)
createdOn	integer (int64)	Timestamp that specifies when the statement execution started.‌ The timestamp is expressed in milliseconds since the epoch.‌
data	array	Result set data.
message	string	(example: successfully executed)
resultSetMetaData	object
sqlState	string	(example: 42601)
statementHandle	string (uuid)	(example: 536fad38-b564-4dc5-9892-a4543504df6c)
statementStatusUrl	string (uri)
stats	object	these stats might not be available for each request.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
fetch_result	select	result_handler, endpoint	page	Get result status or the result when it is ready.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
endpoint	string	Organization and account identifier (orgname-accountname) (default: orgname-accountname)
result_handler	string	The opaque result id.
page	integer (int64)	Number of the page of results to return. The number can range from 0 to the total number of pages minus 1.

SELECT examples

fetch_result

Get result status or the result when it is ready.

SELECT
code,
createdOn,
data,
message,
resultSetMetaData,
sqlState,
statementHandle,
statementStatusUrl,
stats
FROM snowflake.sqlapi.results
WHERE result_handler = '{{ result_handler }}' -- required
AND endpoint = '{{ endpoint }}' -- required
AND page = '{{ page }}'
;