Skip to main content

provider_personalization_requests

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

Overview

Nameprovider_personalization_requests
TypeResource
Iddatabricks_workspace.marketplace.provider_personalization_requests

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstring
listing_idstring
metastore_idstring
provider_idstring
listing_namestring
commentstring
consumer_regionobject
contact_infoobjectcontact info for the consumer requesting data or performing a listing installation
created_atinteger
intended_usestring
is_from_lighthouseboolean
recipient_typestringCreate a collection of name/value pairs.<br /><br />Example enumeration:<br /><br />&gt;&gt;&gt; class Color(Enum):<br />... RED = 1<br />... BLUE = 2<br />... GREEN = 3<br /><br />Access them by:<br /><br />- attribute access:<br /><br /> &gt;&gt;&gt; Color.RED<br /> &lt;Color.RED: 1&gt;<br /><br />- value lookup:<br /><br /> &gt;&gt;&gt; Color(1)<br /> &lt;Color.RED: 1&gt;<br /><br />- name lookup:<br /><br /> &gt;&gt;&gt; Color['RED']<br /> &lt;Color.RED: 1&gt;<br /><br />Enumerations can be iterated over, and know how many members they have:<br /><br />&gt;&gt;&gt; len(Color)<br />3<br /><br />&gt;&gt;&gt; list(Color)<br />[&lt;Color.RED: 1&gt;, &lt;Color.BLUE: 2&gt;, &lt;Color.GREEN: 3&gt;]<br /><br />Methods can be added to enumerations, and members can have their own<br />attributes -- see the documentation for details. (DELTA_SHARING_RECIPIENT_TYPE_DATABRICKS, DELTA_SHARING_RECIPIENT_TYPE_OPEN)
shareobjectShare information is required for data listings but should be empty/ignored for non-data listings (MCP and App).
statusstringCreate a collection of name/value pairs.<br /><br />Example enumeration:<br /><br />&gt;&gt;&gt; class Color(Enum):<br />... RED = 1<br />... BLUE = 2<br />... GREEN = 3<br /><br />Access them by:<br /><br />- attribute access:<br /><br /> &gt;&gt;&gt; Color.RED<br /> &lt;Color.RED: 1&gt;<br /><br />- value lookup:<br /><br /> &gt;&gt;&gt; Color(1)<br /> &lt;Color.RED: 1&gt;<br /><br />- name lookup:<br /><br /> &gt;&gt;&gt; Color['RED']<br /> &lt;Color.RED: 1&gt;<br /><br />Enumerations can be iterated over, and know how many members they have:<br /><br />&gt;&gt;&gt; len(Color)<br />3<br /><br />&gt;&gt;&gt; list(Color)<br />[&lt;Color.RED: 1&gt;, &lt;Color.BLUE: 2&gt;, &lt;Color.GREEN: 3&gt;]<br /><br />Methods can be added to enumerations, and members can have their own<br />attributes -- see the documentation for details. (DENIED, FULFILLED, NEW, REQUEST_PENDING)
status_messagestring
updated_atinteger

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectdeployment_namepage_size, page_tokenList personalization requests to this provider. This will return all personalization requests,
updatereplacelisting_id, request_id, deployment_name, statusUpdate personalization request. This method only permits updating the status of the request.

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
deployment_namestringThe Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)
listing_idstring
request_idstring
page_sizeinteger
page_tokenstring

SELECT examples

List personalization requests to this provider. This will return all personalization requests,

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

REPLACE examples

Update personalization request. This method only permits updating the status of the request.

REPLACE databricks_workspace.marketplace.provider_personalization_requests
SET
status = '{{ status }}',
reason = '{{ reason }}',
share = '{{ share }}'
WHERE
listing_id = '{{ listing_id }}' --required
AND request_id = '{{ request_id }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND status = '{{ status }}' --required
RETURNING
request;