vw_ip_access_list_addresses

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

Overview

Name	vw_ip_access_list_addresses
Type	View
Id	databricks_account.settings.vw_ip_access_list_addresses

Fields

The following fields are returned by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.
list_id	string	Unique identifier for the IP access list.
label	string	Human-readable label for the IP access list.
list_type	string	Type of the IP access list - either ALLOW or BLOCK.
enabled	boolean	Whether the IP access list is currently active.
address_count	integer	Total number of IP addresses or CIDR ranges in this list.
created_at	integer	Unix timestamp (ms) when the IP access list was created.
created_by	integer	ID of the user who created the IP access list.
updated_at	integer	Unix timestamp (ms) when the IP access list was last updated.
updated_by	integer	ID of the user who last updated the IP access list.
ip_address	string	Individual IP address or CIDR range entry from the list (one row per entry).

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,
  list_id,
  label,
  list_type,
  enabled,
  address_count,
  created_at,
  created_by,
  updated_at,
  updated_by,
  ip_address
FROM databricks_account.settings.vw_ip_access_list_addresses
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  l.account_id,
  l.list_id,
  l.label,
  l.list_type,
  l.enabled,
  l.address_count,
  l.created_at,
  l.created_by,
  l.updated_at,
  l.updated_by,
  a.value AS ip_address
FROM databricks_account.settings.account_ip_access_lists l,
     JSON_EACH(l.ip_addresses) a
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  l.account_id,
  l.list_id,
  l.label,
  l.list_type,
  l.enabled,
  l.address_count,
  l.created_at,
  l.created_by,
  l.updated_at,
  l.updated_by,
  a.value AS ip_address
FROM databricks_account.settings.account_ip_access_lists l,
     jsonb_array_elements(l.ip_addresses::jsonb) AS a
WHERE account_id = '{{ account_id }}'