vw_log_delivery_workspace_filter

Creates, updates, deletes, gets or lists a vw_log_delivery_workspace_filter resource.

Overview

Name	vw_log_delivery_workspace_filter
Type	View
Id	databricks_account.billing.vw_log_delivery_workspace_filter

Fields

The following fields are returned by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.
config_id	string	Unique identifier for the log delivery configuration.
config_name	string	Human-readable name of the log delivery configuration.
log_type	string	Type of logs being delivered (e.g. BILLABLE_USAGE, AUDIT_LOGS).
status	string	Enabled/disabled status of the log delivery configuration.
delivery_status	string	Status of the most recent log delivery attempt.
workspace_id	string	ID of a workspace included in the delivery filter (one row per workspace).

Required Parameters

The following parameters are required by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.

SELECT Examples

SELECT
  account_id,
  config_id,
  config_name,
  log_type,
  status,
  delivery_status,
  workspace_id
FROM databricks_account.billing.vw_log_delivery_workspace_filter
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  ld.account_id,
  ld.config_id,
  ld.config_name,
  ld.log_type,
  ld.status,
  JSON_EXTRACT(ld.log_delivery_status, '$.status') AS delivery_status,
  w.value AS workspace_id
FROM databricks_account.billing.log_delivery ld,
     JSON_EACH(ld.workspace_ids_filter) w
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  ld.account_id,
  ld.config_id,
  ld.config_name,
  ld.log_type,
  ld.status,
  ld.log_delivery_status->>'status' AS delivery_status,
  w.value AS workspace_id
FROM databricks_account.billing.log_delivery ld,
     jsonb_array_elements(ld.workspace_ids_filter::jsonb) AS w
WHERE account_id = '{{ account_id }}'