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?

답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠