Skip to main content

List of Statements

GET 

/sql/v1/organizations/:organization_id/environments/:environment_id/statements

General Availability

Retrieve a sorted, filtered, paginated list of all statements.

Request​

Responses​

Statements.

Response Headers
    X-Request-Id

    The unique identifier for the API request.

OpenAPI definition (YAML)
paths:
  /sql/v1/organizations/{organization_id}/environments/{environment_id}/statements:
    get:
      x-lifecycle-stage: General Availability
      x-self-access: true
      x-request-access-name: SQL API v1
      operationId: listSqlv1Statements
      description: '[![General Availability](https://img.shields.io/badge/Lifecycle%20Stage-General%20Availability-%2345c6e8)](#section/Versioning/API-Lifecycle-Policy)


        Retrieve a sorted, filtered, paginated list of all statements.'
      parameters:
      - in: path
        name: organization_id
        schema:
          type: string
          format: uuid
        required: true
        description: The unique identifier for the organization.
      - in: path
        name: environment_id
        required: true
        schema:
          type: string
        description: The unique identifier for the environment.
      - name: spec.compute_pool_id
        in: query
        required: false
        schema:
          type: string
        example: lfcp-00000
        description: 'Filter the results by exact match for spec.compute_pool_id.

          When creating statements, if compute_pool_id is not specified, the statement will use the default
          compute pool. The default pool is automatically determined by the system.'
      - name: page_size
        in: query
        required: false
        schema:
          type: integer
          default: 10
          maximum: 100
          x-max-page-items: 500
        description: A pagination size for collection requests.
      - name: page_token
        in: query
        required: false
        schema:
          type: string
          maxLength: 255
        description: An opaque pagination token for collection requests.
      - name: label_selector
        in: query
        required: false
        schema:
          type: string
        style: form
        explode: false
        description: A comma-separated label selector to filter the statements.
      tags:
      - Statements (sql/v1)
      security:
      - resource-api-key: []
      - global-api-key: []
      - external-access-token: []
      responses:
        '200':
          description: Statements.
          content:
            application/json:
              schema:
                type: object
                description: '`Statement` represents a core resource used to model SQL statements for
                  execution.

                  A statement generalizes DDL, DML, DQL, etc., but doesn’t attempt to handle session

                  management or any higher-level functionality.

                  The API allows you to list, create, read, and delete your statements.

                  '
                required:
                - api_version
                - kind
                - metadata
                - data
                properties:
                  api_version:
                    type: string
                    enum:
                    - sql/v1
                    description: APIVersion defines the schema version of this representation of a resource.
                    example: sql/v1
                  kind:
                    type: string
                    description: Kind defines the object this REST resource represents.
                    enum:
                    - StatementList
                  metadata:
                    allOf:
                    - type: object
                      description: ListMeta describes metadata that resource collections may have
                      properties:
                        first:
                          description: A link to the first page of results. If a response does not contain
                            a first link, then direct navigation to the first page is not supported.
                          type: string
                          format: uri
                          nullable: true
                          example: https://api.confluent.cloud/v2/resourcekinds
                        last:
                          description: A link to the last page of results. If a response does not contain
                            a last link, then direct navigation to the last page is not supported.
                          type: string
                          format: uri
                          nullable: true
                          example: https://api.confluent.cloud/v2/resourcekinds?page_token=bcAOehAY8F16YD84Z1wT
                        prev:
                          description: A link to the previous page of results. If a response does not
                            contain a prev link, then either there is no previous data or backwards traversal
                            through the result set is not supported.
                          type: string
                          format: uri
                          nullable: true
                          example: https://api.confluent.cloud/v2/resourcekinds?page_token=YIXRY97wWYmwzrax4dld
                        next:
                          description: A link to the next page of results. If a response does not contain
                            a next link, then there is no more data available.
                          type: string
                          format: uri
                          nullable: true
                          example: https://api.confluent.cloud/v2/resourcekinds?page_token=UvmDWOB1iwfAIBPj6EYb
                        total_size:
                          description: Number of records in the full result set. This response may be
                            paginated and have a smaller number of records.
                          type: integer
                          format: int32
                          minimum: 0
                          example: 123
                      title: ListMeta
                    - properties:
                        self:
                          example: https://flink.us-west1.aws.confluent.cloud/sql/v1/environments/env-123/statements
                        first:
                          example: https://flink.us-west1.aws.confluent.cloud/sql/v1/environments/env-abc123/statements
                        last:
                          example: ''
                        prev:
                          example: ''
                        next:
                          example: https://flink.us-west1.aws.confluent.cloud/sql/v1/environments/env-abc123/statements?page_token=UvmDWOB1iwfAIBPj6EYb
                  data:
                    type: array
                    description: A data property that contains an array of resource items. Each entry
                      in the array is a separate resource.
                    items:
                      allOf:
                      - type: object
                        description: '`Statement` represents a core resource used to model SQL statements
                          for execution.

                          A statement generalizes DDL, DML, DQL, etc., but doesn’t attempt to handle session

                          management or any higher-level functionality.

                          The API allows you to list, create, read, and delete your statements.

                          '
                        properties:
                          api_version:
                            type: string
                            enum:
                            - sql/v1
                            description: APIVersion defines the schema version of this representation
                              of a resource.
                            example: sql/v1
                            readOnly: true
                          kind:
                            type: string
                            description: Kind defines the object this REST resource represents.
                            enum:
                            - Statement
                            readOnly: true
                          metadata:
                            allOf:
                            - description: The metadata of the statement.
                              required:
                              - self
                              properties:
                                self:
                                  description: Self is a Uniform Resource Locator (URL) at which an object
                                    can be addressed. This URL encodes the service location, API version,
                                    and other particulars necessary to locate the resource at a point
                                    in time
                                  type: string
                                  format: uri
                                  example: https://flink.us-west1.aws.confluent.cloud/sql/v1/environments/env-123/statements/my-statement
                                created_at:
                                  type: string
                                  format: date-time
                                  example: '1996-03-19T01:02:03-04:05'
                                  description: The date and time at which this object was created. It
                                    is represented in RFC3339 format and is in UTC.
                                updated_at:
                                  type: string
                                  format: date-time
                                  example: '2025-11-10T16:20:00Z'
                                  description: The date and time at which this object was last updated.
                                    It is represented in RFC3339 format and is in UTC.
                                uid:
                                  type: string
                                  example: 12345678-1234-1234-1234-123456789012
                                  description: A system generated globally unique identifier for this
                                    resource.
                                resource_version:
                                  type: string
                                  example: a23av
                                  description: A system generated string that uniquely identifies the
                                    version of this resource.
                                labels:
                                  type: object
                                  description: A map of key-value pairs that describe the resource.
                                  additionalProperties:
                                    type: string
                                  example:
                                    user.confluent.io/hidden: 'true'
                              readOnly: true
                              title: StatementObjectMeta
                            - properties:
                                self:
                                  example: https://flink.us-west1.aws.confluent.cloud/sql/v1/environments/env-123/statements/my-statement
                                uid:
                                  example: 12345678-1234-1234-1234-123456789012
                                resource_version:
                                  example: a23av
                                resource_name:
                                  example: ''
                                labels:
                                  type: object
                                  additionalProperties:
                                    type: string
                          name:
                            type: string
                            example: sql123
                            description: The user provided name of the resource, unique within this environment.
                            pattern: '[a-z0-9]([-a-z0-9]*[a-z0-9])?(\.[a-z0-9]([-a-z0-9]*[a-z0-9])?)*'
                            x-immutable: true
                            maxLength: 100
                          organization_id:
                            type: string
                            format: uuid
                            description: The unique identifier for the organization.
                            x-immutable: true
                          environment_id:
                            type: string
                            description: The unique identifier for the environment.
                            x-immutable: true
                          spec:
                            type: object
                            description: The specs of the Statement
                            properties:
                              statement:
                                type: string
                                example: SELECT * FROM TABLE WHERE VALUE1 = VALUE2;
                                description: The raw SQL text statement.
                                x-immutable: true
                                maxLength: 131072
                              properties:
                                type: object
                                example:
                                  sql.current-catalog: my_environment
                                  sql.current-database: my_kafka_cluster
                                description: 'A map (key-value pairs) of statement properties.

                                  It is set when the statement is created and cannot be changed afterward.'
                                additionalProperties:
                                  type: string
                                maxProperties: 8192
                                x-immutable: true
                              compute_pool_id:
                                type: string
                                example: fcp-00000
                                description: 'The id associated with the compute pool in context.

                                  If not specified, the statement will use the default compute pool. The
                                  default pool is automatically determined by the system.'
                                maxLength: 255
                              principal:
                                type: string
                                example: sa-abc123
                                description: "The id of the principal this statement runs as. Possible\
                                  \ values:\n\n  * `u-abc123` — user\n  * `sa-abc123` — service account\n\
                                  \  * `pool-abc123` — identity pool (OAuth caller authorized\n    against\
                                  \ a single pool, either explicitly supplied or\n    resolved by the\
                                  \ server)\n  * an identity CRN equal to `status.identity` (OAuth caller\n\
                                  \    authorized against multiple identity pools)\n\nCustomers typically\
                                  \ supply one of the short prefixed ids and read\nthe same value back.\
                                  \ The CRN form is server-set in the multi-pool\ncase; clients should\
                                  \ accept it when reading but should not need\nto construct it.\n\nThe\
                                  \ principal can be changed after the statement is created by\nupdating\
                                  \ the statement with a new value. When it is updated,\n`status.identity`\
                                  \ is refreshed to reflect the caller that made\nthe change.\n"
                                maxLength: 1024
                              stopped:
                                type: boolean
                                description: Indicates whether the statement should be stopped.
                                example: false
                              execution_mode:
                                type: string
                                example: streaming
                                description: 'The execution mode of the statement.


                                  Note - The attribute is in a [Early Access lifecycle](https://docs.confluent.io/cloud/current/api.html#section/Versioning/API-Lifecycle-Policy)

                                  '
                                maxLength: 255
                                readOnly: true
                              scaling:
                                description: Mutable scaling configuration that can be updated for a running
                                  statement.
                                type: object
                                properties:
                                  baseline_cfu:
                                    type: integer
                                    format: int32
                                    description: 'The baseline number of Confluent Flink Units (CFUs)
                                      targeted for the statement.

                                      This is a best-effort target rather than a guarantee, and the statement
                                      may auto-scale above it.

                                      '
                                    example: 2
                                    minimum: 0
                                title: sql.v1.ScalingSpec
                            x-enable-listmeta: true
                            x-enable-objectmeta: true
                            title: sql.v1.StatementSpec
                          status:
                            type: object
                            required:
                            - phase
                            description: The status of the Statement
                            properties:
                              phase:
                                type: string
                                description: 'The lifecycle phase of the submitted SQL statement:


                                  PENDING: SQL statement is pending execution;


                                  RUNNING: SQL statement execution is in progress;


                                  COMPLETED: SQL statement is completed;


                                  DELETING: SQL statement deletion is in progress;


                                  FAILING: SQL statement is failing;


                                  FAILED: SQL statement execution has failed;


                                  STOPPING: SQL statement is being stopped;


                                  STOPPED: SQL statement execution has successfully been stopped;


                                  DEGRADED: SQL statement is experiencing reduced performance or partial
                                  failure;

                                  '
                                example: RUNNING
                                readOnly: true
                                enum:
                                - PENDING
                                - RUNNING
                                - COMPLETED
                                - DELETING
                                - FAILING
                                - FAILED
                                - STOPPING
                                - STOPPED
                                - DEGRADED
                              scaling_status:
                                description: Scaling status for this statement.
                                type: object
                                properties:
                                  scaling_state:
                                    description: 'OK: The statement runs at the right scale.


                                      PENDING_SCALE_DOWN: The statement requires less resources, and will
                                      be scaled down in the near future.


                                      PENDING_SCALE_UP: The statement requires more resources, and will
                                      be scaled up in the near future.


                                      POOL_EXHAUSTED: The statement requires more resources, but not enough
                                      resources are available.

                                      '
                                    example: OK
                                    readOnly: true
                                    type: string
                                    enum:
                                    - OK
                                    - PENDING_SCALE_DOWN
                                    - PENDING_SCALE_UP
                                    - POOL_EXHAUSTED
                                  last_updated:
                                    description: The last time the scaling status was updated.
                                    example: '1996-03-19 01:02:03-04:05'
                                    format: date-time
                                    readOnly: true
                                    type: string
                                readOnly: true
                                title: sql.v1.ScalingStatus
                              catch_up_status:
                                description: Catch-up status for this statement.
                                type: object
                                properties:
                                  catch_up_state:
                                    description: 'CATCHING_UP: The statement is processing historical
                                      data, in batch mode.


                                      CAUGHT_UP: The statement is processing live data, in streaming mode.

                                      '
                                    example: CAUGHT_UP
                                    readOnly: true
                                    type: string
                                    enum:
                                    - CATCHING_UP
                                    - CAUGHT_UP
                                  last_updated:
                                    description: The last time the catch-up status was updated.
                                    example: '1996-03-19 01:02:03-04:05'
                                    format: date-time
                                    readOnly: true
                                    type: string
                                readOnly: true
                                title: sql.v1.CatchUpStatus
                              state_limit_status:
                                description: State limit status for this statement.
                                properties:
                                  state_limit_state:
                                    description: 'OK: The statement is within state limits.


                                      APPROACHING_SOFT_LIMIT: The statement is approaching soft state
                                      limits.


                                      EXCEEDING_SOFT_LIMIT: The statement is exceeding soft state limits.


                                      APPROACHING_HARD_LIMIT: The statement is approaching hard state
                                      limits.


                                      EXCEEDING_HARD_LIMIT: The statement is exceeding hard state limits.

                                      '
                                    example: OK
                                    readOnly: true
                                    type: string
                                    enum:
                                    - OK
                                    - APPROACHING_SOFT_LIMIT
                                    - EXCEEDING_SOFT_LIMIT
                                    - APPROACHING_HARD_LIMIT
                                    - EXCEEDING_HARD_LIMIT
                                  last_updated:
                                    description: The last time the state limit status was updated.
                                    example: '1996-03-19 01:02:03-04:05'
                                    format: date-time
                                    readOnly: true
                                    type: string
                                  detail:
                                    description: Details about why state limit status is in its current
                                      state.
                                    example: The statement is within state limits.
                                    type: string
                                    readOnly: true
                                readOnly: true
                                type: object
                                title: sql.v1.StateLimitStatus
                              detail:
                                type: string
                                description: Details about the execution status of this statement.
                                example: Statement is running successfully
                                readOnly: true
                              warnings:
                                type: array
                                description: List of warnings encountered during statement execution.
                                items:
                                  type: object
                                  description: Represents a non-fatal issue encountered during statement
                                    processing.
                                  required:
                                  - severity
                                  - created_at
                                  - reason
                                  - message
                                  properties:
                                    severity:
                                      type: string
                                      description: 'Indicates the severity of the warning.


                                        LOW: Indicates a low severity warning and for informing the user.


                                        MODERATE: Indicates a moderate severity warning and may require
                                        user action. Could cause degraded statements if certain conditions
                                        apply.


                                        CRITICAL: Indicates a critical severity warning and requires user
                                        action. It will cause degraded statements eventually.

                                        '
                                      example: MODERATE
                                      enum:
                                      - LOW
                                      - MODERATE
                                      - CRITICAL
                                      title: sql.v1.WarningSeverity
                                    created_at:
                                      type: string
                                      format: date-time
                                      description: The timestamp when the warning was created. It is represented
                                        in RFC3339 format and is in UTC.
                                      example: '2025-11-10T16:20:00Z'
                                      readOnly: true
                                    reason:
                                      type: string
                                      description: A machine-readable short, upper case summary delimited
                                        by underscore.
                                      example: MISSING_WINDOW_START_END
                                    message:
                                      type: string
                                      description: A human-readable string containing the description
                                        of the warning.
                                      example: The statement is missing window start and end bounds which
                                        may lead to unbounded state growth.
                                  title: sql.v1.StatementWarning
                                readOnly: true
                              traits:
                                type: object
                                description: StatementTraits contains detailed information about the properties
                                  of a Statement
                                properties:
                                  sql_kind:
                                    type: string
                                    description: Categorizes the SQL statement. The result is Confluent-specific
                                      but inspired by SQL. It uses underscores for separating concepts
                                      e.g. "CREATE_TABLE".
                                    example: SELECT
                                  is_bounded:
                                    type: boolean
                                    description: Indicates the special case where results of a statement
                                      are bounded.
                                  is_append_only:
                                    type: boolean
                                    description: Indicates the special case where results of a statement
                                      are insert/append only.
                                  upsert_columns:
                                    type: array
                                    description: Defines the column indices clients can use as upsert
                                      keys.
                                    items:
                                      type: integer
                                  schema:
                                    type: object
                                    description: The table columns of the results schema.
                                    properties:
                                      columns:
                                        type: array
                                        description: The properties of each SQL column in the schema.
                                        items:
                                          type: object
                                          description: A column in the results schema.
                                          required:
                                          - name
                                          - type
                                          properties:
                                            name:
                                              type: string
                                              description: The name of the SQL table column.
                                              example: Column_Name
                                            type:
                                              allOf:
                                              - type: object
                                                properties:
                                                  type:
                                                    type: string
                                                    description: 'The data type of the column, for example
                                                      `INTEGER`, `VARCHAR`, `ARRAY`, `MAP`, `ROW` or `VARIANT`.

                                                      '
                                                  nullable:
                                                    type: boolean
                                                    description: Indicates whether values in this column
                                                      can be null.
                                                  length:
                                                    type: integer
                                                    format: int32
                                                    description: The length of the data type.
                                                  precision:
                                                    type: integer
                                                    format: int32
                                                    description: The precision of the data type.
                                                  scale:
                                                    type: integer
                                                    format: int32
                                                    description: The scale of the data type.
                                                  key_type:
                                                    allOf:
                                                    - circular(DataType)
                                                    description: The type of the key in the data type
                                                      (if applicable).
                                                  value_type:
                                                    allOf:
                                                    - circular(DataType)
                                                    description: The type of the value in the data type
                                                      (if applicable).
                                                  element_type:
                                                    allOf:
                                                    - circular(DataType)
                                                    description: The type of the element in the data type
                                                      (if applicable).
                                                  fields:
                                                    type: array
                                                    items:
                                                      type: object
                                                      properties:
                                                        name:
                                                          type: string
                                                          description: The name of the field.
                                                        field_type:
                                                          allOf:
                                                          - circular(DataType)
                                                          description: The data type of the field.
                                                        description:
                                                          type: string
                                                          description: The description of the field.
                                                      required:
                                                      - name
                                                      - field_type
                                                      title: RowFieldType
                                                    description: The fields of the element in the data
                                                      type (if applicable).
                                                  resolution:
                                                    type: string
                                                    description: The resolution of the data type (if applicable).
                                                  fractional_precision:
                                                    type: integer
                                                    format: int32
                                                    description: The fractional precision of the data
                                                      type (if applicable).
                                                  class_name:
                                                    type: string
                                                    description: The class name of the structured data
                                                      type (if applicable).
                                                required:
                                                - type
                                                - nullable
                                                title: DataType
                                              description: JSON object in TableSchema format; describes
                                                the data returned by the results serving API.
                                              example:
                                                type: CHAR
                                                nullable: true
                                                length: 8
                                          title: ColumnDetails
                                    title: sql.v1.ResultSchema
                                  connection_refs:
                                    type: array
                                    description: The names of connections that the SQL statement references
                                      (e.g., in FROM clauses).
                                    items:
                                      type: string
                                    example:
                                    - my-postgres-connection
                                    - my-kafka-connection
                                readOnly: true
                                title: sql.v1.StatementTraits
                              network_kind:
                                type: string
                                description: 'The networking type used by the submitted SQL statement:


                                  PUBLIC: SQL statement is using public networking;


                                  PRIVATE: SQL statement is using private networking;

                                  '
                                example: PUBLIC
                                readOnly: true
                                enum:
                                - PUBLIC
                                - PRIVATE
                              latest_offsets:
                                type: object
                                additionalProperties:
                                  type: string
                                description: 'The last Kafka offsets that a statement has processed. Represented
                                  by a mapping from Kafka topic to a

                                  string representation of partitions mapped to offsets.

                                  '
                                example:
                                  topic-1: partition:0,offset:100;partition:1,offset:200
                                  topic-2: partition:0,offset:50
                                readOnly: true
                              latest_offsets_timestamp:
                                type: string
                                format: date-time
                                example: '2025-11-10T16:20:00Z'
                                description: The date and time at which the Kafka topic offsets were added
                                  to the statement status. It is represented in RFC3339 format and is
                                  in UTC.
                                readOnly: true
                              end_time:
                                type: string
                                format: date-time
                                example: '2025-03-19T01:02:03-04:05'
                                description: 'The date and time in UTC (represented as RFC3339 format)
                                  at which the statement reached its final terminal state.

                                  This field is set when the Phase is COMPLETED, FAILED, or STOPPED.


                                  Note - The attribute is in a [Early Access lifecycle](https://docs.confluent.io/cloud/current/api.html#section/Versioning/API-Lifecycle-Policy)

                                  '
                              duration:
                                type: string
                                format: duration
                                example: PT2H30M
                                description: 'The total elapsed time (represented as ISO 8601 format)
                                  from when the statement transitioned from

                                  PENDING to RUNNING until it reached a final terminal state. This field
                                  is calculated and set when

                                  the Phase is COMPLETED, FAILED, or STOPPED.


                                  Note - The attribute is in a [Early Access lifecycle](https://docs.confluent.io/cloud/current/api.html#section/Versioning/API-Lifecycle-Policy)

                                  '
                              affected_resource:
                                type: object
                                description: 'A reference to the resource created by this statement, if
                                  any. This field is set when a statement

                                  (e.g., CREATE MATERIALIZED TABLE) results in a new user-facing resource.


                                  Note - The attribute is in a [Early Access lifecycle](https://docs.confluent.io/cloud/current/api.html#section/Versioning/API-Lifecycle-Policy)

                                  '
                                required:
                                - kind
                                - environment_id
                                - resource_name
                                properties:
                                  kind:
                                    type: string
                                    description: The kind of resource that was created.
                                    example: MATERIALIZED_TABLE
                                    enum:
                                    - MATERIALIZED_TABLE
                                  environment_id:
                                    type: string
                                    description: The unique identifier for the environment containing
                                      the resource.
                                    example: env-abc
                                  database_id:
                                    type: string
                                    description: 'The unique identifier for the database containing the
                                      resource.

                                      Only present for resource kinds that are scoped to a database.

                                      '
                                    example: lkc-123
                                  resource_name:
                                    type: string
                                    description: The name of the created resource, unique within its scope.
                                    example: my-materialized-table
                              identity:
                                type: string
                                format: uri
                                example: crn://confluent.cloud/organization=12345/identity-provider=op-12345/identity=alice@example.com
                                description: "Optional, read-only. The CRN of the authenticated principal\
                                  \ that\ncurrently owns this statement, sourced from the upstream\nauthentication\
                                  \ decision. Initially populated when the statement\nis created and refreshed\
                                  \ when `spec.principal` is updated, so it\nreflects the most recent\
                                  \ setter rather than the original creator.\n\nTreat as a stable, opaque,\
                                  \ non-parsable string for storage and\nmapping; do not implement business\
                                  \ logic or branching based on\nthe identity type or string structure.\
                                  \ The set of identity\nshapes may grow over time and is not considered\
                                  \ breaking.\n\nThe `example` above illustrates the OAuth (identity-provider)\n\
                                  shape. Set for all supported authentication methods; the CRN\nshape\
                                  \ varies by auth type:\n\n  * User: `crn://confluent.cloud/organization=12345/user=u-abc123`\n\
                                  \  * Service account: `crn://confluent.cloud/organization=12345/service-account=sa-abc123`\n\
                                  \  * OAuth (identity provider): `crn://confluent.cloud/organization=12345/identity-provider=op-12345/identity=alice@example.com`\n\
                                  \nFor the OAuth shape, the value after `identity=` is the JWT\nclaim\
                                  \ resolved by the identity provider's configured\n`identity_claim` (or\
                                  \ the identity pool's `identity_claim` when\na single pool is in scope)\
                                  \ — commonly `claims.sub`, but\nprovider-configurable. The email shown\
                                  \ above is just one\nexample; the actual value depends on the identity\
                                  \ provider\nconfiguration and may be a subject UUID, a username, or\
                                  \ any\nother opaque claim value.\n\nWhen the request was authenticated\
                                  \ via OAuth and authorized\nagainst multiple identity pools, this CRN\
                                  \ also appears as\n`spec.principal`. May be omitted for statements created\
                                  \ before\nthis field was introduced.\n"
                                maxLength: 1024
                                readOnly: true
                            readOnly: true
                            title: sql.v1.StatementStatus
                          result:
                            type: object
                            description: '`Statement Result` represents a resource used to model results
                              of SQL statements.

                              The API allows you to read your SQL statement result.'
                            required:
                            - api_version
                            - kind
                            - metadata
                            - data
                            properties:
                              api_version:
                                type: string
                                enum:
                                - sql/v1
                                description: APIVersion defines the schema version of this representation
                                  of a resource.
                                example: sql/v1
                                readOnly: true
                              kind:
                                type: string
                                description: Kind defines the object this REST resource represents.
                                enum:
                                - StatementResult
                                readOnly: true
                              metadata:
                                readOnly: true
                                allOf:
                                - type: object
                                  description: ListMeta describes metadata that resource collections may
                                    have
                                  properties:
                                    self:
                                      description: Self is a Uniform Resource Locator (URL) at which an
                                        object can be addressed. This URL encodes the service location,
                                        API version, and other particulars necessary to locate the resource
                                        at a point in time
                                      type: string
                                      example: https://flink.us-west1.aws.confluent.cloud/sql/v1/environments/env-123/statements
                                    next:
                                      description: A URL that can be followed to get the next batch of
                                        results.
                                      type: string
                                      example: https://flink.us-west1.aws.confluent.cloud/sql/v1/environments/env-abc123/statements?page_token=UvmDWOB1iwfAIBPj6EYb
                                    created_at:
                                      type: string
                                      format: date-time
                                      example: '2006-01-02T15:04:05-07:00'
                                      readOnly: true
                                      description: The date and time at which this object was created.
                                        It is represented in RFC3339 format and is in UTC.
                                  title: ResultListMeta
                              results:
                                readOnly: true
                                allOf:
                                - type: object
                                  description: A results property that contains a data property that contains
                                    an array of results.
                                  properties:
                                    data:
                                      type: array
                                      description: "A data property that contains an array of results.\
                                        \ Each entry in the array is a separate result.\n\nThe value of\
                                        \ `op` attribute (if present) represents the kind of change that\
                                        \ a row can describe in a changelog:\n\n`0`: represents `INSERT`\
                                        \ (`+I`), i.e. insertion operation;\n\n`1`: represents `UPDATE_BEFORE`\
                                        \ (`-U`), i.e. update operation with the previous content of the\
                                        \ updated row.\nThis kind should occur together with `UPDATE_AFTER`\
                                        \ for modelling an update that needs to retract\nthe previous\
                                        \ row first. It is useful in cases of a non-idempotent update,\
                                        \ i.e., an update of a row that is not\nuniquely identifiable\
                                        \ by a key;\n\n`2`: represents `UPDATE_AFTER` (`+U`), i.e. update\
                                        \ operation with new content of the updated row;\nThis kind CAN\
                                        \ occur together with `UPDATE_BEFORE` for modelling an update\
                                        \ that\nneeds to retract the previous row first or it describes\
                                        \ an idempotent update, i.e., an\nupdate of a row that is uniquely\
                                        \ identifiable by a key;\n\n`3`: represents `DELETE` (`-D`), i.e.\
                                        \ deletion operation;\n\nDefaults to `0`.\n\n### Value encoding\
                                        \ by column type\n\nThe schema gives each column's type, so the\
                                        \ row carries only values. Scalars are JSON strings in\nSQL notation.\
                                        \ A SQL `NULL` is a bare `null`.\n\n| Schema `type`          \
                                        \                    | Payload example                  |\n|--------------------------------------------|----------------------------------|\n\
                                        | `CHAR`, `VARCHAR`                          | `\"A string\"`\
                                        \                     |\n| `BOOLEAN`                         \
                                        \         | `\"TRUE\"`                         |\n| `BINARY`,\
                                        \ `VARBINARY`                      | `\"x'7f0203'\"`         \
                                        \           |\n| `TINYINT`, `SMALLINT`, `INTEGER`, `BIGINT` |\
                                        \ `\"42\"`                           |\n| `FLOAT`, `DOUBLE`  \
                                        \                        | `\"1.1111112E7\"`                 \
                                        \ |\n| `DECIMAL`                                  | `\"12.123\"\
                                        `                       |\n| `DATE`                          \
                                        \           | `\"2023-04-06\"`                   |\n| `TIME_WITHOUT_TIME_ZONE`\
                                        \                   | `\"10:56:22.541\"`                 |\n|\
                                        \ `TIMESTAMP_WITHOUT_TIME_ZONE`              | `\"2023-04-06 10:59:32.628\"\
                                        `      |\n| `TIMESTAMP_WITH_LOCAL_TIME_ZONE`           | `\"2023-04-06\
                                        \ 11:06:47.224\"`      |\n| `INTERVAL_YEAR_MONTH`            \
                                        \          | `\"+2000-02\"`                     |\n| `INTERVAL_DAY_TIME`\
                                        \                        | `\"+2 07:33:20.000\"`             \
                                        \ |\n| `ARRAY`                                    | `[\"1\", \"\
                                        2\", \"3\", null]`          |\n| `MULTISET`                  \
                                        \               | `[[\"a\", \"2\"], [\"b\", \"1\"]]`       |\n\
                                        | `MAP`                                      | `[[\"Bob\", \"\
                                        a\"], [\"Alice\", \"b\"]]` |\n| `ROW`, `STRUCTURED_TYPE`     \
                                        \              | `[\"12\", \"a\"]`                    |\n| `VARIANT`\
                                        \                                  | `[11, \"sensor-7\"]`    \
                                        \           |\n\nTimestamps use a space separator, not `T`. `TIMESTAMP_WITH_LOCAL_TIME_ZONE`\
                                        \ is rendered in the\nsession time zone and carries no offset.\n\
                                        \n`ROW` is positional, since its field names are in the schema.\
                                        \ `ARRAY` is a plain list. `MAP` is a\nlist of `[key, value]`\
                                        \ pairs and `MULTISET` a list of `[element, count]` pairs, so\
                                        \ keys travel as\ndata and may be `null`.\n\n```\nschema:  {\"\
                                        type\": \"ROW\", \"fields\": [\n           {\"name\": \"id\",\
                                        \    \"field_type\": {\"type\": \"INTEGER\"}},\n           {\"\
                                        name\": \"tags\",  \"field_type\": {\"type\": \"ARRAY\",\n   \
                                        \                            \"element_type\": {\"type\": \"VARCHAR\"\
                                        }}},\n           {\"name\": \"props\", \"field_type\": {\"type\"\
                                        : \"MAP\",\n                               \"key_type\":   {\"\
                                        type\": \"VARCHAR\"},\n                               \"value_type\"\
                                        : {\"type\": \"INTEGER\"}}}]}\n\npayload: [\"12\", [\"hot\", \"\
                                        cold\"], [[\"a\", \"1\"], [\"b\", \"2\"]]]\n```\n\n### VARIANT\
                                        \ values\n\nA `VARIANT` schema node carries no element types,\
                                        \ so the types live in the value and differ per\nrow. Each node\
                                        \ is a positional array starting with an integer type code, and\
                                        \ the code's **sign**\ngives the node's shape:\n\n| Code  | Node\
                                        \ shape                      | Meaning                       \
                                        \      |\n|-------|---------------------------------|-------------------------------------|\n\
                                        | `> 0` | `[code, value]`                 | a value          \
                                        \                   |\n| `0`   | `[0]`                       \
                                        \    | NULL, carries nothing               |\n| `< 0` | `[code,\
                                        \ metadataHex, valueHex]` | not decodable, raw bytes attached\
                                        \   |\n\n`TIMESTAMP_LTZ` and `TIMESTAMP_LTZ_NS` are the one exception\
                                        \ to the `> 0` shape, see below.\n\n| Code | Type     | Code |\
                                        \ Type          | Code | Type             |\n|------|----------|------|---------------|------|------------------|\n\
                                        | `-2` | INVALID  | `6`  | INT           | `14` | TIMESTAMP_LTZ\
                                        \    |\n| `-1` | UNKNOWN  | `7`  | BIGINT        | `15` | BYTES\
                                        \            |\n| `0`  | NULL     | `8`  | FLOAT         | `16`\
                                        \ | TIME             |\n| `1`  | OBJECT   | `9`  | DOUBLE    \
                                        \    | `17` | TIMESTAMP_NS     |\n| `2`  | ARRAY    | `10` | DECIMAL\
                                        \       | `18` | TIMESTAMP_LTZ_NS |\n| `3`  | BOOLEAN  | `11`\
                                        \ | STRING        | `19` | UUID             |\n| `4`  | TINYINT\
                                        \  | `12` | DATE          |      |                  |\n| `5` \
                                        \ | SMALLINT | `13` | TIMESTAMP     |      |                 \
                                        \ |\n\nCodes are stable: a new type gets the next free code, and\
                                        \ existing codes are never renumbered.\nClients switch on the\
                                        \ code, never on the node's length.\n\nScalars use the same encoding\
                                        \ as the column type of the same name above. `TIME` has millisecond\n\
                                        precision (`\"09:14:02.117\"`). `TIMESTAMP` has six fractional\
                                        \ digits, `TIMESTAMP_NS` nine. `UUID` is\nthe canonical 8-4-4-4-12\
                                        \ string. `OBJECT` is an array of `[key, node]` pairs and `ARRAY`\
                                        \ an\narray of nodes.\n\n`TIMESTAMP_LTZ` (six fractional digits)\
                                        \ and `TIMESTAMP_LTZ_NS` (nine) are a three-element node\n`[code,\
                                        \ utcTimestamp, offset]`: the instant rendered in UTC, plus the\
                                        \ session time zone's offset\nat that instant as `+HH:MM` or `-HH:MM`,\
                                        \ never `Z`. The offset follows daylight saving, so local time\
                                        \ is\n`utcTimestamp` shifted by `offset`. This differs from a\
                                        \ `TIMESTAMP_WITH_LOCAL_TIME_ZONE` column,\nwhich is rendered\
                                        \ in the session time zone without an offset.\n\n```\n[1, [\n\
                                        \  [\"device\",  [11, \"sensor-7\"]],\n  [\"logged\",  [14, \"\
                                        2026-07-28 09:14:02.117000\", \"+02:00\"]],\n  [\"meta\",    [1,\
                                        \ [[\"n\", [4, \"7\"]], [\"ok\", [3, \"TRUE\"]]]]],\n  [\"price\"\
                                        ,   [10, \"100.00\"]],\n  [\"seen_at\", [13, \"2026-07-28 09:14:02.117000\"\
                                        ]],\n  [\"tags\",    [2, [[11, \"hot\"], [0]]]],\n  [\"weird\"\
                                        ,   [-1, \"x'0102'\", \"x'7f2a'\"]]\n]]\n```\n"
                                      items: {}
                                      example:
                                      - op: 0
                                        row:
                                        - '101'
                                        - Jay
                                        - - null
                                          - abc
                                        - - null
                                          - '456'
                                        - 1990-01-12 12:00.12
                                        - - - null
                                            - Alice
                                          - - '42'
                                            - Bob
                                  title: sql.v1.StatementResultResults
                            readOnly: true
                            title: sql.v1.StatementResult
                        title: sql.v1.Statement
                      - type: object
                        required:
                        - api_version
                        - kind
                        - metadata
                        - spec
                        - status
                        - name
                        - organization_id
                        - environment_id
                        properties:
                          spec:
                            type: object
                            required:
                            - statement
                    uniqueItems: true
                title: sql.v1.StatementList
          headers:
            X-Request-Id:
              schema:
                type: string
              description: The unique identifier for the API request.
        '400':
          description: Bad Request
          headers:
            X-Request-Id:
              schema:
                type: string
              description: The unique identifier for the API request.
          content:
            application/json:
              schema:
                type: object
                description: Provides information about problems encountered while performing an operation.
                required:
                - errors
                properties:
                  errors:
                    description: List of errors which caused this operation to fail
                    type: array
                    items:
                      type: object
                      description: Describes a particular error encountered while performing an operation.
                      properties:
                        id:
                          description: A unique identifier for this particular occurrence of the problem.
                          type: string
                          maxLength: 255
                        status:
                          description: The HTTP status code applicable to this problem, expressed as a
                            string value.
                          type: string
                        code:
                          description: An application-specific error code, expressed as a string value.
                          type: string
                        title:
                          description: A short, human-readable summary of the problem. It **SHOULD NOT**
                            change from occurrence to occurrence of the problem, except for purposes of
                            localization.
                          type: string
                        detail:
                          description: A human-readable explanation specific to this occurrence of the
                            problem.
                          type: string
                        source:
                          type: object
                          description: If this error was caused by a particular part of the API request,
                            the source will point to the query string parameter or request body property
                            that caused it.
                          properties:
                            pointer:
                              description: A JSON Pointer [RFC6901] to the associated entity in the request
                                document [e.g. "/spec" for a spec object, or "/spec/title" for a specific
                                field].
                              type: string
                            parameter:
                              description: A string indicating which query parameter caused the error.
                              type: string
                        error_code:
                          type: integer
                          format: int32
                        message:
                          type: string
                          nullable: true
                      additionalProperties: false
                      title: Error
                    uniqueItems: true
                title: Failure
              example:
                errors:
                - id: ed42afdc-f0d5-4c0d-b428-9fc6ed6e279d
                  status: '400'
                  code: invalid_filter
                  title: Invalid Filter
                  detail: The 'delorean' resource can't be filtered by 'num_doors'
                  source:
                    parameter: num_doors
        '401':
          x-summary: Unauthorized
          description: The request lacks valid authentication credentials for this resource.
          headers:
            X-Request-Id:
              schema:
                type: string
              description: The unique identifier for the API request.
            WWW-Authenticate:
              schema:
                type: string
              description: The unique identifier for the API request.
              example: Basic error="invalid_key", error_description="The API Key is invalid"
          content:
            application/json:
              schema:
                type: object
                description: Provides information about problems encountered while performing an operation.
                required:
                - errors
                properties:
                  errors:
                    description: List of errors which caused this operation to fail
                    type: array
                    items:
                      type: object
                      description: Describes a particular error encountered while performing an operation.
                      properties:
                        id:
                          description: A unique identifier for this particular occurrence of the problem.
                          type: string
                          maxLength: 255
                        status:
                          description: The HTTP status code applicable to this problem, expressed as a
                            string value.
                          type: string
                        code:
                          description: An application-specific error code, expressed as a string value.
                          type: string
                        title:
                          description: A short, human-readable summary of the problem. It **SHOULD NOT**
                            change from occurrence to occurrence of the problem, except for purposes of
                            localization.
                          type: string
                        detail:
                          description: A human-readable explanation specific to this occurrence of the
                            problem.
                          type: string
                        source:
                          type: object
                          description: If this error was caused by a particular part of the API request,
                            the source will point to the query string parameter or request body property
                            that caused it.
                          properties:
                            pointer:
                              description: A JSON Pointer [RFC6901] to the associated entity in the request
                                document [e.g. "/spec" for a spec object, or "/spec/title" for a specific
                                field].
                              type: string
                            parameter:
                              description: A string indicating which query parameter caused the error.
                              type: string
                        error_code:
                          type: integer
                          format: int32
                        message:
                          type: string
                          nullable: true
                      additionalProperties: false
                      title: Error
                    uniqueItems: true
                title: Failure
              example:
                errors:
                - id: ed42afdc-f0d5-4c0d-b428-9fc6ed6e279d
                  status: '401'
                  code: user_unauthenticated
                  title: Authentication Required
                  detail: Valid authentication credentials must be provided
        '403':
          x-summary: Forbidden
          description: The access credentials were considered insufficient to grant access
          headers:
            X-Request-Id:
              schema:
                type: string
              description: The unique identifier for the API request.
          content:
            application/json:
              schema:
                type: object
                description: Provides information about problems encountered while performing an operation.
                required:
                - errors
                properties:
                  errors:
                    description: List of errors which caused this operation to fail
                    type: array
                    items:
                      type: object
                      description: Describes a particular error encountered while performing an operation.
                      properties:
                        id:
                          description: A unique identifier for this particular occurrence of the problem.
                          type: string
                          maxLength: 255
                        status:
                          description: The HTTP status code applicable to this problem, expressed as a
                            string value.
                          type: string
                        code:
                          description: An application-specific error code, expressed as a string value.
                          type: string
                        title:
                          description: A short, human-readable summary of the problem. It **SHOULD NOT**
                            change from occurrence to occurrence of the problem, except for purposes of
                            localization.
                          type: string
                        detail:
                          description: A human-readable explanation specific to this occurrence of the
                            problem.
                          type: string
                        source:
                          type: object
                          description: If this error was caused by a particular part of the API request,
                            the source will point to the query string parameter or request body property
                            that caused it.
                          properties:
                            pointer:
                              description: A JSON Pointer [RFC6901] to the associated entity in the request
                                document [e.g. "/spec" for a spec object, or "/spec/title" for a specific
                                field].
                              type: string
                            parameter:
                              description: A string indicating which query parameter caused the error.
                              type: string
                        error_code:
                          type: integer
                          format: int32
                        message:
                          type: string
                          nullable: true
                      additionalProperties: false
                      title: Error
                    uniqueItems: true
                title: Failure
              example:
                errors:
                - id: ed42afdc-f0d5-4c0d-b428-9fc6ed6e279d
                  status: '403'
                  code: user_unauthorized
                  title: User Access Unauthorized
                  detail: The user 'mcfly' is not allowed to access the 'delorean' resource without the
                    'plutonium' role.
        '404':
          description: Not Found
          headers:
            X-Request-Id:
              schema:
                type: string
              description: The unique identifier for the API request.
          content:
            application/json:
              schema:
                type: object
                description: Provides information about problems encountered while performing an operation.
                required:
                - errors
                properties:
                  errors:
                    description: List of errors which caused this operation to fail
                    type: array
                    items:
                      type: object
                      description: Describes a particular error encountered while performing an operation.
                      properties:
                        id:
                          description: A unique identifier for this particular occurrence of the problem.
                          type: string
                          maxLength: 255
                        status:
                          description: The HTTP status code applicable to this problem, expressed as a
                            string value.
                          type: string
                        code:
                          description: An application-specific error code, expressed as a string value.
                          type: string
                        title:
                          description: A short, human-readable summary of the problem. It **SHOULD NOT**
                            change from occurrence to occurrence of the problem, except for purposes of
                            localization.
                          type: string
                        detail:
                          description: A human-readable explanation specific to this occurrence of the
                            problem.
                          type: string
                        source:
                          type: object
                          description: If this error was caused by a particular part of the API request,
                            the source will point to the query string parameter or request body property
                            that caused it.
                          properties:
                            pointer:
                              description: A JSON Pointer [RFC6901] to the associated entity in the request
                                document [e.g. "/spec" for a spec object, or "/spec/title" for a specific
                                field].
                              type: string
                            parameter:
                              description: A string indicating which query parameter caused the error.
                              type: string
                        error_code:
                          type: integer
                          format: int32
                        message:
                          type: string
                          nullable: true
                      additionalProperties: false
                      title: Error
                    uniqueItems: true
                title: Failure
              example:
                errors:
                - id: ed42afdc-f0d5-4c0d-b428-9fc6ed6e279d
                  status: '404'
                  title: Not Found
        '429':
          description: Rate Limit Exceeded
          headers:
            X-Request-Id:
              schema:
                type: string
              description: The unique identifier for the API request.
            X-RateLimit-Limit:
              schema:
                type: integer
              description: The maximum number of requests you're permitted to make per time period.
            X-RateLimit-Remaining:
              schema:
                type: integer
              description: The number of requests remaining in the current rate limit window.
            X-RateLimit-Reset:
              schema:
                type: integer
              description: "The relative time in seconds until the current rate-limit window resets. \
                \ \n  \n**Important:** This differs from Github and Twitter's same-named header which\
                \ uses UTC epoch seconds. We use relative time to avoid client/server time synchronization\
                \ issues."
            Retry-After:
              schema:
                type: integer
              description: The number of seconds to wait until the rate limit window resets. Only sent
                when the rate limit is reached.
        '500':
          description: Oops, something went wrong!
          headers:
            X-Request-Id:
              schema:
                type: string
              description: The unique identifier for the API request.
          content:
            application/json:
              schema:
                type: object
                description: Provides information about problems encountered while performing an operation.
                required:
                - errors
                properties:
                  errors:
                    description: List of errors which caused this operation to fail
                    type: array
                    items:
                      type: object
                      description: Describes a particular error encountered while performing an operation.
                      properties:
                        id:
                          description: A unique identifier for this particular occurrence of the problem.
                          type: string
                          maxLength: 255
                        status:
                          description: The HTTP status code applicable to this problem, expressed as a
                            string value.
                          type: string
                        code:
                          description: An application-specific error code, expressed as a string value.
                          type: string
                        title:
                          description: A short, human-readable summary of the problem. It **SHOULD NOT**
                            change from occurrence to occurrence of the problem, except for purposes of
                            localization.
                          type: string
                        detail:
                          description: A human-readable explanation specific to this occurrence of the
                            problem.
                          type: string
                        source:
                          type: object
                          description: If this error was caused by a particular part of the API request,
                            the source will point to the query string parameter or request body property
                            that caused it.
                          properties:
                            pointer:
                              description: A JSON Pointer [RFC6901] to the associated entity in the request
                                document [e.g. "/spec" for a spec object, or "/spec/title" for a specific
                                field].
                              type: string
                            parameter:
                              description: A string indicating which query parameter caused the error.
                              type: string
                        error_code:
                          type: integer
                          format: int32
                        message:
                          type: string
                          nullable: true
                      additionalProperties: false
                      title: Error
                    uniqueItems: true
                title: Failure
              example:
                errors:
                - id: ed42afdc-f0d5-4c0d-b428-9fc6ed6e279d
                  status: '500'
                  code: out_of_gas
                  title: DeLorean Out Of Gas
                  detail: The DeLorean has run out of gas, but Doc Brown will fill 'er up for you asap
      servers:
      - url: https://flink.region.provider.confluent.cloud
        description: Flink Compute Pool Endpoint