Table: aws_ssm_sessions
This table shows data for AWS Systems Manager (SSM) Sessions.
https://docs.aws.amazon.com/systems-manager/latest/APIReference/API_Session.html (opens in a new tab). Only Active sessions are fetched.
The composite primary key for this table is (account_id, region, session_id).
Columns
| Name | Type |
|---|---|
| _cq_source_name | utf8 |
| _cq_sync_time | timestamp[us, tz=UTC] |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| account_id (PK) | utf8 |
| region (PK) | utf8 |
| details | utf8 |
| document_name | utf8 |
| end_date | timestamp[us, tz=UTC] |
| max_session_duration | utf8 |
| output_url | json |
| owner | utf8 |
| reason | utf8 |
| session_id (PK) | utf8 |
| start_date | timestamp[us, tz=UTC] |
| status | utf8 |
| target | utf8 |
