vw_networks

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

Overview

Name	vw_networks
Type	View
Id	databricks_account.provisioning.vw_networks

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_id	string	ID of the VPC used by this network configuration (AWS only).
vpc_status	string	Validation status of the VPC (e.g. VALID, BROKEN, UNATTACHED).
workspace_id	integer	ID of the workspace this network configuration is attached to.
creation_time	integer	Unix timestamp (ms) when the network configuration was created.
security_group_ids	array	List of security group IDs associated with this network configuration (AWS only).
subnet_ids	array	List of subnet IDs associated with this network configuration (AWS only).
gcp_network_project_id	string	GCP project ID that hosts the shared VPC network (GCP only).
gcp_vpc_id	string	Name of the GCP VPC network (GCP only).
gcp_subnet_id	string	Name of the GCP subnet used by the workspace (GCP only).
gcp_subnet_region	string	GCP region where the subnet is located (GCP only).
gcp_pod_ip_range_name	string	Name of the secondary IP range used for GKE pods (GCP only).
gcp_service_ip_range_name	string	Name of the secondary IP range used for GKE services (GCP only).
vpc_endpoint_rest_api_ids	array	List of VPC endpoint IDs used for REST API private connectivity (AWS only).
vpc_endpoint_dataplane_relay_ids	array	List of VPC endpoint IDs used for dataplane relay private connectivity (AWS 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_id,
  network_name,
  vpc_id,
  vpc_status,
  workspace_id,
  creation_time,
  security_group_ids,
  subnet_ids,
  gcp_network_project_id,
  gcp_vpc_id,
  gcp_subnet_id,
  gcp_subnet_region,
  gcp_pod_ip_range_name,
  gcp_service_ip_range_name,
  vpc_endpoint_rest_api_ids,
  vpc_endpoint_dataplane_relay_ids
FROM databricks_account.provisioning.vw_networks
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  n.account_id,
  n.network_id,
  n.network_name,
  n.vpc_id,
  n.vpc_status,
  n.workspace_id,
  n.creation_time,
  n.security_group_ids,
  n.subnet_ids,
  JSON_EXTRACT(n.gcp_network_info, '$.network_project_id') AS gcp_network_project_id,
  JSON_EXTRACT(n.gcp_network_info, '$.vpc_id') AS gcp_vpc_id,
  JSON_EXTRACT(n.gcp_network_info, '$.subnet_id') AS gcp_subnet_id,
  JSON_EXTRACT(n.gcp_network_info, '$.subnet_region') AS gcp_subnet_region,
  JSON_EXTRACT(n.gcp_network_info, '$.pod_ip_range_name') AS gcp_pod_ip_range_name,
  JSON_EXTRACT(n.gcp_network_info, '$.service_ip_range_name') AS gcp_service_ip_range_name,
  JSON_EXTRACT(n.vpc_endpoints, '$.rest_api') AS vpc_endpoint_rest_api_ids,
  JSON_EXTRACT(n.vpc_endpoints, '$.dataplane_relay') AS vpc_endpoint_dataplane_relay_ids
FROM databricks_account.provisioning.networks n
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  n.account_id,
  n.network_id,
  n.network_name,
  n.vpc_id,
  n.vpc_status,
  n.workspace_id,
  n.creation_time,
  n.security_group_ids,
  n.subnet_ids,
  n.gcp_network_info->>'network_project_id' AS gcp_network_project_id,
  n.gcp_network_info->>'vpc_id' AS gcp_vpc_id,
  n.gcp_network_info->>'subnet_id' AS gcp_subnet_id,
  n.gcp_network_info->>'subnet_region' AS gcp_subnet_region,
  n.gcp_network_info->>'pod_ip_range_name' AS gcp_pod_ip_range_name,
  n.gcp_network_info->>'service_ip_range_name' AS gcp_service_ip_range_name,
  n.vpc_endpoints->'rest_api' AS vpc_endpoint_rest_api_ids,
  n.vpc_endpoints->'dataplane_relay' AS vpc_endpoint_dataplane_relay_ids
FROM databricks_account.provisioning.networks n
WHERE account_id = '{{ account_id }}'