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?

Paolo
質問済み 1年前83ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ