Decimal Data Type

Decimal data type applies to floating points up to 15 digits in length.
  • Punctuation such as commas and dollar signs ($) are not supported. These markers must be removed from numeric values through transform steps before you can change the type to Decimal.
  • The following range is considered safe for values of this type. There may be inconsistencies in output for values outside this range:
    • Safe minimum: 4.9406564584124654e-324
    • Safe maximum: 1.7976931348623157e+308

Notes:

  • Decimal values that are longer than 15 digits are treated as String values and may appear as mismatched values in a Decimal column.
  • Scientific notation is not supported.
  • Cloud Dataprep by TRIFACTA utilizes Java's Float data type for its Decimal data validation, which may result in some loss of precision in rare cases.

Examples:

  • 123.45
  • 3000.00
  • 1.2345678E+22
  • 7.4423e-12
  • -4.123e+12
Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation
Need help? Visit our support page.