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.
Campaign#
| DATA TYPE | DESC. | EXAMPLE/NOTES |
|---|---|---|
| bigint | signed eight-byte integer | +/-9,223,372,036,854,775,807 |
| integer | typical choice for integer | +/-2147483647 |
| float | floating-point number | 1.12345678912346 |
| numeric | user-specified precision, exact | up to 131072 digits before the decimal point; up to 16383 digits after the decimal point |
| double precision | variable-precision, inexact | 1.12345678912346 |
| varchar | variable-length character string | VARCHAR(255) does not allow inserting a string more than 255 characters long |
| text | larger variable-length character string | text data upper limit at 1 Gb |
| date | calendar date (year, month, day) | 1999-01-08 |
| timestamp | date and time, time zone | '2004-10-19 10:23:54+02' |
| json | textual JSON data | |
| jsonb | binary JSON data, decomposed |