Resource tags data in the Connect Customer data lake
The following table contains resource tag data.
Resource tags
Table name:
amazon_connect_resource_tags
Description: Tracks tag changes on Connect resources using a slowly changing dimension (SCD) pattern. Each tag modification creates a new record, enabling tag history analysis.
Primary key:
instance_id, aws_account_id, resource_arn, record_creation_timestamp
Partition key:
record_creation_timestamp (daily)
Join keys:
instance_id— Joins to all tablesresource_arn— Joins to any Connect resource ARN (agents, queues, flows, and so on)
| Column | Type | Nullable | Description |
|---|---|---|---|
| instance_id | string | No | The ID of the Connect Customer instance. |
| aws_account_id | string | No | The ID of the AWS account that owns the resource. |
| instance_arn | string | Yes | The ARN of the Connect Customer instance. |
| record_creation_timestamp | Timestamp | No | The timestamp when tags changed on the resource. |
| resource_arn | string | No | The ARN of the Connect Customer resource. |
| tags | map(string,string) | Yes | The tags associated with the Connect Customer resource. |
| data_lake_last_processed_timestamp | Timestamp | Yes | The timestamp, which shows the last time the record was touched by the data lake. This can include transformation and backfill. This field cannot reliably be used to determine data freshness. |
