Data lake

Delete saved query

Delete a saved lake query and its schedule.

DEL/data/lake/queries/{query_id}

Delete a saved lake query. Cloud also deletes its schedule if one exists. You can no longer run it with saved_query_id. Only the query owner or an admin can delete it.

Past query runs stay in history. Each run keeps the SQL snapshot from when it executed.

Enterprise authentication

Send these requests to https://api.cloud.blnkfinance.com on Blnk Cloud. On a self-hosted Enterprise deployment, send them to ENTERPRISE_PUBLIC_URL.

Pass an Enterprise API key, or an OAuth access token, in the X-blnk-key header. Create the key in Enterprise API keys, or issue a token with Enterprise OAuth.

This credential comes from the Cloud or Enterprise workspace. A Core API key belongs to the Core instance.

X-blnk-keystringrequiredheader

Enterprise API key, or an OAuth access token.

Path

query_idstringrequiredpath

Unique id of the saved query to delete (lake_query_...). Get it from Get saved query.

Response

A successful delete returns 204 No Content with an empty body.

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

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

{
  "error": {
    "code": "FORBIDDEN",
    "message": "lake query mutation is not permitted"
  }
}