Data types

The data for each column of your dataset are converted to one of the following data types:

• byte – 1-byte signed integer numbers. The range of numbers is from -128 to 127.

• short – 2-byte signed integer numbers. The range of numbers is from -32768 to 32767.

• integer – 4-byte signed integer numbers. The range of numbers is from -2147483648 to 2147483647.

• long – 8-byte signed integer numbers. The range of numbers is from -9223372036854775808 to 9223372036854775807.

• float – 4-byte single-precision floating point numbers.

• double – 8-byte double-precision floating point numbers.

• decimal – Signed decimal numbers with up to 38 digits total and 18 digits after the decimal point.

• string – Character string values.

• boolean – Boolean type has one of two possible values: `true` and `false` or `yes` and `no`.

• timestamp – Values comprising fields year, month, day, hour, minute, and second.

• date – Values comprising fields year, month and day.

Advanced data types

Advanced data types are data types that DataBrew detects within a string column in a project, and therefore are not part of a dataset. For information about advanced data types, see Advanced data types.