vw_network_policy_internet_destinations

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

Overview

Name	vw_network_policy_internet_destinations
Type	View
Id	databricks_account.settings.vw_network_policy_internet_destinations

Fields

The following fields are returned by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.
network_policy_id	string	Unique identifier for the network policy.
restriction_mode	string	Overall egress restriction mode for the policy (e.g. FULL_RESTRICTION, NO_RESTRICTION).
enforcement_mode	string	Enforcement mode for the egress policy (e.g. ENFORCED, AUDIT).
destination	string	Allowed internet destination hostname or CIDR (one row per destination).
destination_type	string	Classification of the allowed internet destination (e.g. PUBLIC).

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_policy_id,
  restriction_mode,
  enforcement_mode,
  destination,
  destination_type
FROM databricks_account.settings.vw_network_policy_internet_destinations
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  np.account_id,
  np.network_policy_id,
  JSON_EXTRACT(np.egress, '$.network_access.restriction_mode') AS restriction_mode,
  JSON_EXTRACT(np.egress, '$.network_access.policy_enforcement.enforcement_mode') AS enforcement_mode,
  JSON_EXTRACT(d.value, '$.destination') AS destination,
  JSON_EXTRACT(d.value, '$.internet_destination_type') AS destination_type
FROM databricks_account.settings.network_policies np,
     JSON_EACH(JSON_EXTRACT(np.egress, '$.network_access.allowed_internet_destinations')) d
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  np.account_id,
  np.network_policy_id,
  np.egress->'network_access'->>'restriction_mode' AS restriction_mode,
  np.egress->'network_access'->'policy_enforcement'->>'enforcement_mode' AS enforcement_mode,
  d.value->>'destination' AS destination,
  d.value->>'internet_destination_type' AS destination_type
FROM databricks_account.settings.network_policies np,
     jsonb_array_elements((np.egress->'network_access'->'allowed_internet_destinations')::jsonb) AS d
WHERE account_id = '{{ account_id }}'