Poll for cross-tenant query result

GET

/query-all/jobs/{jobId}

• Production
• Development

Polls the status of a cross-tenant query job. Returns the combined results when complete, or the current status if still processing.

Jobs expire after 1 hour (DynamoDB TTL).

Authorizations

• ApiKeyAuth

Parameters

Path Parameters

jobId

required

string format: uuid

Job ID returned by POST /query-all.

Example

503a73be-9119-43ba-8e30-4f278f978d49

Responses

200

Job status or completed results

One of:

object

object

data

required

object

job_id

required

string format: uuid

status

required

string

Allowed values: processing

object

object

data

required

object

columns

required

Column names. First column is always _bucket.

Array<string>

Example

[
  "_bucket",
  "total"
]

rows

required

Result rows from all queried databases combined.

Array<Array>

generated_sql

Present only in NL mode — the SQL generated from the question.

string

meta

required

object

databases_queried

required

Number of databases successfully queried.

integer

Example

177

databases_skipped

required

Databases skipped (missing filtered table).

integer

0

databases_errored

required

Databases where the query failed.

integer

Example

1

total_rows

required

Total rows in the combined result.

integer

Example

177

execution_time_seconds

required

Wall-clock time in seconds.

number

Example

9.6

skipped

Bucket names of skipped databases.

Array<string>

errors

Map of bucket name to error message for failed databases.

object

key

additional properties

string

truncated

True if results were truncated to fit DynamoDB 400KB limit.

boolean

object

object

data

required

object

job_id

required

string format: uuid

status

required

string

Allowed values: failed

error_code

required

Machine-readable error code.

string

Example

generation_failed

error_message

required

Human-readable error description.

string

Example

Could not generate SQL: timeout

Examples

Still running

{
  "data": {
    "job_id": "503a73be-9119-43ba-8e30-4f278f978d49",
    "status": "processing"
  }
}

Completed with results

{
  "data": {
    "columns": [
      "_bucket",
      "total"
    ],
    "rows": [
      [
        "example",
        1523
      ],
      [
        "jec",
        4200
      ]
    ]
  },
  "meta": {
    "databases_queried": 177,
    "databases_skipped": 0,
    "databases_errored": 0,
    "total_rows": 177,
    "execution_time_seconds": 9.6,
    "skipped": [],
    "errors": {}
  }
}

Query failed

{
  "data": {
    "job_id": "503a73be-9119-43ba-8e30-4f278f978d49",
    "status": "failed",
    "error_code": "generation_failed",
    "error_message": "Could not generate SQL: timeout"
  }
}

401

Authentication required

object

error

required

object

code

required

Machine-readable error code.

string

Example

unauthorized

message

required

Human-readable error message.

string

Example

Authentication required

Example

{
  "error": {
    "code": "unauthorized",
    "message": "Authentication required"
  }
}

403

Access denied to bucket

object

error

required

object

code

required

Machine-readable error code.

string

Example

unauthorized

message

required

Human-readable error message.

string

Example

Authentication required

Example

{
  "error": {
    "code": "forbidden",
    "message": "Access denied to bucket 'example'"
  }
}

404

Resource not found

object

error

required

object

code

required

Machine-readable error code.

string

Example

unauthorized

message

required

Human-readable error message.

string

Example

Authentication required

Example

{
  "error": {
    "code": "not_found",
    "message": "Unknown table: foo"
  }
}