AWS Glue Lower Case Columns

1
votes

I'm doing ETL from Postgres to Redshift with AWS Glue. I have imported a table with a Crawler and created a Job to just transfer the data and create a new table in Redshift. I get:

An error occurred while calling o65.getDynamicFrame. ERROR: column "id" does not exist

In the original table the column is "Id", case sensitive. Is there a way to make Glue case sensitive? (I don't have permissions to change the postgres schema).

1
amazon-redshiftaws-glue

1 Answers

1
votes
dyf.apply_mapping(mappings, case_sensitive = True, transformation_ctx = "tfx")

In mappings, you should map Id to id.