Skip to main content

recommender_schemas

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

Overview

Namerecommender_schemas
TypeResource
Idaws.customer_profiles.recommender_schemas

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
created_atstring (date-time)The timestamp of when the recommender schema was created.
fieldsobjectA map of dataset type to column definitions included in the schema.
recommender_schema_namestringThe name of the recommender schema. (pattern: <code>^[a-zA-Z0-9_-]+$</code>)
statusstringThe status of the recommender schema. (ACTIVE, DELETING)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_recommender_schemaselectdomain_name, recommender_schema_name, regionRetrieves information about a specific recommender schema in a domain.
list_recommender_schemasselectdomain_name, regionmax-results, next-tokenReturns a list of recommender schemas in the specified domain.
create_recommender_schemainsertdomain_name, recommender_schema_name, regionCreates a recommender schema. A recommender schema defines the set of data columns available for training recommenders and filters under a domain.
delete_recommender_schemadeletedomain_name, recommender_schema_name, regionDeletes a recommender schema from a domain.

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
domain_namestringThe unique name of the domain.
recommender_schema_namestringThe name of the recommender schema to delete.
regionstringAWS region (default: us-east-1)
max-resultsintegerThe maximum number of recommender schemas to return in the response. The default value is 100.
next-tokenstringA token received from a previous ListRecommenderSchemas call to retrieve the next page of results.

SELECT examples

Retrieves information about a specific recommender schema in a domain.

SELECT
created_at,
fields,
recommender_schema_name,
status
FROM aws.customer_profiles.recommender_schemas
WHERE domain_name = '{{ domain_name }}' -- required
AND recommender_schema_name = '{{ recommender_schema_name }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

Creates a recommender schema. A recommender schema defines the set of data columns available for training recommenders and filters under a domain.

INSERT INTO aws.customer_profiles.recommender_schemas (
Fields,
Tags,
domain_name,
recommender_schema_name,
region
)
SELECT
'{{ Fields }}',
'{{ Tags }}',
'{{ domain_name }}',
'{{ recommender_schema_name }}',
'{{ region }}'
RETURNING
created_at,
fields,
recommender_schema_arn,
recommender_schema_name,
status,
tags
;

DELETE examples

Deletes a recommender schema from a domain.

DELETE FROM aws.customer_profiles.recommender_schemas
WHERE domain_name = '{{ domain_name }}' --required
AND recommender_schema_name = '{{ recommender_schema_name }}' --required
AND region = '{{ region }}' --required
;