statement_exceptions

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

Overview

Name	statement_exceptions
Type	Resource
Id	confluent.sql.statement_exceptions

Fields

Name	Datatype	Description
name	string	Name of the SQL statement exception.
kind	string	Kind defines the object this REST resource represents.
message	string	Error message of the statement exception.
timestamp	string	The date and time at which the exception occurred. It is represented in RFC3339 format and is in UTC.

Methods

Name	Accessible by	Required Params	Description
get_sqlv1statement_exceptions	SELECT	environment_id, organization_id, statement_name	Retrieve a list of the 10 most recent statement exceptions.

SELECT examples

Retrieve a list of the 10 most recent statement exceptions.

SELECT
name,
kind,
message,
timestamp
FROM confluent.sql.statement_exceptions
WHERE environment_id = '{{ environment_id }}'
AND organization_id = '{{ organization_id }}'
AND statement_name = '{{ statement_name }}';