| Column Name | Column Data Type |
|---|
schema_name Required Input Column
The name of the schema. | VARCHAR |
_aws_profile Input Column
The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role. | STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
) |
Show child fields- _aws_profile.account_id
The AWS account id - _aws_profile.assumed_role_arn
The ARN of the assumed role - _aws_profile.name
The unique name of the profile. - _aws_profile.organization
Information about this profile's membership in the AWS organization. Show child fields- _aws_profile.organization.account_name
The name of account speciifed by the organization - _aws_profile.organization.id
The organization id - _aws_profile.organization.master_account
Show child fields- _aws_profile.organization.master_account.email
The organization master account email address - _aws_profile.organization.master_account.id
The organization master account id
- _aws_profile.organization.parents[]
Show child fields- _aws_profile.organization.parents[].id
The id of the parent - _aws_profile.organization.parents[].name
The name of the parent - _aws_profile.organization.parents[].tags[]
Show child fields- _aws_profile.organization.parents[].tags[].key
- _aws_profile.organization.parents[].tags[].value
- _aws_profile.organization.parents[].type
The type of parent can be an organization unit or a root
- _aws_profile.organization.tags[]
Show child fields- _aws_profile.organization.tags[].key
- _aws_profile.organization.tags[].value
- _aws_profile.type
The type of profile, either 'credentials' or 'assumed_role' - _aws_profile.via_profile_name
This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
|
created_at
The timestamp of when the SchemaMapping was created. | TIMESTAMP_S |
description
A description of the schema. | VARCHAR |
has_workflows
Specifies whether the schema mapping has been applied to a workflow. | BOOLEAN |
mapped_input_fields
A list of MappedInputFields. Each MappedInputField corresponds to a column the source data table, and contains column name plus additional information Venice uses for matching. | STRUCT(
"field_name" VARCHAR,
"group_name" VARCHAR,
"hashed" BOOLEAN,
"match_key" VARCHAR,
"sub_type" VARCHAR,
"type" VARCHAR
)[] |
Show child fields- mapped_input_fields[]
Show child fields- mapped_input_fields[].field_name
A string containing the field name. - mapped_input_fields[].group_name
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 first_name, middle_name, and last_name, assigning them a common groupName will prompt Entity Resolution to concatenate them into a single value. - mapped_input_fields[].hashed
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. - mapped_input_fields[].match_key
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 and shipping_address. By assigning a matchKey called address 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. - mapped_input_fields[].sub_type
The subtype of the attribute, selected from a list of values. - mapped_input_fields[].type
The type of the attribute, selected from a list of values.
|
schema_arn
The ARN (Amazon Resource Name) that Entity Resolution generated for the SchemaMapping. | VARCHAR |
tags
The tags used to organize, track, or control access for this resource. | MAP(VARCHAR, VARCHAR) |
updated_at
The timestamp of when the SchemaMapping was last updated. | TIMESTAMP_S |