Cleanse Column Names directive
The CLEANSE-COLUMN-NAMES directive sanitizes column names, following these rules:
Trims leading and trailing spaces
Lowercases the column name
Replaces any character that are not one of
[A-Z][a-z][0-9]or_with an underscore (_)
Syntax
cleanse-column-namesExample
Using this record as an example:
{
"COL1": 1,
"col:2": 2,
"Col3": 3,
"COLUMN4": 4,
"col!5": 5
}Applying this directive:
cleanse-column-namesresults in this record:
Created in 2020 by Google Inc.