Change Schema transform does not allow to change data type in Glue Visual ETL job
0
During mapping of a few columns from a CSV file in S3 to a Redshift table, I can't change datatype from long to int. The list is empty, and the search is not showing any results either. In the catalog table, both numeric columns were inferred as bigint, even though the numbers are small.
Any suggestions?
1 Answer
- Newest
- Most votes
- Most comments
0
Seems to be an issue/limitation. You could workaround using "Derived column" and do the casting using SQL (or using a Custom SQL node and do all casting in one query)
Relevant content
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 5 months ago
