ip_access_lists

Operations on a ip_access_lists resource.

Overview

Name	ip_access_lists
Type	Resource
Id	databricks_workspace.workspace.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	ip_access_list_id, deployment_name	Gets an IP access list, specified by its list ID.
list	SELECT	deployment_name	Gets all IP access lists for the specified workspace.
create	INSERT	deployment_name	Creates an IP access list for this workspace.
delete	DELETE	ip_access_list_id, deployment_name	Deletes an IP access list, specified by its list ID.
update	UPDATE	ip_access_list_id, deployment_name	Updates an existing IP access list, specified by its ID.
replace	REPLACE	ip_access_list_id, deployment_name	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_workspace.workspace.ip_access_lists
WHERE deployment_name = '{{ deployment_name }}';

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_workspace.workspace.ip_access_lists
WHERE ip_access_list_id = '{{ ip_access_list_id }}' AND
deployment_name = '{{ deployment_name }}';

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_workspace.workspace.ip_access_lists (
deployment_name,
data__label,
data__list_type,
data__ip_addresses
)
SELECT 
'{{ deployment_name }}',
'{{ 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_workspace.workspace.ip_access_lists
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE ip_access_list_id = '{{ ip_access_list_id }}' AND
deployment_name = '{{ deployment_name }}';

REPLACE example

Replaces a ip_access_lists resource.

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

DELETE example

Deletes a ip_access_lists resource.

/*+ delete */
DELETE FROM databricks_workspace.workspace.ip_access_lists
WHERE ip_access_list_id = '{{ ip_access_list_id }}' AND
deployment_name = '{{ deployment_name }}';