Change Schema transform does not allow to change data type in Glue Visual ETL job

Question

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? Apply mapping

Any suggestions?
![Apply mapping](/media/postImages/original/IMaVN6cLFhQaWH8xVrBc3lLg)

Accepted Answer

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)

Answer

I am having the same issue, the search is not showing struct, array and map data types.

Change Schema transform does not allow to change data type in Glue Visual ETL job

Contenido relevante