statement_results

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

Overview

Name	statement_results
Type	Resource
Id	confluent.sql.statement_results

Fields

The following fields are returned by SELECT queries:

get_sqlv1_statement_result

Statement Result.

Name	Datatype	Description
api_version	string	APIVersion defines the schema version of this representation of a resource. (sql/v1) (example: sql/v1)
kind	string	Kind defines the object this REST resource represents. (StatementResult)
metadata	object	ListMeta describes metadata that resource collections may have
results	object	A results property that contains a data property that contains an array of results.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_sqlv1_statement_result	select	organization_id, environment_id, name	page_token	Read Statement Result.

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
environment_id	string	The unique identifier for the environment.
name	string	The unique identifier for the statement.
organization_id	string (uuid)	The unique identifier for the organization.
page_token	string	It contains the field offset in the CollectSinkFunction protocol. On the first request, it should be unset. The offset is assumed to start at 0.

SELECT examples

get_sqlv1_statement_result

Read Statement Result.

SELECT
api_version,
kind,
metadata,
results
FROM confluent.sql.statement_results
WHERE organization_id = '{{ organization_id }}' -- required
AND environment_id = '{{ environment_id }}' -- required
AND name = '{{ name }}' -- required
AND page_token = '{{ page_token }}'
;