consumer_personalization_requests

Operations on a consumer_personalization_requests resource.

Overview

Name	consumer_personalization_requests
Type	Resource
Id	databricks_workspace.marketplace.consumer_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
get	SELECT	listing_id, deployment_name	Get the personalization request for a listing. Each consumer can make at
list	SELECT	deployment_name	List personalization requests for a consumer across all listings.
create	INSERT	listing_id, deployment_name	Create a personalization request for a listing.

SELECT examples

consumer_personalization_requests (list)

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.consumer_personalization_requests
WHERE deployment_name = '{{ deployment_name }}';

consumer_personalization_requests (get)

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.consumer_personalization_requests
WHERE listing_id = '{{ listing_id }}' AND
deployment_name = '{{ deployment_name }}';

INSERT example

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

consumer_personalization_requests

/*+ create */
INSERT INTO databricks_workspace.marketplace.consumer_personalization_requests (
listing_id,
deployment_name,
data__comment,
data__intended_use,
data__first_name,
data__last_name,
data__company,
data__is_from_lighthouse,
data__recipient_type,
data__accepted_consumer_terms
)
SELECT 
'{{ listing_id }}',
'{{ deployment_name }}',
'{{ comment }}',
'{{ intended_use }}',
'{{ first_name }}',
'{{ last_name }}',
'{{ company }}',
'{{ is_from_lighthouse }}',
'{{ recipient_type }}',
'{{ accepted_consumer_terms }}'
;

Manifest

- name: your_resource_model_name
  props:
  - name: comment
    value: string
  - name: intended_use
    value: string
  - name: first_name
    value: string
  - name: last_name
    value: string
  - name: company
    value: string
  - name: is_from_lighthouse
    value: true
  - name: recipient_type
    value: DELTA_SHARING_RECIPIENT_TYPE_DATABRICKS
  - name: accepted_consumer_terms
    value:
      version: string