vw_network_errors

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

Overview

Name	vw_network_errors
Type	View
Id	databricks_account.provisioning.vw_network_errors

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 error.
error_type	string	Category of the network validation error (one row per error).
error_message	string	Human-readable description of the network validation error.

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,
  error_type,
  error_message
FROM databricks_account.provisioning.vw_network_errors
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  n.account_id,
  n.network_id,
  n.network_name,
  n.vpc_status,
  JSON_EXTRACT(e.value, '$.error_type') AS error_type,
  JSON_EXTRACT(e.value, '$.error_message') AS error_message
FROM databricks_account.provisioning.networks n,
     JSON_EACH(n.error_messages) e
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  n.account_id,
  n.network_id,
  n.network_name,
  n.vpc_status,
  e.value->>'error_type' AS error_type,
  e.value->>'error_message' AS error_message
FROM databricks_account.provisioning.networks n,
     jsonb_array_elements(n.error_messages::jsonb) AS e
WHERE account_id = '{{ account_id }}'