consumer_personalization_requests

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

Overview

Name	consumer_personalization_requests
Type	Resource
Id	databricks_workspace.marketplace.consumer_personalization_requests

Fields

The following fields are returned by SELECT queries:

list

Request completed successfully.

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

get

Request completed successfully.

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

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	deployment_name		List personalization requests for a consumer across all listings.
get	select	deployment_name		Get the personalization request for a listing. Each consumer can make at
create	insert	deployment_name		Create a personalization request for a listing.

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 personalization requests for a consumer across all listings.

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

get

Get the personalization request for a listing. Each consumer can make at

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

INSERT examples

create

Create a personalization request for a listing.

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

Manifest

# Description fields are for documentation purposes
- name: consumer_personalization_requests
  props:
    - name: deployment_name
      value: string
      description: Required parameter for the consumer_personalization_requests resource.
    - name: comment
      value: string
    - name: intended_use
      value: required
    - name: first_name
      value: string
    - name: last_name
      value: string
    - name: company
      value: string
    - name: is_from_lighthouse
      value: string
    - name: recipient_type
      value: boolean
    - name: accepted_consumer_terms
      value: object