vw_ncc_azure_private_endpoint_rules

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

Overview

Name	vw_ncc_azure_private_endpoint_rules
Type	View
Id	databricks_account.settings.vw_ncc_azure_private_endpoint_rules

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 parent network connectivity configuration.
ncc_name	string	Human-readable name of the parent network connectivity configuration.
region	string	Cloud region of the parent network connectivity configuration.
rule_id	string	Unique identifier for this Azure private endpoint rule (one row per rule).
rule_ncc_id	string	Network connectivity config ID stored within the rule object.
connection_state	string	Approval state of the Azure private endpoint connection (e.g. Pending, Approved, Rejected).
resource_id	string	Azure resource ID of the target private link resource.
group_id	string	Sub-resource group ID for the private link resource (e.g. blob, sql).
endpoint_name	string	Name of the Azure private endpoint created for this rule.
deactivated	boolean	Whether this private endpoint rule has been deactivated.
domain_names	array	List of domain names routed through this private endpoint.
error_message	string	Error message if the private endpoint rule is in a failed state.
creation_time	integer	Unix timestamp (ms) when the rule was created.
updated_time	integer	Unix timestamp (ms) when the rule was last updated.

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,
  ncc_name,
  region,
  rule_id,
  rule_ncc_id,
  connection_state,
  resource_id,
  group_id,
  endpoint_name,
  deactivated,
  domain_names,
  error_message,
  creation_time,
  updated_time
FROM databricks_account.settings.vw_ncc_azure_private_endpoint_rules
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  ncc.account_id,
  ncc.network_connectivity_config_id,
  ncc.name AS ncc_name,
  ncc.region,
  JSON_EXTRACT(r.value, '$.rule_id') AS rule_id,
  JSON_EXTRACT(r.value, '$.network_connectivity_config_id') AS rule_ncc_id,
  JSON_EXTRACT(r.value, '$.connection_state') AS connection_state,
  JSON_EXTRACT(r.value, '$.resource_id') AS resource_id,
  JSON_EXTRACT(r.value, '$.group_id') AS group_id,
  JSON_EXTRACT(r.value, '$.endpoint_name') AS endpoint_name,
  JSON_EXTRACT(r.value, '$.deactivated') AS deactivated,
  JSON_EXTRACT(r.value, '$.domain_names') AS domain_names,
  JSON_EXTRACT(r.value, '$.error_message') AS error_message,
  JSON_EXTRACT(r.value, '$.creation_time') AS creation_time,
  JSON_EXTRACT(r.value, '$.updated_time') AS updated_time
FROM databricks_account.settings.network_connectivity ncc,
     JSON_EACH(JSON_EXTRACT(ncc.egress_config, '$.target_rules.azure_private_endpoint_rules')) r
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  ncc.account_id,
  ncc.network_connectivity_config_id,
  ncc.name AS ncc_name,
  ncc.region,
  r.value->>'rule_id' AS rule_id,
  r.value->>'network_connectivity_config_id' AS rule_ncc_id,
  r.value->>'connection_state' AS connection_state,
  r.value->>'resource_id' AS resource_id,
  r.value->>'group_id' AS group_id,
  r.value->>'endpoint_name' AS endpoint_name,
  (r.value->>'deactivated')::boolean AS deactivated,
  r.value->'domain_names' AS domain_names,
  r.value->>'error_message' AS error_message,
  (r.value->>'creation_time')::bigint AS creation_time,
  (r.value->>'updated_time')::bigint AS updated_time
FROM databricks_account.settings.network_connectivity ncc,
     jsonb_array_elements((ncc.egress_config->'target_rules'->'azure_private_endpoint_rules')::jsonb) AS r
WHERE account_id = '{{ account_id }}'