How to parse full timestamp strings as datetimes in CloudQuery

CloudQuery Plugins
1

How to correctly parse strings as datetimes?

I am using the Python SDK, and the relevant line from the source is this link:

elif isinstance(value, str):
    self._value = datetime.strptime(value, "%Y-%m-%d")

But the string is a full timestamp, eg “2021-02-04T09:43:39.717-08:00”.

Can I tell CloudQuery to expect this format?

Answering my own question: it’s possible to transform the data from a string to a datetime in the table resolver, then CloudQuery detects it properly.

2

I think you’re trying to use the wrong type for the underlying data here: date64 is for dates, like 2023-02-03, while timestamp is for date-times. Here is the link to the documentation, and passing 2021-02-04T09:43:39.717-08:00 in to the timestamp type should work.

3

Thanks! I will try that now.
Yes, that works and is much easier. Thanks very much!