1 year ago

#324044

test-img

Black Dynamite

AWS Glue Crawler - Timestamp field created as string

I have a data file with a field called extraction_time that has fields like below.

..,"extraction_time":"2022-03-15T02:33:39",..

On my crawler I have a Classifier that looks like so: Crawler Classifier Image

However, when I look at the table that is created, extraction_time is always of the string type.

Extraction Field Type in Table

How do I ensure that when my crawler creates the table, it identifies the extraction_time field as a timestamp and not a string?

Any help is greatly appreciated

amazon-web-services

aws-glue

aws-glue-data-catalog

0 Answers

Your Answer

Accepted video resources