Problem with column which is named "ID"

[databrickslabs]

Problem with column which is named "ID"

[ronanstokes-db]

Will add a fix in two phases

• phase 1 : will warn when column named id is added
• phase 2: allow renaming of the seed column

[ronanstokes-db]

ID and id are reserved column names - we can look at making this configurable if needed but in the current release these are reserved for system use

[SemyonSinchenko]

Best to make it configurable. Or at least raise some exceptions about it on the stage of column adding... Because it is really unobvious to get AnalysisException: Reference 'ID' is ambiguous, could be: ID, ID. Because ID is very often usable name. We have such a column in each GDWH table for example. Thank you!