Skip to main content

analysis_templates

Creates, updates, deletes, gets or lists an analysis_templates resource.

Overview

Nameanalysis_templates
TypeResource
Idaws.cleanrooms.analysis_templates

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe identifier for the analysis template. (pattern: <code>[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}</code>)
namestringThe name of the analysis template. (pattern: <code>[a-zA-Z0-9_](([a-zA-Z0-9_ ]+-)*([a-zA-Z0-9_ ]+))?</code>)
analysis_parametersarrayThe parameters of the analysis template.
arnstringThe Amazon Resource Name (ARN) of the analysis template. (pattern: <code>arn:aws[-a-z]*:cleanrooms:[\w]{2}-[\w]{4,9}-[\d]:[\d]{12}:membership/[\d\w-]+/analysistemplate/[\d\w-]+</code>)
collaboration_arnstringThe unique ARN for the analysis template’s associated collaboration. (pattern: <code>arn:aws:[\w]+:[\w]{2}-[\w]{4,9}-[\d]:[\d]{12}:collaboration/[\d\w-]+</code>)
collaboration_idstringThe unique ID for the associated collaboration of the analysis template. (pattern: <code>[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}</code>)
create_timestring (date-time)The time that the analysis template was created.
descriptionstringThe description of the analysis template. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDBFF-\uDC00\uDFFF\t\r\n]*</code>)
error_message_configurationobjectA structure that defines the level of detail included in error messages returned by PySpark jobs. This configuration allows you to control the verbosity of error messages to help with troubleshooting PySpark jobs while maintaining appropriate security controls.
format_stringThe format of the analysis template. (SQL, PYSPARK_1_0)
membership_arnstringThe Amazon Resource Name (ARN) of the member who created the analysis template. (pattern: <code>arn:aws:[\w]+:[\w]{2}-[\w]{4,9}-[\d]:[\d]{12}:membership/[\d\w-]+</code>)
membership_idstringThe identifier of a member who created the analysis template. (pattern: <code>[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}</code>)
schemaobjectA relation within an analysis.
sourceobjectThe structure that defines the body of the analysis template.
source_metadataobjectThe source metadata for the analysis template.
synthetic_data_parametersobjectThe parameters that control how synthetic data is generated, including privacy settings, column classifications, and other configuration options that affect the data synthesis process.
update_timestring (date-time)The time that the analysis template was last updated.
validationsarrayInformation about the validations performed on the analysis template.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_analysis_templateselectmembership_identifier, analysis_template_identifier, regionRetrieves an analysis template.
list_analysis_templatesselectmembership_identifier, regionnextToken, maxResultsLists analysis templates that the caller owns.
create_analysis_templateinsertmembership_identifier, region, name, format, sourceCreates a new analysis template.
update_analysis_templateupdatemembership_identifier, analysis_template_identifier, regionUpdates the analysis template metadata.
delete_analysis_templatedeletemembership_identifier, analysis_template_identifier, regionDeletes an analysis template.

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
analysis_template_identifierstringThe identifier for the analysis template resource.
membership_identifierstringThe identifier for a membership resource.
regionstringAWS region (default: us-east-1)
maxResultsintegerThe maximum number of results that are returned for an API request call. The service chooses a default number if you don't set one. The service might return a nextToken even if the maxResults value has not been met.
nextTokenstringThe pagination token that's used to fetch the next set of results.

SELECT examples

Retrieves an analysis template.

SELECT
id,
name,
analysis_parameters,
arn,
collaboration_arn,
collaboration_id,
create_time,
description,
error_message_configuration,
format_,
membership_arn,
membership_id,
schema,
source,
source_metadata,
synthetic_data_parameters,
update_time,
validations
FROM aws.cleanrooms.analysis_templates
WHERE membership_identifier = '{{ membership_identifier }}' -- required
AND analysis_template_identifier = '{{ analysis_template_identifier }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

Creates a new analysis template.

INSERT INTO aws.cleanrooms.analysis_templates (
description,
name,
format,
source,
tags,
analysisParameters,
schema,
errorMessageConfiguration,
syntheticDataParameters,
membership_identifier,
region
)
SELECT
'{{ description }}',
'{{ name }}' /* required */,
'{{ format }}' /* required */,
'{{ source }}' /* required */,
'{{ tags }}',
'{{ analysisParameters }}',
'{{ schema }}',
'{{ errorMessageConfiguration }}',
'{{ syntheticDataParameters }}',
'{{ membership_identifier }}',
'{{ region }}'
RETURNING
analysis_template
;

UPDATE examples

Updates the analysis template metadata.

UPDATE aws.cleanrooms.analysis_templates
SET
description = '{{ description }}'
WHERE
membership_identifier = '{{ membership_identifier }}' --required
AND analysis_template_identifier = '{{ analysis_template_identifier }}' --required
AND region = '{{ region }}' --required
RETURNING
analysis_template;

DELETE examples

Deletes an analysis template.

DELETE FROM aws.cleanrooms.analysis_templates
WHERE membership_identifier = '{{ membership_identifier }}' --required
AND analysis_template_identifier = '{{ analysis_template_identifier }}' --required
AND region = '{{ region }}' --required
;