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 }}"
}'
;