Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

Decimal data type applies to floating points up to 15 digits in length.

  • In the Trifacta application, this data type is referenced as Decimal.
  • In storage, this data type is written as Double.

Punctuation such as commas and dollar signs ($) are not supported. These markers must be removed from numeric values through transformation 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 INC. 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

This page has no comments.