Data type matching table

When you create a dataset, DataLens converts the source data to its own type for streamlined data processing.
This helps DataLens unify the operations with data from different sources.

The table below shows how data types of different databases and DataLens internal data types correspond to one another.

DataLensClickHousePostgreSQL
Booleanbooleanboolean
Datedatedate
Date and timedatetimetimestamp
Floating-point numberfloat
float32
float64
decimal*
real
double precision
numeric
Integerinteger
int8
int16
int32
int64
uint8
uint16
uint32
uint64
smallint
integer
bigint
Stringstring
enum8
enum16
char
varchar
text
citext
GeopointDefined by formula in DataLensDefined by formula in DataLens
GeopolygonDefined by formula in DataLensDefined by formula in DataLens
Integer arrayArray(integer)
Array(int8)
Array(int16)
Array(int32)
Array(int64)
Array(uint8)
Array(uint16)
Array(uint32)
Array(uint64)
Array(smallint)
Array(integer)
Array(bigint)
Float arrayArray(float32)
Array(float64)
Array(real)
Array(double)
Array(precision)
Array(numeric)
String arrayArray(string)Array(char)
Array(varchar)
Array(text)

* You may lose precision when converting data.