Update Saved Query

Rename a saved query, change its description, or replace its SQL.

Tool: draxlr_update_saved_query

Updates an existing saved query in place — rename it, change its description, and/or replace its SQL. Provide the saved queryId (from List Saved Queries) and any of name, description, or sql.

Parameters

ParameterTypeRequiredDescription
queryIdstringYesThe saved query id to update
namestringNoNew name for the saved query
descriptionstringNoNew description for the saved query
sqlstringNoNew SQL to replace the query's definition (raw SQL queries only)

At least one field:

Provide at least one of name, description, or sql. Replacing sql runs the new query first, so it must be a valid read-only (SELECT) query, and only raw SQL saved queries can have their SQL replaced.

Example

"Rename saved query 6690aa11… to Completed orders by day and update its SQL."

Arguments:

{
  "queryId": "6690aa11bc2e4a0012cd77ee",
  "name": "Completed orders by day",
  "sql": "SELECT date_trunc('day', created_at) AS day, COUNT(*) AS orders FROM orders WHERE status = 'completed' GROUP BY 1"
}

Response

{
  "message": "Saved query updated.",
  "query": {
    "_id": "6690aa11bc2e4a0012cd77ee",
    "name": "Completed orders by day",
    "description": "Order counts grouped by status"
  },
  "url": "https://app.draxlr.com/explore/665f1c2a9b1e4a0012ab34cd/6690aa11bc2e4a0012cd77ee"
}
FieldDescription
messageConfirmation message
queryThe updated saved query
urlA link to view the query in Draxlr