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
preguntada hace un año83 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas