Skip to main content

ip_access_lists

Creates, updates, deletes, gets or lists an ip_access_lists resource.

Overview

Nameip_access_lists
TypeResource
Iddatabricks_workspace.workspace.ip_access_lists

Fields

The following fields are returned by SELECT queries:

Request completed successfully.

NameDatatypeDescription
list_idstring
address_countinteger
created_atinteger
created_byinteger
enabledboolean
ip_addressesarray
labelstring
list_typestring
updated_atinteger
updated_byinteger

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdeployment_nameGets an IP access list, specified by its list ID.
listselectdeployment_nameGets all IP access lists for the specified workspace.
createinsertdeployment_nameCreates an IP access list for this workspace.
updateupdatedeployment_nameUpdates an existing IP access list, specified by its ID.
replacereplacedeployment_nameReplaces an IP access list, specified by its ID.
deletedeletedeployment_nameDeletes an IP access list, specified by its list ID.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
deployment_namestringThe Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)

SELECT examples

Gets an IP access list, specified by its list ID.

SELECT
list_id,
address_count,
created_at,
created_by,
enabled,
ip_addresses,
label,
list_type,
updated_at,
updated_by
FROM databricks_workspace.workspace.ip_access_lists
WHERE deployment_name = '{{ deployment_name }}' -- required;

INSERT examples

Creates an IP access list for this workspace.

INSERT INTO databricks_workspace.workspace.ip_access_lists (
data__label,
data__list_type,
data__ip_addresses,
deployment_name
)
SELECT
'{{ label }}',
'{{ list_type }}',
'{{ ip_addresses }}',
'{{ deployment_name }}'
RETURNING
ip_access_list
;

UPDATE examples

Updates an existing IP access list, specified by its ID.

UPDATE databricks_workspace.workspace.ip_access_lists
SET
data__label = '{{ label }}',
data__list_type = '{{ list_type }}',
data__ip_addresses = '{{ ip_addresses }}',
data__enabled = {{ enabled }}
WHERE
deployment_name = '{{ deployment_name }}' --required;

REPLACE examples

Replaces an IP access list, specified by its ID.

REPLACE databricks_workspace.workspace.ip_access_lists
SET
data__label = '{{ label }}',
data__list_type = '{{ list_type }}',
data__ip_addresses = '{{ ip_addresses }}',
data__enabled = '{{ enabled }}'
WHERE
deployment_name = '{{ deployment_name }}' --required;

DELETE examples

Deletes an IP access list, specified by its list ID.

DELETE FROM databricks_workspace.workspace.ip_access_lists
WHERE deployment_name = '{{ deployment_name }}' --required;