Skip to main content

id_mapping_tables

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

Overview

Nameid_mapping_tables
TypeResource
Idaws.cleanrooms.id_mapping_tables

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe unique identifier of the ID mapping table. (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 ID mapping table. (pattern: <code>[a-zA-Z0-9_](([a-zA-Z0-9_ ]+-)*([a-zA-Z0-9_ ]+))?</code>)
arnstringThe Amazon Resource Name (ARN) of the ID mapping table. (pattern: <code>arn:aws:cleanrooms:[\w]{2}-[\w]{4,9}-[\d]:[\d]{12}:membership/[\d\w-]+/idmappingtable/[\d\w-]+</code>)
child_resourcesarrayThe child resources that depend on this ID mapping table.
collaboration_arnstringThe Amazon Resource Name (ARN) of the collaboration that contains this ID mapping table. (pattern: <code>arn:aws:[\w]+:[\w]{2}-[\w]{4,9}-[\d]:[\d]{12}:collaboration/[\d\w-]+</code>)
collaboration_idstringThe unique identifier of the collaboration that contains this ID mapping table. (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 at which the ID mapping table was created.
descriptionstringThe description of the ID mapping table. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDBFF-\uDC00\uDFFF\t\r\n]*</code>)
input_reference_configobjectProvides the input reference configuration for the ID mapping table.
input_reference_propertiesobjectThe input reference properties for the ID mapping table.
kms_key_arnstringThe Amazon Resource Name (ARN) of the Amazon Web Services KMS key. (pattern: <code>arn:aws:kms:[\w]{2}-[\w]{4,9}-[\d]:[\d]{12}:key/[a-zA-Z0-9-]+</code>)
membership_arnstringThe Amazon Resource Name (ARN) of the membership resource for the ID mapping table. (pattern: <code>arn:aws:[\w]+:[\w]{2}-[\w]{4,9}-[\d]:[\d]{12}:membership/[\d\w-]+</code>)
membership_idstringThe unique identifier of the membership resource for the ID mapping table. (pattern: <code>[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}</code>)
update_timestring (date-time)The most recent time at which the ID mapping table was updated.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_id_mapping_tableselectid_mapping_table_identifier, membership_identifier, regionRetrieves an ID mapping table.
list_id_mapping_tablesselectmembership_identifier, regionnextToken, maxResultsReturns a list of ID mapping tables.
create_id_mapping_tableinsertmembership_identifier, region, name, inputReferenceConfigCreates an ID mapping table.
update_id_mapping_tableupdateid_mapping_table_identifier, membership_identifier, regionProvides the details that are necessary to update an ID mapping table.
delete_id_mapping_tabledeleteid_mapping_table_identifier, membership_identifier, regionDeletes an ID mapping table.
populate_id_mapping_tableexecid_mapping_table_identifier, membership_identifier, regionDefines the information that's necessary to populate an ID mapping table.

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
id_mapping_table_identifierstringThe unique identifier of the ID mapping table that you want to populate.
membership_identifierstringThe unique identifier of the membership that contains the ID mapping table that you want to populate.
regionstringAWS region (default: us-east-1)
maxResultsintegerThe maximum size of the results that is returned per call. Service chooses a default if it has not been set. Service may return a nextToken even if the maximum results has not been met.
nextTokenstringThe pagination token that's used to fetch the next set of results.

SELECT examples

Retrieves an ID mapping table.

SELECT
id,
name,
arn,
child_resources,
collaboration_arn,
collaboration_id,
create_time,
description,
input_reference_config,
input_reference_properties,
kms_key_arn,
membership_arn,
membership_id,
update_time
FROM aws.cleanrooms.id_mapping_tables
WHERE id_mapping_table_identifier = '{{ id_mapping_table_identifier }}' -- required
AND membership_identifier = '{{ membership_identifier }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

Creates an ID mapping table.

INSERT INTO aws.cleanrooms.id_mapping_tables (
name,
description,
inputReferenceConfig,
tags,
kmsKeyArn,
membership_identifier,
region
)
SELECT
'{{ name }}' /* required */,
'{{ description }}',
'{{ inputReferenceConfig }}' /* required */,
'{{ tags }}',
'{{ kmsKeyArn }}',
'{{ membership_identifier }}',
'{{ region }}'
RETURNING
id_mapping_table
;

UPDATE examples

Provides the details that are necessary to update an ID mapping table.

UPDATE aws.cleanrooms.id_mapping_tables
SET
description = '{{ description }}',
kmsKeyArn = '{{ kmsKeyArn }}'
WHERE
id_mapping_table_identifier = '{{ id_mapping_table_identifier }}' --required
AND membership_identifier = '{{ membership_identifier }}' --required
AND region = '{{ region }}' --required
RETURNING
id_mapping_table;

DELETE examples

Deletes an ID mapping table.

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

Lifecycle Methods

Defines the information that's necessary to populate an ID mapping table.

EXEC aws.cleanrooms.id_mapping_tables.populate_id_mapping_table
@id_mapping_table_identifier='{{ id_mapping_table_identifier }}' --required,
@membership_identifier='{{ membership_identifier }}' --required,
@region='{{ region }}' --required
@@json=
'{
"jobType": "{{ jobType }}"
}'
;