I am trying to create a table that has a column name with Space using Athena Console.
Example: "Mag Creative" String
Error: This field is required. Spaces are not allowed!
2 Answers
You can try double quotes,like this:
SELECT i."interest expense" FROM "financial-analysis-tool"."income_statement"
Considering that Athena column names cannot contain any other special character besides underscore, the error is prescriptive and explicit about what the problem is. You must use an underscore for this column name instead.
Related