vw_network_connectivity_configs

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

Overview

Name	vw_network_connectivity_configs
Type	View
Id	databricks_account.settings.vw_network_connectivity_configs

Fields

The following fields are returned by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.
network_connectivity_config_id	string	Unique identifier for the network connectivity configuration.
name	string	Human-readable name of the network connectivity configuration.
region	string	Cloud region where this network connectivity configuration applies.
creation_time	integer	Unix timestamp (ms) when the configuration was created.
updated_time	integer	Unix timestamp (ms) when the configuration was last updated.
aws_stable_ip_cidr_blocks	array	List of stable CIDR blocks used for outbound traffic from Databricks (AWS only).
azure_svc_endpoint_region	string	Azure region targeted by the default service endpoint rule (Azure only).
azure_svc_endpoint_subnets	array	List of subnets covered by the default Azure service endpoint rule (Azure only).
azure_svc_endpoint_services	array	List of Azure services targeted by the default service endpoint rule (Azure only).

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_connectivity_config_id,
  name,
  region,
  creation_time,
  updated_time,
  aws_stable_ip_cidr_blocks,
  azure_svc_endpoint_region,
  azure_svc_endpoint_subnets,
  azure_svc_endpoint_services
FROM databricks_account.settings.vw_network_connectivity_configs
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  ncc.account_id,
  ncc.network_connectivity_config_id,
  ncc.name,
  ncc.region,
  ncc.creation_time,
  ncc.updated_time,
  JSON_EXTRACT(ncc.egress_config, '$.default_rules.aws_stable_ip_rule.cidr_blocks') AS aws_stable_ip_cidr_blocks,
  JSON_EXTRACT(ncc.egress_config, '$.default_rules.azure_service_endpoint_rule.target_region') AS azure_svc_endpoint_region,
  JSON_EXTRACT(ncc.egress_config, '$.default_rules.azure_service_endpoint_rule.subnets') AS azure_svc_endpoint_subnets,
  JSON_EXTRACT(ncc.egress_config, '$.default_rules.azure_service_endpoint_rule.target_services') AS azure_svc_endpoint_services
FROM databricks_account.settings.network_connectivity ncc
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  ncc.account_id,
  ncc.network_connectivity_config_id,
  ncc.name,
  ncc.region,
  ncc.creation_time,
  ncc.updated_time,
  ncc.egress_config->'default_rules'->'aws_stable_ip_rule'->'cidr_blocks' AS aws_stable_ip_cidr_blocks,
  ncc.egress_config->'default_rules'->'azure_service_endpoint_rule'->>'target_region' AS azure_svc_endpoint_region,
  ncc.egress_config->'default_rules'->'azure_service_endpoint_rule'->'subnets' AS azure_svc_endpoint_subnets,
  ncc.egress_config->'default_rules'->'azure_service_endpoint_rule'->'target_services' AS azure_svc_endpoint_services
FROM databricks_account.settings.network_connectivity ncc
WHERE account_id = '{{ account_id }}'