Supported data types - Data Profiling

Applies to: Dataedo 24.x (current) versions, Article available also for: 10.x, 23.x

Data profiling is supported for most data types and for majority of real use cases. In case when data type is equivalent to one of the below types it will be converted to it, and whole profiling should succeed.

Numbers

Supported numeric data types are displayed in American notation. For instance 12.345.678,9.

  • Boolean
  • Int (Int, BigInt)
  • Real (float, double)

Strings

For any set larger than 250 signs we will only use first 250 signs for processing purposes.

  • String (Char, Varchar)

Please note that neither TEXT nor CLOB data types are currently supported.

Date and Time

Date and Time are displayed in original format from database, regardless of local environment settings.

  • Date
  • Datetime
  • Time