Skip to main content

S3ConnectionSettingsInput

The connection settings for an S3 Data Source. These include the S3 bucket name, the AWS access key ID, and the tables (along with their paths). We do not allow fetching the AWS secret access key after it has been set.

fields

  • awsAccessKeyId required String

    The AWS access key ID for an IAM user with sufficient access to the S3 bucket.

  • awsSecretAccessKey required String

    The AWS secret access key for an IAM user with sufficient access to the S3 bucket.

  • bucket required String

    The name of the S3 bucket.

  • tables required array of S3DataSourceTableInput

    The S3 Data Source's tables.

    The fields for specifying an S3 Data Source's table.

    • tables.name required String

      The name of the table

    • tables.path optional String

      The path to the table's files in S3.

    • tables.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.

      • tables.columns.name required String

        The column name. It has to be unique within a Table.

      • tables.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".

      • tables.columns.nullable required Boolean

        Whether the column's type is nullable or not.