SQL Query Management

delete

Stops a running query

Path parameters

queryIdstring · uuidRequired

The SQL Snapshot query identifier

Responses

200Success

400

The request input was invalid

application/json

401

Authentication error

application/json

402

The purchased Lenses license does not provide access to this feature

application/json

403

Authorisation error

application/json

404

The requested resource cannot be found

application/json

500

An internal server error has occurred

application/json

delete

HTTPcURLJavaScriptPython

DELETE /api/v1/environments/{name}/proxy/api/v1/sql/execution/{queryId} HTTP/1.1
Host: 
Accept: */*

No content

get

Returns all running queries

Responses

200Success

application/json

400

The request input was invalid

application/json

401

Authentication error

application/json

402

The purchased Lenses license does not provide access to this feature

application/json

403

Authorisation error

application/json

404

The requested resource cannot be found

application/json

500

An internal server error has occurred

application/json

get

HTTPcURLJavaScriptPython

GET /api/v1/environments/{name}/proxy/api/v1/sql/queries HTTP/1.1
Host: 
Accept: */*

[
  {
    "id": "123e4567-e89b-12d3-a456-426614174000",
    "started": "2025-05-05T21:27:35.995Z",
    "finished": "2025-05-05T21:27:35.995Z",
    "sql": "text",
    "username": "text",
    "status": "Completed",
    "message": "text"
  }
]

get

Returns the topic/table paging details. For a Kafka topic this means returning the start/end offset

Query parameters

tablestringRequired

The target table

Responses

200Success

application/json

400

The request input was invalid

application/json

401

Authentication error

application/json

402

The purchased Lenses license does not provide access to this feature

application/json

403

Authorisation error

application/json

404

The requested resource cannot be found

application/json

500

An internal server error has occurred

application/json

get

HTTPcURLJavaScriptPython

GET /api/v1/environments/{name}/proxy/api/v1/sql/paging?table=text HTTP/1.1
Host: 
Accept: */*

[
  {
    "tableName": {
      "value": "text"
    },
    "type": {
      "value": "text"
    },
    "label": "text",
    "partitions": [
      {
        "id": {
          "value": 1
        },
        "label": "text",
        "start": 1,
        "end": 1
      }
    ]
  }
]

post

Returns the intellisense result for a given query

Body

sqlstringRequired

caretintegerOptional

connectorIdstringOptional

Responses

200Success

application/json

400

The request input was invalid

application/json

401

Authentication error

application/json

402

The purchased Lenses license does not provide access to this feature

application/json

403

Authorisation error

application/json

404

The requested resource cannot be found

application/json

500

An internal server error has occurred

application/json

post

HTTPcURLJavaScriptPython

POST /api/v1/environments/{name}/proxy/api/v1/sql/presentation HTTP/1.1
Host: 
Content-Type: application/json
Accept: */*
Content-Length: 45

{
  "sql": "text",
  "caret": 1,
  "connectorId": "text"
}

{
  "input": "text",
  "caret": 1,
  "lints": [
    {
      "start": 1,
      "end": 1,
      "text": "text",
      "type": "Warning"
    }
  ],
  "suggestions": [
    {
      "display": "text",
      "text": "text",
      "start": 1,
      "end": 1,
      "type": "text",
      "description": "text",
      "highlightStart": 1,
      "highlightEnd": 1
    }
  ],
  "highlights": [
    {
      "start": 1,
      "end": 1,
      "text": "text",
      "type": "Keyword"
    }
  ],
  "tables": [
    {
      "tableName": {
        "value": "text"
      },
      "fields": [
        {
          "value": "text"
        }
      ]
    }
  ],
  "statementsPositions": [
    {
      "index": 1,
      "start": 1,
      "end": 1
    }
  ]
}