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.