Supported data types

Data profiling is supported for most data types and for the majority of real use cases. In cases where a data type is equivalent to one of the below types, it will be converted to it, and the 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 characters, we will only use the first 250 characters for processing purposes.

• String (Char, Varchar)

note

TEXT and CLOB data types are not supported.

Date and Time

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

• Date
• Datetime
• Time