cleanse_name()

Utility to make a string SQL safe so that it can be used as an alias for a new column.

Takes the following actions on a string:

  1. remove double quotes

  2. replace spaces and dashes with underscores

  3. cast to upper case

  4. delete anything that is not letters, numbers, or underscores

  5. if first character is a number, add an underscore to the beginning

Parameters

Type
Description

string

text to make SQL safe; works on column names, table names, row values, etc...

Example

SELECT *

<div data-gb-custom-block data-tag="-"></div>

    , {{math_op}} as {{cleanse_name(math_op)}}

<div data-gb-custom-block data-tag="-"></div>

FROM {{source_table}}

Last updated