Data types - AWS Glue DataBrew

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 in Creating and using AWS Glue DataBrew projects.