provider_exchange_filters

Creates, updates, deletes, gets or lists a provider_exchange_filters resource.

Overview

Name	provider_exchange_filters
Type	Resource
Id	databricks_workspace.marketplace.provider_exchange_filters

Fields

The following fields are returned by SELECT queries:

list

Request completed successfully.

Name	Datatype	Description
id	string
name	string
exchange_id	string
created_at	integer
created_by	string
filter_type	string
filter_value	string
updated_at	integer
updated_by	string

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	deployment_name		List exchange filter
create	insert	deployment_name		Add an exchange filter.
update	update	deployment_name		Update an exchange filter.
delete	delete	deployment_name		Delete an exchange filter

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.

Name	Datatype	Description
deployment_name	string	The Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)

SELECT examples

list

List exchange filter

SELECT
id,
name,
exchange_id,
created_at,
created_by,
filter_type,
filter_value,
updated_at,
updated_by
FROM databricks_workspace.marketplace.provider_exchange_filters
WHERE deployment_name = '{{ deployment_name }}' -- required;

INSERT examples

create

Add an exchange filter.

INSERT INTO databricks_workspace.marketplace.provider_exchange_filters (
data__filter,
deployment_name
)
SELECT 
'{{ filter }}',
'{{ deployment_name }}'
RETURNING
filter_id
;

Manifest

# Description fields are for documentation purposes
- name: provider_exchange_filters
  props:
    - name: deployment_name
      value: string
      description: Required parameter for the provider_exchange_filters resource.
    - name: filter
      value: object

UPDATE examples

update

Update an exchange filter.

UPDATE databricks_workspace.marketplace.provider_exchange_filters
SET 
data__filter = '{{ filter }}'
WHERE 
deployment_name = '{{ deployment_name }}' --required
RETURNING
filter;

DELETE examples

delete

Delete an exchange filter

DELETE FROM databricks_workspace.marketplace.provider_exchange_filters
WHERE deployment_name = '{{ deployment_name }}' --required;