Birst Data Types

The Type column in Admin - Define Sources - Manage Sources shows the data type of each column in a data source.

You can change the data type of a column to another relevant data type in Birst. For example you can change a Date to a DateTime or Varchar, but not an Integer. See Defining Column Properties.

Birst uses the following data types.

Data Type	Description
Date	Range allowed for analyzing by date, the range of the built-in Time dimension: 1900-01-07 to 2050-12-31. The Time dimension's resolution is at the day level, not the hour level. Ranges allowed for dates not used for analyze-by-date calculations, and that are specific to the database used by the data store: Minimum: 0001-01-01 Minimum when MySQL is used: 1000-01-01 Maximum: 9999-12-31
DateTime	Same as Date, above, except when SQL Server is used. For SQL Server the minimum date in DateTime is 1753-01-01. The time ranges for DateTime are: 00:00:00.000 to 23:59:59.999
Integer	Range:-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
Float	Range:-1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308 (IEEE 754 double precision)
Number	Fixed precision and scale: 18,5 For version 5.23.0 and beyond: 38,15 The Number data type is not automatically assigned during the initial data upload Birst. Once a space is processed you can change it to Varchar but not to any other data type.
Varchar	0 to 2048 characters. The detected size of your data may exceed 2048 and be shown in Birst as the column size, however, the underlying database column used to store this data is set to a width of 2048.