Get query run

GET

data

lake

query-runs

{run_id}

curl -X GET 'https://api.cloud.blnkfinance.com/data/lake/query-runs/lake_query_run_c5d9e2a1-7b4f-4a3c-9e8d-1f6a2b4c8d30' \
  -H 'Authorization: Bearer CLOUD_API_KEY'

{
  "data": {
    "id": "lake_query_run_c5d9e2a1-7b4f-4a3c-9e8d-1f6a2b4c8d30",
    "instance_id": "instance_073f7ffe-9dfd-42ce-aa50-d1dca1788adc",
    "saved_query_id": "lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94",
    "trigger": "manual",
    "query_name": "Applied volume by currency",
    "sql": "SELECT currency, COUNT(*) AS txn_count FROM transactions GROUP BY currency LIMIT 1000",
    "start_date": "2026-08-01T00:00:00Z",
    "end_date": "2026-08-31T00:00:00Z",
    "status": "succeeded",
    "row_count": 1,
    "preview_limited": false,
    "duration_ms": 842,
    "started_at": "2026-08-15T11:04:12.112739Z",
    "finished_at": "2026-08-15T11:04:12.954739Z",
    "created_at": "2026-08-15T11:04:12.112739Z",
    "updated_at": "2026-08-15T11:04:12.954739Z",
    "rows": [
      {
        "currency": "USD",
        "txn_count": 1280
      }
    ]
  }
}

{
  "error": {
    "code": "NOT_FOUND",
    "message": "lake query run not found"
  }
}

A query run is one execution of lake SQL. Cloud creates a run when you create a new query with sql or saved_query_id, or when a scheduled saved query fires. This endpoint returns one run by run_id. You get the SQL and date range that actually ran, the status of that execution, and a preview of the result rows (at most 1000 rows, or less if the preview exceeds 2 MB). The SQL and dates are a snapshot from the time of the run.

Authorization

Blnk Cloud APIs support any one of the following authentication methods. All of them work with your CLOUD_API_KEY or OAUTH_ACCESS_TOKEN.

Bearer token
X-Blnk-Key header
X-API-Key header

Pass Authorization: Bearer CLOUD_API_KEY or Authorization: Bearer OAUTH_ACCESS_TOKEN.

string

required

Cloud API key or OAuth access token. Create credentials in API keys or OAuth.

Pass X-Blnk-Key: CLOUD_API_KEY or X-Blnk-Key: OAUTH_ACCESS_TOKEN.

string

required

Cloud API key or OAuth access token. Create credentials in API keys or OAuth.

Pass X-API-Key: CLOUD_API_KEY or X-API-Key: OAUTH_ACCESS_TOKEN.

string

required

Cloud API key or OAuth access token. Create credentials in API keys or OAuth.

Path

curl -X GET 'https://api.cloud.blnkfinance.com/data/lake/query-runs/lake_query_run_c5d9e2a1-7b4f-4a3c-9e8d-1f6a2b4c8d30' \
  -H 'Authorization: Bearer CLOUD_API_KEY'

string

required

Unique id of the query run (lake_query_run_...). Get it from Create new query (run_id) or List query runs.

Response

{
  "data": {
    "id": "lake_query_run_c5d9e2a1-7b4f-4a3c-9e8d-1f6a2b4c8d30",
    "instance_id": "instance_073f7ffe-9dfd-42ce-aa50-d1dca1788adc",
    "saved_query_id": "lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94",
    "trigger": "manual",
    "query_name": "Applied volume by currency",
    "sql": "SELECT currency, COUNT(*) AS txn_count FROM transactions GROUP BY currency LIMIT 1000",
    "start_date": "2026-08-01T00:00:00Z",
    "end_date": "2026-08-31T00:00:00Z",
    "status": "succeeded",
    "row_count": 1,
    "preview_limited": false,
    "duration_ms": 842,
    "started_at": "2026-08-15T11:04:12.112739Z",
    "finished_at": "2026-08-15T11:04:12.954739Z",
    "created_at": "2026-08-15T11:04:12.112739Z",
    "updated_at": "2026-08-15T11:04:12.954739Z",
    "rows": [
      {
        "currency": "USD",
        "txn_count": 1280
      }
    ]
  }
}

{
  "error": {
    "code": "NOT_FOUND",
    "message": "lake query run not found"
  }
}

string

Unique id of this run (lake_query_run_...).

string

Unique id of the instance (instance_...).

string

Saved query this run came from (lake_query_...). Omitted when you ran ad-hoc SQL without a saved query.

string

How the run started: manual (Create new query) or scheduled (a saved-query schedule).

string

Display name of the saved query at the time of the run. Empty for ad-hoc SQL.

string

Exact SQL Cloud executed. This is a snapshot. Later edits to a saved query do not change it.

timestamp

First day of lake history this run opened. For a rolling saved query, this is the start Cloud resolved at run time.

timestamp

Last day of lake history this run opened. For a rolling saved query, this is the end Cloud resolved at run time.

string

running while Cloud is still executing, succeeded when it finished, or failed when the SQL did not complete.

integer

Number of rows the query produced. Can be larger than rows when the preview is truncated.

boolean

true when rows is a truncated preview (more than 1000 rows, or the preview exceeded 2 MB). Use row_count for the full total.

integer

How long the query took to execute, in milliseconds.

string

Machine-readable failure code, such as INVALID_SQL or QUERY_TOO_EXPENSIVE. Present only when status is failed.

string

Human-readable reason the run failed. Present only when status is failed.

array

Preview of result rows. Column names match the SQL aliases. At most 1000 rows. Not the full result when preview_limited is true.

timestamp

When Cloud started executing this run.

timestamp

When the run reached succeeded or failed. Omitted while status is running.

timestamp

When Cloud first recorded this run (usually the same moment as started_at).

timestamp

When Cloud last wrote to this run, such as when it moved from running to succeeded or failed.

Need help?

We are very happy to help you make the most of Blnk, regardless of whether it is your first time or you are switching from another tool. To ask questions or discuss issues, please contact us or join our Discord community.

curl -X GET 'https://api.cloud.blnkfinance.com/data/lake/query-runs/lake_query_run_c5d9e2a1-7b4f-4a3c-9e8d-1f6a2b4c8d30' \
  -H 'Authorization: Bearer CLOUD_API_KEY'

{
  "data": {
    "id": "lake_query_run_c5d9e2a1-7b4f-4a3c-9e8d-1f6a2b4c8d30",
    "instance_id": "instance_073f7ffe-9dfd-42ce-aa50-d1dca1788adc",
    "saved_query_id": "lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94",
    "trigger": "manual",
    "query_name": "Applied volume by currency",
    "sql": "SELECT currency, COUNT(*) AS txn_count FROM transactions GROUP BY currency LIMIT 1000",
    "start_date": "2026-08-01T00:00:00Z",
    "end_date": "2026-08-31T00:00:00Z",
    "status": "succeeded",
    "row_count": 1,
    "preview_limited": false,
    "duration_ms": 842,
    "started_at": "2026-08-15T11:04:12.112739Z",
    "finished_at": "2026-08-15T11:04:12.954739Z",
    "created_at": "2026-08-15T11:04:12.112739Z",
    "updated_at": "2026-08-15T11:04:12.954739Z",
    "rows": [
      {
        "currency": "USD",
        "txn_count": 1280
      }
    ]
  }
}

{
  "error": {
    "code": "NOT_FOUND",
    "message": "lake query run not found"
  }
}

Start Here

Deployments

Proxy & data

Data lake

AI integrations

Audit

Alerts

Billing

Authorization

Path

Response

Need help?

​Authorization

​Path

​Response

​Need help?

Authorization

Path

Response

Need help?