Skip to main content

ip_access_lists

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

Overview

Nameip_access_lists
TypeResource
Iddatabricks_account.settings.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
getselectGets an IP access list, specified by its list ID.
listselectGets all IP access lists for the specified account.
createinsertCreates an IP access list for the account.
updateupdateUpdates an existing IP access list, specified by its ID.
replacereplaceReplaces an IP access list, specified by its ID.
deletedeleteDeletes 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

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

INSERT examples

Creates an IP access list for the account.

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

UPDATE examples

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

UPDATE databricks_account.settings.ip_access_lists
SET
data__label = '{{ label }}',
data__list_type = '{{ list_type }}',
data__ip_addresses = '{{ ip_addresses }}',
data__enabled = {{ enabled }}
WHERE
;

REPLACE examples

Replaces an IP access list, specified by its ID.

REPLACE databricks_account.settings.ip_access_lists
SET
data__label = '{{ label }}',
data__list_type = '{{ list_type }}',
data__ip_addresses = '{{ ip_addresses }}',
data__enabled = '{{ enabled }}'
WHERE
;

DELETE examples

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

DELETE FROM databricks_account.settings.ip_access_lists;