vw_network_warnings

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

Overview

Name	vw_network_warnings
Type	View
Id	databricks_account.provisioning.vw_network_warnings

Fields

The following fields are returned by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.
network_id	string	Unique identifier for the network configuration.
network_name	string	Human-readable name of the network configuration.
vpc_status	string	Validation status of the VPC at the time of the warning.
warning_type	string	Category of the network validation warning (one row per warning).
warning_message	string	Human-readable description of the network validation warning.

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,
  network_id,
  network_name,
  vpc_status,
  warning_type,
  warning_message
FROM databricks_account.provisioning.vw_network_warnings
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  n.account_id,
  n.network_id,
  n.network_name,
  n.vpc_status,
  JSON_EXTRACT(w.value, '$.warning_type') AS warning_type,
  JSON_EXTRACT(w.value, '$.warning_message') AS warning_message
FROM databricks_account.provisioning.networks n,
     JSON_EACH(n.warning_messages) w
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  n.account_id,
  n.network_id,
  n.network_name,
  n.vpc_status,
  w.value->>'warning_type' AS warning_type,
  w.value->>'warning_message' AS warning_message
FROM databricks_account.provisioning.networks n,
     jsonb_array_elements(n.warning_messages::jsonb) AS w
WHERE account_id = '{{ account_id }}'