Skip to contents

Update a SQL Query

Usage

db_query_update(
  id,
  warehouse_id = NULL,
  query_text = NULL,
  display_name = NULL,
  description = NULL,
  catalog = NULL,
  schema = NULL,
  parent_path = NULL,
  run_as_mode = NULL,
  apply_auto_limit = NULL,
  auto_resolve_display_name = NULL,
  tags = NULL,
  host = db_host(),
  token = db_token(),
  perform_request = TRUE
)

Arguments

id

Query id

warehouse_id

description

query_text

Text of the query to be run.

display_name

Display name of the query that appears in list views, widget headings, and on the query page.

description

General description that conveys additional information about this query such as usage notes.

catalog

Name of the catalog where this query will be executed.

schema

Name of the schema where this query will be executed.

parent_path

Workspace path of the workspace folder containing the object.

run_as_mode

Sets the "Run as" role for the object.

apply_auto_limit

Whether to apply a 1000 row limit to the query result.

auto_resolve_display_name

Automatically resolve query display name conflicts. Otherwise, fail the request if the query's display name conflicts with an existing query's display name.

tags

Named list that describes the warehouse. Databricks tags all warehouse resources with these tags.

host

Databricks workspace URL, defaults to calling db_host().

token

Databricks workspace token, defaults to calling db_token().

perform_request

If TRUE (default) the request is performed, if FALSE the httr2 request is returned without being performed.

See also

Other SQL Queries API: db_query_create(), db_query_delete(), db_query_get(), db_query_list()