EntityResolution / Client / update_schema_mapping
update_schema_mapping¶
- EntityResolution.Client.update_schema_mapping(**kwargs)¶
Updates a schema mapping.
Note
A schema is immutable if it is being used by a workflow. Therefore, you can’t update a schema mapping if it’s associated with a workflow.
See also: AWS API Documentation
Request Syntax
response = client.update_schema_mapping( schemaName='string', description='string', mappedInputFields=[ { 'fieldName': 'string', 'type': 'NAME'|'NAME_FIRST'|'NAME_MIDDLE'|'NAME_LAST'|'ADDRESS'|'ADDRESS_STREET1'|'ADDRESS_STREET2'|'ADDRESS_STREET3'|'ADDRESS_CITY'|'ADDRESS_STATE'|'ADDRESS_COUNTRY'|'ADDRESS_POSTALCODE'|'PHONE'|'PHONE_NUMBER'|'PHONE_COUNTRYCODE'|'EMAIL_ADDRESS'|'UNIQUE_ID'|'DATE'|'STRING'|'PROVIDER_ID', 'groupName': 'string', 'matchKey': 'string', 'subType': 'string', 'hashed': True|False }, ] )
- Parameters:
schemaName (string) –
[REQUIRED]
The name of the schema. There can’t be multiple
SchemaMappings
with the same name.description (string) – A description of the schema.
mappedInputFields (list) –
[REQUIRED]
A list of
MappedInputFields
. EachMappedInputField
corresponds to a column the source data table, and contains column name plus additional information that Entity Resolution uses for matching.(dict) –
A configuration object for defining input data fields in Entity Resolution. The SchemaInputAttribute specifies how individual fields in your input data should be processed and matched.
fieldName (string) – [REQUIRED]
A string containing the field name.
type (string) – [REQUIRED]
The type of the attribute, selected from a list of values.
Note
Normalization is only supported for
NAME
,ADDRESS
,PHONE
, andEMAIL_ADDRESS
.If you want to normalize
NAME_FIRST
,NAME_MIDDLE
, andNAME_LAST
, you must group them by assigning them to theNAME
groupName
.If you want to normalize
ADDRESS_STREET1
,ADDRESS_STREET2
,ADDRESS_STREET3
,ADDRESS_CITY
,ADDRESS_STATE
,ADDRESS_COUNTRY
, andADDRESS_POSTALCODE
, you must group them by assigning them to theADDRESS
groupName
.If you want to normalize
PHONE_NUMBER
andPHONE_COUNTRYCODE
, you must group them by assigning them to thePHONE
groupName
.groupName (string) –
A string that instructs Entity Resolution to combine several columns into a unified column with the identical attribute type.
For example, when working with columns such as
NAME_FIRST
,NAME_MIDDLE
, andNAME_LAST
, assigning them a commongroupName
will prompt Entity Resolution to concatenate them into a single value.matchKey (string) –
A key that allows grouping of multiple input attributes into a unified matching group.
For example, consider a scenario where the source table contains various addresses, such as
business_address
andshipping_address
. By assigning amatchKey
calledaddress
to both attributes, Entity Resolution will match records across these fields to create a consolidated matching group.If no
matchKey
is specified for a column, it won’t be utilized for matching purposes but will still be included in the output table.subType (string) –
The subtype of the attribute, selected from a list of values.
hashed (boolean) –
Indicates if the column values are hashed in the schema input.
If the value is set to
TRUE
, the column values are hashed.If the value is set to
FALSE
, the column values are cleartext.
- Return type:
dict
- Returns:
Response Syntax
{ 'schemaName': 'string', 'schemaArn': 'string', 'description': 'string', 'mappedInputFields': [ { 'fieldName': 'string', 'type': 'NAME'|'NAME_FIRST'|'NAME_MIDDLE'|'NAME_LAST'|'ADDRESS'|'ADDRESS_STREET1'|'ADDRESS_STREET2'|'ADDRESS_STREET3'|'ADDRESS_CITY'|'ADDRESS_STATE'|'ADDRESS_COUNTRY'|'ADDRESS_POSTALCODE'|'PHONE'|'PHONE_NUMBER'|'PHONE_COUNTRYCODE'|'EMAIL_ADDRESS'|'UNIQUE_ID'|'DATE'|'STRING'|'PROVIDER_ID', 'groupName': 'string', 'matchKey': 'string', 'subType': 'string', 'hashed': True|False }, ] }
Response Structure
(dict) –
schemaName (string) –
The name of the schema.
schemaArn (string) –
The ARN (Amazon Resource Name) that Entity Resolution generated for the
SchemaMapping
.description (string) –
A description of the schema.
mappedInputFields (list) –
A list of
MappedInputFields
. EachMappedInputField
corresponds to a column the source data table, and contains column name plus additional information that Entity Resolution uses for matching.(dict) –
A configuration object for defining input data fields in Entity Resolution. The SchemaInputAttribute specifies how individual fields in your input data should be processed and matched.
fieldName (string) –
A string containing the field name.
type (string) –
The type of the attribute, selected from a list of values.
Note
Normalization is only supported for
NAME
,ADDRESS
,PHONE
, andEMAIL_ADDRESS
.If you want to normalize
NAME_FIRST
,NAME_MIDDLE
, andNAME_LAST
, you must group them by assigning them to theNAME
groupName
.If you want to normalize
ADDRESS_STREET1
,ADDRESS_STREET2
,ADDRESS_STREET3
,ADDRESS_CITY
,ADDRESS_STATE
,ADDRESS_COUNTRY
, andADDRESS_POSTALCODE
, you must group them by assigning them to theADDRESS
groupName
.If you want to normalize
PHONE_NUMBER
andPHONE_COUNTRYCODE
, you must group them by assigning them to thePHONE
groupName
.groupName (string) –
A string that instructs Entity Resolution to combine several columns into a unified column with the identical attribute type.
For example, when working with columns such as
NAME_FIRST
,NAME_MIDDLE
, andNAME_LAST
, assigning them a commongroupName
will prompt Entity Resolution to concatenate them into a single value.matchKey (string) –
A key that allows grouping of multiple input attributes into a unified matching group.
For example, consider a scenario where the source table contains various addresses, such as
business_address
andshipping_address
. By assigning amatchKey
calledaddress
to both attributes, Entity Resolution will match records across these fields to create a consolidated matching group.If no
matchKey
is specified for a column, it won’t be utilized for matching purposes but will still be included in the output table.subType (string) –
The subtype of the attribute, selected from a list of values.
hashed (boolean) –
Indicates if the column values are hashed in the schema input.
If the value is set to
TRUE
, the column values are hashed.If the value is set to
FALSE
, the column values are cleartext.
Exceptions