Default Warehouse Override

View as Markdown

Represents a per-user default warehouse override configuration. This resource allows users or administrators to customize how a user's default warehouse is selected for SQL operations. If no override exists for a user, the workspace default warehouse will be used.

GetGET /api/warehouses/v1/{name=default-warehouse-overrides/*}ListGET /api/warehouses/v1/default-warehouse-overridesCreatePOST /api/warehouses/v1/default-warehouse-overridesUpdatePATCH /api/warehouses/v1/{default_warehouse_override.name=default-warehouse-overrides/*}DeleteDELETE /api/warehouses/v1/{name=default-warehouse-overrides/*}

DefaultWarehouseOverride object

Represents a per-user default warehouse override configuration. This resource allows users or administrators to customize how a user's default warehouse is selected for SQL operations. If no override exists for a user, the workspace default warehouse will be used.

namestringBeta

The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}

default_warehouse_override_idstringBeta

The ID component of the resource name (user ID).

typestringBeta

The type of override behavior.

Values: DEFAULT_WAREHOUSE_OVERRIDE_TYPE_UNSPECIFIED, LAST_SELECTED, CUSTOM

warehouse_idstringBeta

The specific warehouse ID when type is CUSTOM. Not set for LAST_SELECTED type.

View as Markdown

The DefaultWarehouseOverride object

{
  "name": "string",
  "default_warehouse_override_id": "string",
  "type": "string",
  "warehouse_id": "string"
}

Get Beta

GET /api/warehouses/v1/{name=default-warehouse-overrides/*}

Returns the default warehouse override for a user. Users can fetch their own override. Admins can fetch overrides for any user. If no override exists, the UI will fallback to the workspace default warehouse.

API scopes: sql

Parameters

namestringpath

Required. The resource name of the default warehouse override to retrieve. Format: default-warehouse-overrides/{default_warehouse_override_id} The default_warehouse_override_id can be a numeric user ID or the literal string "me" for the current user.

Response

Returns the DefaultWarehouseOverride object.

View as Markdown

Response

{
  "name": "string",
  "default_warehouse_override_id": "string",
  "type": "string",
  "warehouse_id": "string"
}

List Beta

GET /api/warehouses/v1/default-warehouse-overrides

Lists all default warehouse overrides in the workspace. Only workspace administrators can list all overrides.

API scopes: sql

Parameters

page_sizeint32query

The maximum number of overrides to return. The service may return fewer than this value. If unspecified, at most 100 overrides will be returned. The maximum value is 1000; values above 1000 will be coerced to 1000.

page_tokenstringquery

A page token, received from a previous ListDefaultWarehouseOverrides call. Provide this to retrieve the subsequent page.

When paginating, all other parameters provided to ListDefaultWarehouseOverrides must match the call that provided the page token.

Response

Returns a list of DefaultWarehouseOverride objects.

View as Markdown

Response

{
  "default_warehouse_overrides": [
    {
      "name": "string",
      "default_warehouse_override_id": "string",
      "type": "string",
      "warehouse_id": "string"
    }
  ],
  "next_page_token": "string"
}

Create Beta

POST /api/warehouses/v1/default-warehouse-overrides

Creates a new default warehouse override for a user. Users can create their own override. Admins can create overrides for any user.

API scopes: sql

Parameters

default_warehouse_override_idstringquery

Required. The ID to use for the override, which will become the final component of the override's resource name. Can be a numeric user ID or the literal string "me" for the current user.

Request body

default_warehouse_overrideobject

Required. The default warehouse override to create.

Show child attributesHide child attributes

namestring

The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}

default_warehouse_override_idstring

The ID component of the resource name (user ID).

typestring

The type of override behavior.

Values: DEFAULT_WAREHOUSE_OVERRIDE_TYPE_UNSPECIFIED, LAST_SELECTED, CUSTOM

warehouse_idstring

The specific warehouse ID when type is CUSTOM. Not set for LAST_SELECTED type.

Response

Returns the DefaultWarehouseOverride object.

View as Markdown

Request

{
  "default_warehouse_override": {
    "name": "string",
    "default_warehouse_override_id": "string",
    "type": "string",
    "warehouse_id": "string"
  }
}

Response

{
  "name": "string",
  "default_warehouse_override_id": "string",
  "type": "string",
  "warehouse_id": "string"
}

Update Beta

PATCH /api/warehouses/v1/{default_warehouse_override.name=default-warehouse-overrides/*}

Updates an existing default warehouse override for a user. Users can update their own override. Admins can update overrides for any user.

API scopes: sql

Parameters

default_warehouse_overrideobjectpath

Required. The default warehouse override to update. The name field must be set in the format: default-warehouse-overrides/{default_warehouse_override_id} The default_warehouse_override_id can be a numeric user ID or the literal string "me" for the current user.

Show child attributesHide child attributes

namestring

The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}

default_warehouse_override_idstring

The ID component of the resource name (user ID).

typestring

The type of override behavior.

Values: DEFAULT_WAREHOUSE_OVERRIDE_TYPE_UNSPECIFIED, LAST_SELECTED, CUSTOM

warehouse_idstring

The specific warehouse ID when type is CUSTOM. Not set for LAST_SELECTED type.

update_maskstringquery

Required. Field mask specifying which fields to update. Only the fields specified in the mask will be updated. Use "*" to update all fields. When allow_missing is true, this field is ignored and all fields are applied.

allow_missingbooleanquery

If set to true, and the override is not found, a new override will be created. In this situation, update_mask is ignored and all fields are applied. Defaults to false.

Response

Returns the DefaultWarehouseOverride object.

View as Markdown

Response

{
  "name": "string",
  "default_warehouse_override_id": "string",
  "type": "string",
  "warehouse_id": "string"
}

Delete Beta

DELETE /api/warehouses/v1/{name=default-warehouse-overrides/*}

Deletes the default warehouse override for a user. Users can delete their own override. Admins can delete overrides for any user. After deletion, the workspace default warehouse will be used.

API scopes: sql

Parameters

namestringpath

Required. The resource name of the default warehouse override to delete. Format: default-warehouse-overrides/{default_warehouse_override_id} The default_warehouse_override_id can be a numeric user ID or the literal string "me" for the current user.

View as Markdown

Response

{}