Skip to main content

id_mapping_tables

Creates, updates, deletes or gets an id_mapping_table resource or lists id_mapping_tables in a region

Overview

Nameid_mapping_tables
TypeResource
DescriptionRepresents an association between an ID mapping workflow and a collaboration
Idawscc.cleanrooms.id_mapping_tables

Fields

NameDatatypeDescription
id_mapping_table_identifierstring
arnstring
input_reference_configobject
membership_arnstring
collaboration_arnstring
descriptionstring
namestring
input_reference_propertiesobject
kms_key_arnstring
tagsarray
regionstringAWS region.

For more information, see AWS::CleanRooms::IdMappingTable.

Methods

NameResourceAccessible byRequired Params
create_resourceid_mapping_tablesINSERTMembershipIdentifier, Name, InputReferenceConfig, region
delete_resourceid_mapping_tablesDELETEIdentifier, region
update_resourceid_mapping_tablesUPDATEIdentifier, PatchDocument, region
list_resourcesid_mapping_tables_list_onlySELECTregion
get_resourceid_mapping_tablesSELECTIdentifier, region

SELECT examples

Gets all properties from an individual id_mapping_table.

SELECT
region,
id_mapping_table_identifier,
arn,
input_reference_config,
membership_identifier,
membership_arn,
collaboration_identifier,
collaboration_arn,
description,
name,
input_reference_properties,
kms_key_arn,
tags
FROM awscc.cleanrooms.id_mapping_tables
WHERE
region = 'us-east-1' AND
Identifier = '{{ id_mapping_table_identifier }}|{{ membership_identifier }}';

INSERT example

Use the following StackQL query and manifest file to create a new id_mapping_table resource, using stack-deploy.

/*+ create */
INSERT INTO awscc.cleanrooms.id_mapping_tables (
InputReferenceConfig,
MembershipIdentifier,
Name,
region
)
SELECT
'{{ input_reference_config }}',
'{{ membership_identifier }}',
'{{ name }}',
'{{ region }}';

UPDATE example

Use the following StackQL query and manifest file to update a id_mapping_table resource, using stack-deploy.

/*+ update */
UPDATE awscc.cleanrooms.id_mapping_tables
SET PatchDocument = string('{{ {
"Description": description,
"KmsKeyArn": kms_key_arn,
"Tags": tags
} | generate_patch_document }}')
WHERE
region = '{{ region }}' AND
Identifier = '{{ id_mapping_table_identifier }}|{{ membership_identifier }}';

DELETE example

/*+ delete */
DELETE FROM awscc.cleanrooms.id_mapping_tables
WHERE
Identifier = '{{ id_mapping_table_identifier }}|{{ membership_identifier }}' AND
region = 'us-east-1';

Permissions

To operate on the id_mapping_tables resource, the following permissions are required:

cleanrooms:CreateIdMappingTable,
cleanrooms:GetIdMappingTable,
cleanrooms:ListIdMappingTables,
cleanrooms:ListTagsForResource,
cleanrooms:TagResource,
cleanrooms:GetMembership,
cleanrooms:GetCollaboration,
entityresolution:GetIdMappingWorkflow,
entityresolution:AddPolicyStatement