vw_log_delivery_configurations

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

Overview

Name	vw_log_delivery_configurations
Type	View
Id	databricks_account.billing.vw_log_delivery_configurations

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).
output_format	string	Format of the delivered log files (e.g. CSV, JSON).
credentials_id	string	ID of the credentials used to write logs to the storage destination.
storage_configuration_id	string	ID of the storage configuration that defines the delivery destination.
delivery_path_prefix	string	Optional path prefix prepended to log file paths in the storage destination.
delivery_start_time	string	Optional earliest date from which logs are delivered (YYYY-MM-DD).
status	string	Enabled/disabled status of the log delivery configuration.
creation_time	integer	Unix timestamp (ms) when the configuration was created.
update_time	integer	Unix timestamp (ms) when the configuration was last updated.
delivery_status	string	Status of the most recent log delivery attempt.
delivery_status_message	string	Human-readable message describing the most recent delivery attempt result.
last_attempt_time	string	Timestamp of the most recent delivery attempt (ISO 8601).
last_successful_attempt_time	string	Timestamp of the most recent successful delivery attempt (ISO 8601).
workspace_ids_filter	array	List of workspace IDs to include in log delivery; empty means all workspaces.

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,
  output_format,
  credentials_id,
  storage_configuration_id,
  delivery_path_prefix,
  delivery_start_time,
  status,
  creation_time,
  update_time,
  delivery_status,
  delivery_status_message,
  last_attempt_time,
  last_successful_attempt_time,
  workspace_ids_filter
FROM databricks_account.billing.vw_log_delivery_configurations
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  ld.account_id,
  ld.config_id,
  ld.config_name,
  ld.log_type,
  ld.output_format,
  ld.credentials_id,
  ld.storage_configuration_id,
  ld.delivery_path_prefix,
  ld.delivery_start_time,
  ld.status,
  ld.creation_time,
  ld.update_time,
  JSON_EXTRACT(ld.log_delivery_status, '$.status') AS delivery_status,
  JSON_EXTRACT(ld.log_delivery_status, '$.message') AS delivery_status_message,
  JSON_EXTRACT(ld.log_delivery_status, '$.last_attempt_time') AS last_attempt_time,
  JSON_EXTRACT(ld.log_delivery_status, '$.last_successful_attempt_time') AS last_successful_attempt_time,
  ld.workspace_ids_filter
FROM databricks_account.billing.log_delivery ld
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  ld.account_id,
  ld.config_id,
  ld.config_name,
  ld.log_type,
  ld.output_format,
  ld.credentials_id,
  ld.storage_configuration_id,
  ld.delivery_path_prefix,
  ld.delivery_start_time,
  ld.status,
  ld.creation_time,
  ld.update_time,
  ld.log_delivery_status->>'status' AS delivery_status,
  ld.log_delivery_status->>'message' AS delivery_status_message,
  ld.log_delivery_status->>'last_attempt_time' AS last_attempt_time,
  ld.log_delivery_status->>'last_successful_attempt_time' AS last_successful_attempt_time,
  ld.workspace_ids_filter
FROM databricks_account.billing.log_delivery ld
WHERE account_id = '{{ account_id }}'