# Flow data in the Connect Customer data lake
<a name="data-lake-flow-data"></a>

The following tables contain flow data.

**Topics**
+ [Contact flow events](#data-lake-contact-flow-events)
+ [Connect test case execution results](#data-lake-connect-test-case-execution-results)

## Contact flow events
<a name="data-lake-contact-flow-events"></a>

**Table name:** `contact_flow_events`

**Description:** Records contact flow execution events, tracking flow traversal including start and end timestamps, flow outcomes, and transitions between flows and queues.

**Primary key:** `event_id, instance_id`

**Partition key:** `start_timestamp` (daily)

**Join keys:**
+ `instance_id` — Joins to all tables
+ `contact_id` — Joins to Contact Record, Contact Statistic Record, Contact Lens, Contact Evaluation Record
+ `flow_resource_id` — Joins to flow configuration data
+ `next_queue_resource_id` — Joins to Contact Record (as `queue_id`), Agent Queue Statistic Record (as `queue_id`)


|  **Column**  |  **Type**  |  **Description**  |   | 
| --- | --- | --- | --- | 
|  instance\_id  |  string  |  The identifier of the Connect Customer instance. You can [find the instance ID](https://docs.aws.amazon.com/connect/latest/adminguide/find-instance-arn.html) in the Amazon Resource Name (ARN) of the instance.  |   | 
|  event\_id  |  string  |  The ID of the contact as it interacts with the flow.  |   | 
|  aws\_account\_id  |  string  |  The ID of the AWS account that owns the contact.  |   | 
|  instance\_arn  |  string  |  The ARN of the Connect Customer instance.  |   | 
|  contact\_id  |  string  |  The ID of the contact in the contact record.  |   | 
|  flow\_resource\_id  |  string  |  Flow Id  |   | 
|  module\_resource\_id  |  string  |  Module Id  |   | 
|  resource\_version  |  string  |  Version of the contact flow used.  |   | 
|  resource\_type  |  string  |  Can be flow or module.  |   | 
|  channel  |  string  |  The method used to contact your contact center: VOICE, CHAT, TASK, EMAIL.  |   | 
|  start\_timestamp  | Timestamp  |  Date and time of the start event in unix epoch, UTC  |   | 
|  end\_timestamp  | Timestamp  |  Date and time of the end event    in unix epoch, UTC.  |   | 
|  next\_flow\_resource\_id  |  string  |  Next contact flow resourceId.  |   | 
|  next\_queue\_resource\_id  |  string  |  Next queue resourceId.  |   | 
|  next\_resource\_type  |  string  |  It can be flow or queue.  |   | 
|  flow\_language\_version  |  string  |  Flow language version.  |   | 
|  flow\_outcome  |  string  |  This will contain the system defined and custom outcomes.  |   | 
|  sub\_type  |  string  |  This field can be used to show channel subtype. For example, connect:Guide or connect:SMS or connect:Email.  |   | 
|  flow\_type  |  string  |  Connect Customer includes a set of nine flow types. For more information, see [Choose a flow type](create-contact-flow.md#contact-flow-types).  |   | 
|  initiation\_method  |  string  |  Every contact in your Connect Customer contact center is initiated by one of the following methods: Inbound, Outbound, Transfer, Callback, API, Queue Transfer, Disconnect.  |   | 
|  resource\_published\_timestamp  | Timestamp  |  "Creation" or "revision" date of the flow itself.  |   | 
|  data\_lake\_last\_processed\_timestamp  | Timestamp  |  The Timestamp, which shows the last time the data lake processed the record. This can include transformation and backfill. This field cannot reliably be used to determine data freshness.  |   | 

## Connect test case execution results
<a name="data-lake-connect-test-case-execution-results"></a>

**Table name:** `connect_test_case_execution_results`

**Description:** Stores test case execution results including status, outcomes, failure reasons, and associated contacts for Connect test automation.

**Primary key:** `connect_test_case_resource_arn, connect_test_case_execution_start_timestamp, connect_test_case_execution_id`

**Partition key:** `connect_test_case_execution_start_timestamp` (daily)

**Join keys:**
+ `instance_id` — Joins to all tables
+ `connect_test_case_associated_initial_contact_id` — Joins to Contact Record (as `contact_id`)
+ `connect_test_case_initiating_flow_id` — Joins to Contact Flow Events (as `flow_resource_id`)


**Connect Test Case Execution Results**  

| Column | Type | Description | 
| --- | --- | --- | 
| instance\_id | string |  Yes  | The identifier of the Amazon Connect instance | 
| instance\_arn | string |  Yes  | The ARN of the Amazon Connect instance. | 
| aws\_account\_id | string |  Yes  | The ID of the AWS account that owns the contact. | 
| connect\_test\_case\_resource\_arn | string |  No  | Primary Key - The ARN of the Test Case. | 
| connect\_test\_case\_resource\_name | string |  Yes  | The name of the Test Case. | 
| connect\_test\_case\_execution\_start\_timestamp | timestamp |  No  | Primary Key - The start time of simulated execution. | 
| connect\_test\_case\_execution\_end\_timestamp | timestamp |  Yes  | The end time of simulated execution. | 
| connect\_test\_case\_status | string |  Yes  | Current state of Test. Values: Scheduled, InProgress, Completed, Aborted, Failed | 
| connect\_test\_case\_result | string |  Yes  | The final result of Test execution. Values: Passed, Failed, Skipped, Aborted | 
| connect\_test\_case\_execution\_id | string |  No  | Primary Key - The unique identifier for Test execution. | 
| connect\_test\_case\_failure\_reasons | array(string) |  Yes  | The reasons for failed Test. | 
| connect\_test\_case\_type | string |  Yes  | The type of Test executed. Values: ExperienceTest, FlowTest, BotTest | 
| connect\_test\_case\_execution\_method | string |  Yes  | The method of starting Test execution. Values: Manual, API, Scheduled, ContactRuleTriggered, FlowPublishTriggered | 
| connect\_test\_case\_execution\_channel | string |  Yes  | The channel of simulated interaction. Values: Chat, Voice, Campaign, Task, Email | 
| connect\_test\_case\_execution\_channel\_subtype | string |  Yes  | The channel subtype of simulated interaction. Values: SMS, WhatsApp | 
| connect\_test\_case\_associated\_initial\_contact\_id | string |  Yes  | Initial contact ID to start Test. | 
| connect\_test\_case\_associated\_contact\_ids | array(string) |  Yes  | List of contact IDs created as part of Test. | 
| connect\_test\_case\_initiating\_flow\_id | string |  Yes  | First resource ID Test Execution started with. | 
| record\_creation\_timestamp | timestamp |  Yes  | The time of record creation |