provider_personalization_requests

Operations on a provider_personalization_requests resource.

Overview

Name	provider_personalization_requests
Type	Resource
Id	databricks_workspace.marketplace.provider_personalization_requests

Fields

Name	Datatype
id	string
comment	string
consumer_region	object
contact_info	object
created_at	integer
intended_use	string
is_from_lighthouse	boolean
listing_id	string
listing_name	string
metastore_id	string
provider_id	string
recipient_type	string
share	object
status	string
status_message	string
updated_at	integer

Methods

Name	Accessible by	Required Params	Description
list	SELECT	deployment_name	List personalization requests to this provider. This will return all personalization requests, regardless of which listing they are for.
update	UPDATE	listing_id, request_id, deployment_name	Update personalization request. This method only permits updating the status of the request.

SELECT examples

SELECT
id,
comment,
consumer_region,
contact_info,
created_at,
intended_use,
is_from_lighthouse,
listing_id,
listing_name,
metastore_id,
provider_id,
recipient_type,
share,
status,
status_message,
updated_at
FROM databricks_workspace.marketplace.provider_personalization_requests
WHERE deployment_name = '{{ deployment_name }}';

UPDATE example

Updates a provider_personalization_requests resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update        
UPDATE databricks_workspace.marketplace.provider_personalization_requests
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE listing_id = '{{ listing_id }}' AND
request_id = '{{ request_id }}' AND
deployment_name = '{{ deployment_name }}';