Get saved query

GET

data

lake

queries

{query_id}

curl -X GET 'https://api.cloud.blnkfinance.com/data/lake/queries/lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94' \
  -H 'Authorization: Bearer CLOUD_API_KEY'

{
  "data": {
    "id": "lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94",
    "instance_id": "instance_073f7ffe-9dfd-42ce-aa50-d1dca1788adc",
    "owner_user_id": "user_01K4EX0BRXHNNGCRVT2TPNK07W",
    "name": "Applied volume by currency",
    "description": "APPLIED transaction counts by currency",
    "sql": "SELECT currency, COUNT(*) AS txn_count FROM transactions GROUP BY currency LIMIT 1000",
    "range_mode": "fixed",
    "start_date": "2026-08-01T00:00:00Z",
    "end_date": "2026-08-31T00:00:00Z",
    "rolling_days": 0,
    "schedule": {
      "id": "lake_query_schedule_6e6feddd-930b-4e38-8ba1-1a3eee659bb3",
      "query_id": "lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94",
      "cron_expression": "0 9 * * *",
      "timezone": "America/New_York",
      "enabled": true,
      "next_run_at": "2026-08-16T13:00:00Z"
    },
    "created_at": "2026-08-12T09:28:16.864765Z",
    "updated_at": "2026-08-12T09:28:16.864765Z"
  }
}

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

A saved query is lake SQL you store on an instance so you can rerun it later. It is not a query run. This endpoint returns one saved query by query_id, including the SQL, how Cloud picks the date range, and the schedule when one is set.

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/queries/lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94' \
  -H 'Authorization: Bearer CLOUD_API_KEY'

string

required

Unique id of the saved query (lake_query_...). Get it from List saved queries or Create saved query.

Response

{
  "data": {
    "id": "lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94",
    "instance_id": "instance_073f7ffe-9dfd-42ce-aa50-d1dca1788adc",
    "owner_user_id": "user_01K4EX0BRXHNNGCRVT2TPNK07W",
    "name": "Applied volume by currency",
    "description": "APPLIED transaction counts by currency",
    "sql": "SELECT currency, COUNT(*) AS txn_count FROM transactions GROUP BY currency LIMIT 1000",
    "range_mode": "fixed",
    "start_date": "2026-08-01T00:00:00Z",
    "end_date": "2026-08-31T00:00:00Z",
    "rolling_days": 0,
    "schedule": {
      "id": "lake_query_schedule_6e6feddd-930b-4e38-8ba1-1a3eee659bb3",
      "query_id": "lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94",
      "cron_expression": "0 9 * * *",
      "timezone": "America/New_York",
      "enabled": true,
      "next_run_at": "2026-08-16T13:00:00Z"
    },
    "created_at": "2026-08-12T09:28:16.864765Z",
    "updated_at": "2026-08-12T09:28:16.864765Z"
  }
}

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

string

Unique id of this saved query (lake_query_...). Pass it as saved_query_id on Create new query.

string

Unique id of the instance (instance_...) this query is bound to.

string

User who created the query. Anyone in the workspace can run it. Only this owner or an admin can update, delete, or schedule it.

string

Label shown in Insights and copied onto query runs that come from this query.

string

Optional note about what the query returns. Empty string when none was set.

string

Read-only DuckDB SELECT or WITH Cloud runs each time you execute this query.

string

How Cloud picks the lake date range when the query runs. fixed uses the stored start_date and end_date. rolling uses the last rolling_days days, resolved at run time.

timestamp

First day of lake history for a fixed query. Omitted when range_mode is rolling.

timestamp

Last day of lake history for a fixed query. Omitted when range_mode is rolling.

integer

Number of days of lake history to open when range_mode is rolling (1 to 3650). 0 when the query is fixed.

object

Cron schedule Cloud uses to run this query automatically. Present only after you set a schedule.

Show Schedule properties

string

Unique id of the schedule (lake_query_schedule_...).

string

Saved query this schedule belongs to (lake_query_...).

string

Five-field cron that says when Cloud starts a query run. Example: 0 9 * * * is every day at 09:00 in timezone.

string

IANA timezone Cloud uses to interpret the cron, such as America/New_York. next_run_at is still returned in UTC.

boolean

Whether Cloud will fire the schedule. false keeps the schedule stored but skips runs.

timestamp

Next time Cloud will start a query run for this schedule, in UTC.

timestamp

When Cloud last started a query run from this schedule. Omitted until the first fire.

timestamp

When the saved query was first created.

timestamp

When the saved SQL, name, description, or date range was last changed.

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/queries/lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94' \
  -H 'Authorization: Bearer CLOUD_API_KEY'

{
  "data": {
    "id": "lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94",
    "instance_id": "instance_073f7ffe-9dfd-42ce-aa50-d1dca1788adc",
    "owner_user_id": "user_01K4EX0BRXHNNGCRVT2TPNK07W",
    "name": "Applied volume by currency",
    "description": "APPLIED transaction counts by currency",
    "sql": "SELECT currency, COUNT(*) AS txn_count FROM transactions GROUP BY currency LIMIT 1000",
    "range_mode": "fixed",
    "start_date": "2026-08-01T00:00:00Z",
    "end_date": "2026-08-31T00:00:00Z",
    "rolling_days": 0,
    "schedule": {
      "id": "lake_query_schedule_6e6feddd-930b-4e38-8ba1-1a3eee659bb3",
      "query_id": "lake_query_f482a1b3-6c2d-4e89-a17b-3d5e8f2a1c94",
      "cron_expression": "0 9 * * *",
      "timezone": "America/New_York",
      "enabled": true,
      "next_run_at": "2026-08-16T13:00:00Z"
    },
    "created_at": "2026-08-12T09:28:16.864765Z",
    "updated_at": "2026-08-12T09:28:16.864765Z"
  }
}

{
  "error": {
    "code": "NOT_FOUND",
    "message": "saved lake query 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?