NUMBER_FORMAT - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

NUMBER_FORMAT

Returns a column in which a numeric value is converted into a formatted string.

Parameters
  • sourceColumn – String. The name of an existing column.

  • decimalPlaces – Integer. The value of number of digits after the decimal separator.

  • numericDecimalSeparator – String. One of the following values indicating the decimal separator:

    • "."

    • ","

  • numericThousandSeparator – String. One of the following values indicating the thousand separator:

    • null. Indicates that a thousand separator isn't enabled.

    • ","

    • " "

    • "."

    • "\\"

  • numericAbbreviatedUnit – String. One of the following values indicating the abbreviation unit:

    • null. Indicates that an abbreviation unit isn't enabled.

    • “THOUSAND”

    • "MILLION"

    • "BILLION"

    • "TRILLION"

  • numericUnitAbbreviation – String. One of the following values or any custom value, indicating unit abbreviation:

    • null. Indicates that unit abbreviation isn't enabled.

    • Abbreviation unit Options

      Thousands

      K, k, M, thousand, custom

      Million

      M, m, MM, million, custom

      Billion

      B, bn, billion, custom

      Trillion

      T, tn, trillion, custom

Example

{ "RecipeAction": { "Operation": "NUMBER_FORMAT", "Parameters": { "sourceColumn": "income", "decimalPlaces": "2", "numericDecimalSeparator": ".", "numericThousandSeparator": ",", "numericAbbreviatedUnit": "THOUSAND", "numericUnitAbbreviation": "K" } } }