Add table aws_health_event

[tinder-tder]

There are several api paths that are read only but informative and can be used to easily track upcoming events outside of the aws health console

one example would be to query for any upcoming events using https://docs.aws.amazon.com/health/latest/APIReference/API_DescribeEvents.html and filtering by status: upcoming

References

https://docs.aws.amazon.com/health/latest/APIReference/API_Operations.html

[ParthaI]

Hello @tinder-tder, we have raised a draft PR for the above-mentioned tables.

Since we don't have an account of the type Business, Enterprise On-Ramp, or Enterprise Support plan for testing out the table, we love it if you could help us to test out the values of the proposed tables.

Could you please run the following queries?

select * from aws_health_event where start_time = '25-07-2022';

select * from aws_health_event where end_time = '25-07-2022';

select * from aws_health_event where service = 'EC2';

The above queries will help us check whether the optional quals are working correctly or not. It would be great if you could help us in testing out the tables so that we could publish them to the hub.

[tinder-tder]

@ParthaI Sorry for the delay, the email notifications got lost in the shuffle.
So it looks like date format expected is MM-DD-YYYY. I tried to look at known upcoming events but it wasnt showing anything

> select * from aws_health_event where start_time = '08-17-2022';
+-----+-------------------+------------+----------+------------------+---------------------+-----------------+-------------------+---------+-------------+------+-----------+--------+>
| arn | availability_zone | start_time | end_time | event_scope_code | event_type_category | event_type_code | last_updated_time | service | status_code | akas | partition | region |>
+-----+-------------------+------------+----------+------------------+---------------------+-----------------+-------------------+---------+-------------+------+-----------+--------+>
+-----+-------------------+------------+----------+------------------+---------------------+-----------------+-------------------+---------+-------------+------+-----------+--------+>
> select * from prod.aws_health_event where start_time = '08-17-2022';
+-----+-------------------+------------+----------+------------------+---------------------+-----------------+-------------------+---------+-------------+------+-----------+--------+>
| arn | availability_zone | start_time | end_time | event_scope_code | event_type_category | event_type_code | last_updated_time | service | status_code | akas | partition | region |>
+-----+-------------------+------------+----------+------------------+---------------------+-----------------+-------------------+---------+-------------+------+-----------+--------+>
+-----+-------------------+------------+----------+------------------+---------------------+-----------------+-------------------+---------+-------------+------+-----------+--------+>
> select * from aws_health_event where start_time = '25-07-2022';
Error: date/time field value out of range: "25-07-2022" (SQLSTATE 22008)
> select * from aws_health_event where end_time = '25-07-2022';
Error: date/time field value out of range: "25-07-2022" (SQLSTATE 22008)
> select * from prod.aws_health_event where start_time = '08-16-2022';
+-----+-------------------+------------+----------+------------------+---------------------+-----------------+-------------------+---------+-------------+------+-----------+--------+>
| arn | availability_zone | start_time | end_time | event_scope_code | event_type_category | event_type_code | last_updated_time | service | status_code | akas | partition | region |>
+-----+-------------------+------------+----------+------------------+---------------------+-----------------+-------------------+---------+-------------+------+-----------+--------+>
+-----+-------------------+------------+----------+------------------+---------------------+-----------------+-------------------+---------+-------------+------+-----------+--------+>
> select * from prod.aws_health_event where service = 'EC2';
Error: failed to populate column 'akas': invalid character 'a' looking for beginning of value (SQLSTATE HV000)
> 

[ParthaI]

Thanks, @tinder-tder, for your feedback. Let me try to update the format of strart_time and the optional quals service column error.

[github-actions[bot]]

'This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 30 days.'

[cbruno10]

Hey @tinder-tder , sorry for the slow review speed, some other priorities have come up, but we're looking to merge in https://github.com/turbot/steampipe-plugin-aws/pull/1167 before the end of this week.

[tinder-tder]

@cbruno10 Thanks for the update!

[github-actions[bot]]

'This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 30 days.'