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.settings.ip_access_lists

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
ip_access_listobjectDefinition of an IP Access list

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectip_access_list_id, deployment_nameGets an IP access list, specified by its list ID.
listselectdeployment_nameGets all IP access lists for the specified workspace.
createinsertdeployment_name, label, list_typeCreates an IP access list for this workspace.
updateupdateip_access_list_id, deployment_nameUpdates an existing IP access list, specified by its ID.
replacereplaceip_access_list_id, deployment_name, label, list_type, enabledReplaces an IP access list, specified by its ID.
deletedeleteip_access_list_id, deployment_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)
ip_access_list_idstringThe ID for the corresponding IP access list

SELECT examples

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

SELECT
ip_access_list
FROM databricks_workspace.settings.ip_access_lists
WHERE ip_access_list_id = '{{ ip_access_list_id }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
;

INSERT examples

Creates an IP access list for this workspace.

INSERT INTO databricks_workspace.settings.ip_access_lists (
label,
list_type,
ip_addresses,
deployment_name
)
SELECT
'{{ label }}' /* required */,
'{{ list_type }}' /* required */,
'{{ ip_addresses }}',
'{{ deployment_name }}'
RETURNING
ip_access_list
;

UPDATE examples

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

UPDATE databricks_workspace.settings.ip_access_lists
SET
enabled = {{ enabled }},
ip_addresses = '{{ ip_addresses }}',
label = '{{ label }}',
list_type = '{{ list_type }}'
WHERE
ip_access_list_id = '{{ ip_access_list_id }}' --required
AND deployment_name = '{{ deployment_name }}' --required;

REPLACE examples

Replaces an IP access list, specified by its ID.

REPLACE databricks_workspace.settings.ip_access_lists
SET
label = '{{ label }}',
list_type = '{{ list_type }}',
enabled = {{ enabled }},
ip_addresses = '{{ ip_addresses }}'
WHERE
ip_access_list_id = '{{ ip_access_list_id }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND label = '{{ label }}' --required
AND list_type = '{{ list_type }}' --required
AND enabled = {{ enabled }} --required;

DELETE examples

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

DELETE FROM databricks_workspace.settings.ip_access_lists
WHERE ip_access_list_id = '{{ ip_access_list_id }}' --required
AND deployment_name = '{{ deployment_name }}' --required
;