Data Configurations

Data Types#

Data Imports allows you to configure the data types of your table columns that are being imported into your destination database.

Configuring data types allows you to perform aggregations and apply formulas permitted for those data types, e.g. a SUM query requires the underlying data type to be number-based.

Here are some of the common data types supported by Holistics Data Imports.


bigintsigned eight-byte integer+/-9,223,372,036,854,775,807
integertypical choice for integer+/-2147483647
floatfloating-point number1.12345678912346
numericuser-specified precision, exactup to 131072 digits before the decimal point; up to 16383 digits after the decimal point
double precisionvariable-precision, inexact1.12345678912346
varcharvariable-length character stringVARCHAR(255) does not allow inserting a string more than 255 characters long
textlarger variable-length character stringtext data upper limit at 1 Gb
datecalendar date (year, month, day)1999-01-08
timestampdate and time, time zone'2004-10-19 10:23:54+02'
jsontextual JSON data
jsonbbinary JSON data, decomposed