Configuration data in the Connect Customer data lake
This topic details the content in the Connect Customer data lake configuration tables. The tables list the column, type, and description of the content.
There are two ways to access the analytics data lake and configure data to be shared:
If you are unable to access the scheduling tables by using Option 1, try using Option 2.
Agent Hierarchy Groups
Table name:
agent_hierarchy_groups
Description: Dimension table containing the hierarchy group definitions for organizing agents, including group names, ARNs, and active status.
Primary key:
agent_hierarchy_group_id
Join keys:
instance_id— Joins to all tablesagent_hierarchy_group_id— Joins to users table, Agent Statistic Record and Agent Queue Statistic Record (asagent_hierarchy_level_*_id)
| Column | Type | Description | |
|---|---|---|---|
| instance_id | string | Yes | The ID of the Connect Customer instance. |
| instance_arn | string | Yes | The ARN of the Connect Customer instance. |
| aws_account_id | string | Yes | The ID of the AWS account that owns the contact. |
| agent_hierarchy_group_id | string | No | The identifier of the hierarchy group for the user. |
| agent_hierarchy_group_arn | string | Yes | The ARN of the hierarchy group. |
| agent_hierarchy_group_name | string | Yes | The name of the hierarchy group. |
| last_modified_region | string | Yes | The AWS Region where this resource was last modified. |
| last_modified_timestamp | timestamp | Yes | The Timestamp when this resource was last modified. |
| is_active | Boolean | Yes | Whether the agent hierarchy group exists or has been deleted. |
| data_lake_last_processed_timestamp | Timestamp | Yes | Timestamp, which shows the last time the record was touched by the data lake. This can include transformation and backfill. This field cannot be used to determine reliably data freshness. |
Routing profiles
Table name:
routing_profiles
Description: Dimension table containing routing profile configurations, including profile name, default outbound queue, and availability timer settings.
Primary key:
agent_routing_profile_id
Join keys:
instance_id— Joins to all tablesagent_routing_profile_id— Joins to users table, Agent Statistic Record and Agent Queue Statistic Record (asrouting_profile_id)
| Column | Type | Description | |
|---|---|---|---|
| agent_routing_profile_id | string | No | The identifier of the routing profile. |
| agent_routing_profile_arn | string | Yes | The ARN of the routing profile. |
| routing_profile_name | string | Yes | The name of the routing profile. |
| instance_id | string | Yes | The ID of the Connect Customer instance. |
| instance_arn | string | Yes | The ARN of the Connect Customer instance. |
| agent_availability_timer | string | Yes | Whether agents with this routing profile will have their routing order calculated based on longest idle time or time since their last inbound contact. |
| default_outbound_queue_id | string | Yes | The default outbound queue for the routing profile. |
| routing_profile_description | string | Yes | Description of the routing profile. |
| last_modified_region | string | Yes | The AWS Region where this resource was last modified. |
| last_modified_timestamp | Timestamp | Yes | The Timestamp when this resource was last modified. |
| is_active | Boolean | Yes | Whether the agent exists or has been deleted. |
| data_lake_last_processed_timestamp | Timestamp | Yes | Timestamp, which shows the last time the record was touched by the data lake. This can include transformation and backfill. This field cannot be used to determine reliably data freshness. |
Users
Table name:
users
Description: Master dimension table for agent data containing user identity, contact information, hierarchy assignments, routing profile, security profiles, and phone configuration.
Primary key:
user_id
Join keys:
instance_id— Joins to all tablesuser_id— Joins to Contact Record (asagent_id), Agent Statistic Record, Agent Queue Statistic Record, Contact Evaluation Recorduser_arn— Joins to Agent Event (asagent_arn), scheduling tables (asagent_arn)agent_routing_profile_id— Joins to routing_profilesagent_hierarchy_group_id— Joins to agent_hierarchy_groups
| Column | Type | Description | |
|---|---|---|---|
| user_id | string | No | The identifier of the user account. |
| user_arn | string | Yes | The ARN of the user account. |
| directory_user_id | string | Yes | The identifier of the user account in the directory used for identity management. |
| agent_hierarchy_group_id | string | Yes | The identifier of the hierarchy group for the user. |
| agent_hierarchy_group_arn | string | Yes | The identifier of level 1 hierarchy group for the user. |
| agent_hierarchy_group_level_1_id | string | Yes | The identifier of level 1 hierarchy group for the user. |
| agent_hierarchy_group_level_2_id | string | Yes | The identifier of level 2 hierarchy group for the user. |
| agent_hierarchy_group_level_3_id | string | Yes | The identifier of level 3 hierarchy group for the user. |
| agent_hierarchy_group_level_4_id | string | Yes | The identifier of level 4 hierarchy group for the user. |
| agent_hierarchy_group_level_5_id | string | Yes | The identifier of level 5 hierarchy group for the user. |
| agent_email | string | Yes | The user's email address. |
| agent_secondary_email | string | Yes | The user's secondary email address. |
| first_name | string | Yes | The first name of the agent. |
| last_name | string | Yes | The last name of the agent. |
| mobile | string | Yes | The user's mobile number. |
| agent_username | string | Yes | The user name of the agent, as entered in their Connect Customer user account. |
| instance_id | string | Yes | The ID of the Connect Customer instance. |
| instance_arn | string | Yes | The ARN of the Connect Customer instance. |
| agent_routing_profile_id | string | Yes | The ID of the routing profile for the agent. |
| agent_routing_profile_arn | string | Yes | The ARN of the routing profile for the agent. |
| agent_security_profile_ids | array<string> | Yes | The IDs of the security profiles for the user. |
| agent_security_profile_arns | array<string> | Yes | The ARNs of the security profiles for the user. |
| last_modified_region | string | Yes | The AWS Region where this resource was last modified. |
| last_modified_timestamp | Timestamp | Yes | The Timestamp when this resource was last modified. |
| after_contact_work_time_limit | int | Yes | The After Call Work (ACW) timeout setting, in seconds. |
| auto_accept | Boolean | Yes | The Auto accept setting. |
| desk_phone_number | string | Yes | The phone number for the user's desk phone. |
| phone_type | string | Yes | The phone type. |
| is_active | Boolean | Yes | Whether the agent exists or has been deleted. |
| data_lake_last_processed_timestamp | Timestamp | Yes | Timestamp, which shows the last time the record was touched by the data lake. This can include transformation and backfill. This field cannot be used to determine reliably data freshness. |
| agent_voice_enhancement_mode | string | Yes | The voice enhancement mode used by the agent. Valid values: VOICE_ISOLATION | NOISE_SUPPRESSION | NONE. A value of null indicates this mode has not yet been set for this user. |