S3DataSourceTableInput
The fields for specifying an S3 Data Source's table.
fields
name required String
The name of the table
path optional String
The path to the table's files in S3.
columns required array of S3DataSourceColumnInput
All the columns present in the table
The fields for specifying a column in an S3 Data Source's table.
columns.name required String
The column name. It has to be unique within a Table.
columns.type required ColumnType
The column type.
The Propel data types.
BOOLEAN
True or false.
STRING
A variable-length string.
FLOAT
A 32-bit signed double-precision floating point number.
DOUBLE
A 64-bit signed double-precision floating point number.
INT8
An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.
INT16
A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.
INT32
A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.
INT64
A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.
DATE
A date without a timestamp. For example, "YYYY-MM-DD".
TIMESTAMP
A date with a timestamp. For example, "yyy-MM-dd HH:mm:ss".
JSON
A JavaScript Object Notation (JSON) document.
columns.nullable required Boolean
Whether the column's type is nullable or not.