Aws_ec2_ebs_volumes create_time format issue in aws-plugin and postgres versions

CloudQuery Plugins
1

Hi Team!

I’m using aws-plugin v16.0.1 and postgres v4.2.0.

I found that in aws_ec2_ebs_volumes, the column create_time is not in ISO 8601 format (like all the timestamps retrieved from the AWS API). For example, in the column attachments->>'AttachTime', it’s in ISO format. Is this something that has been fixed in newer versions?

Thanks in advance!

2

I dug up the docs for that table in version v16.0.1 here: AWS EC2 EBS Volumes Documentation

It seems like it was using Timestamp type, but this was quite a long time ago now (it seems like before our migration to Apache Arrow).

Could you check the type of the column for the create_time column in aws_ec2_ebs_volumes? Is it not timestamp?

3

The types.Volume type for CreateTime seems to be *time.Time, and the type on the CloudQuery schema is timestamp[us, tz=UTC].

4

Could you check the type of the column for the create_time column in aws_ec2_ebs_volumes? Is it not timestamp?

timestamp without time zone
I think it’s my fault. When I extracted the AttachTime from the attachments column I didn’t cast it to timestamp, that’s why the format does not match :man_bowing:
One question, all dates that CQ stores are in UTC format?

5

Yes, they should be (or at least I think so; there might be exceptions).

6

Thank you! And sorry for the inconvenience.