vw_ncc_aws_private_endpoint_rules

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

Overview

Name	vw_ncc_aws_private_endpoint_rules
Type	View
Id	databricks_account.settings.vw_ncc_aws_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 AWS private endpoint rule (one row per rule).
rule_ncc_id	string	Network connectivity config ID stored within the rule object.
connection_state	string	State of the AWS VPC endpoint connection (e.g. pending, available, rejected).
endpoint_service	string	Name of the AWS endpoint service this rule connects to.
vpc_endpoint_id	string	AWS VPC endpoint ID for this private endpoint rule.
enabled	boolean	Whether this private endpoint rule is currently active.
deactivated	boolean	Whether this private endpoint rule has been deactivated.
resource_names	array	List of resource names associated with this private endpoint rule.
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,
  endpoint_service,
  vpc_endpoint_id,
  enabled,
  deactivated,
  resource_names,
  domain_names,
  error_message,
  creation_time,
  updated_time
FROM databricks_account.settings.vw_ncc_aws_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, '$.endpoint_service') AS endpoint_service,
  JSON_EXTRACT(r.value, '$.vpc_endpoint_id') AS vpc_endpoint_id,
  JSON_EXTRACT(r.value, '$.enabled') AS enabled,
  JSON_EXTRACT(r.value, '$.deactivated') AS deactivated,
  JSON_EXTRACT(r.value, '$.resource_names') AS resource_names,
  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.aws_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->>'endpoint_service' AS endpoint_service,
  r.value->>'vpc_endpoint_id' AS vpc_endpoint_id,
  (r.value->>'enabled')::boolean AS enabled,
  (r.value->>'deactivated')::boolean AS deactivated,
  r.value->'resource_names' AS resource_names,
  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'->'aws_private_endpoint_rules')::jsonb) AS r
WHERE account_id = '{{ account_id }}'