databrew dataset column name special characters

0

HI,

I'm working with databrew to import some excel file to be then used by Athena. For some columns if I try to add an action I get the following error

<ACTION>has not allowed characters in parameter values.

I noticed that this columns has special character like "-" and in fact removing the "-" from the column name in the source file solved the issue. As a workaround is also possible to set the dataset to add a default header, remove the first row and manually parse name of the columns, but both solutions feels real as a workaround.

I also experienced another strange situation where a column interpreted as a string with numbers like "001" because are ids, from databrew is interpreted correctly as string type but the leading zeros are automatically removed "1" with no possibility to restore the original format, even if the source file are present. Again as a workaround I set a fake first row with string values and the leading zeros where preserved.

Any idea?

No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions