ip_access_lists

Operations on a ip_access_lists resource.

Overview

Name	ip_access_lists
Type	Resource
Id	databricks_account.settings.ip_access_lists

Fields

Name	Datatype
address_count	integer
created_at	integer
created_by	integer
enabled	boolean
ip_addresses	array
label	string
list_id	string
list_type	string
updated_at	integer
updated_by	integer

Methods

Name	Accessible by	Required Params	Description
get	SELECT	account_id, ip_access_list_id	Gets an IP access list, specified by its list ID.
list	SELECT	account_id	Gets all IP access lists for the specified account.
create	INSERT	account_id	Creates an IP access list for the account.
delete	DELETE	account_id, ip_access_list_id	Deletes an IP access list, specified by its list ID.
update	UPDATE	account_id, ip_access_list_id	Updates an existing IP access list, specified by its ID.
replace	REPLACE	account_id, ip_access_list_id	Replaces an IP access list, specified by its ID.

SELECT examples

ip_access_lists (list)

SELECT
address_count,
created_at,
created_by,
enabled,
ip_addresses,
label,
list_id,
list_type,
updated_at,
updated_by
FROM databricks_account.settings.ip_access_lists
WHERE account_id = '{{ account_id }}';

ip_access_lists (get)

SELECT
address_count,
created_at,
created_by,
enabled,
ip_addresses,
label,
list_id,
list_type,
updated_at,
updated_by
FROM databricks_account.settings.ip_access_lists
WHERE account_id = '{{ account_id }}' AND
ip_access_list_id = '{{ ip_access_list_id }}';

INSERT example

Use the following StackQL query and manifest file to create a new ip_access_lists resource.

ip_access_lists

/*+ create */
INSERT INTO databricks_account.settings.ip_access_lists (
account_id,
data__label,
data__list_type,
data__ip_addresses
)
SELECT 
'{{ account_id }}',
'{{ label }}',
'{{ list_type }}',
'{{ ip_addresses }}'
;

Manifest

- name: your_resource_model_name
  props:
  - name: label
    value: Office VPN
  - name: list_type
    value: ALLOW
  - name: ip_addresses
    value:
    - 192.168.100.0/22

UPDATE example

Updates a ip_access_lists resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update        
UPDATE databricks_account.settings.ip_access_lists
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE account_id = '{{ account_id }}' AND
ip_access_list_id = '{{ ip_access_list_id }}';

REPLACE example

Replaces a ip_access_lists resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update
REPLACE databricks_account.settings.ip_access_lists
SET field1 = '{ value1 }',
field2 = '{ value2 }', ...
WHERE account_id = '{{ account_id }}' AND
ip_access_list_id = '{{ ip_access_list_id }}';

DELETE example

Deletes a ip_access_lists resource.

/*+ delete */
DELETE FROM databricks_account.settings.ip_access_lists
WHERE account_id = '{{ account_id }}' AND
ip_access_list_id = '{{ ip_access_list_id }}';