StorageParameters Enum
The storage parameter keys that are currently known, this list is not exhaustive and other keys may be used.
Example
ts
declare const glueDatabase: glue.IDatabase;
const table = new glue.S3Table(this, 'Table', {
storageParameters: [
glue.StorageParameter.skipHeaderLineCount(1),
glue.StorageParameter.compressionType(glue.CompressionType.GZIP),
glue.StorageParameter.custom('foo', 'bar'), // Will have no effect
glue.StorageParameter.custom('separatorChar', ','), // Will describe the separator char used in the data
glue.StorageParameter.custom(glue.StorageParameters.WRITE_PARALLEL, 'off'),
],
// ...
database: glueDatabase,
columns: [{
name: 'col1',
type: glue.Schema.STRING,
}],
dataFormat: glue.DataFormat.CSV,
});
Members
| Member | Description |
|---|---|
SKIP_HEADER_LINE_COUNT | The number of rows to skip at the top of a CSV file when the table is being created. |
DATA_CLEANSING_ENABLED | Determines whether data handling is on for the table. |
COMPRESSION_TYPE | The type of compression used on the table, when the file name does not contain an extension. |
INVALID_CHAR_HANDLING | Specifies the action to perform when query results contain invalid UTF-8 character values. |
REPLACEMENT_CHAR | Specifies the replacement character to use when you set INVALID_CHAR_HANDLING to REPLACE. |
NUMERIC_OVERFLOW_HANDLING | Specifies the action to perform when ORC data contains an integer (for example, BIGINT or int64) that is larger than the column definition (for example, SMALLINT or int16). |
SURPLUS_BYTES_HANDLING | Specifies how to handle data being loaded that exceeds the length of the data type defined for columns containing VARBYTE data. |
SURPLUS_CHAR_HANDLING | Specifies how to handle data being loaded that exceeds the length of the data type defined for columns containing VARCHAR, CHAR, or string data. |
COLUMN_COUNT_MISMATCH_HANDLING | Identifies if the file contains less or more values for a row than the number of columns specified in the external table definition. |
NUM_ROWS | A property that sets the numRows value for the table definition. |
SERIALIZATION_NULL_FORMAT | A property that sets number of rows to skip at the beginning of each source file. |
ORC_SCHEMA_RESOLUTION | A property that sets the column mapping type for tables that use ORC data format. |
WRITE_PARALLEL | A property that sets whether CREATE EXTERNAL TABLE AS should write data in parallel. |
WRITE_MAX_FILESIZE_MB | A property that sets the maximum size (in MB) of each file written to Amazon S3 by CREATE EXTERNAL TABLE AS. |
WRITE_KMS_KEY_ID | You can specify an AWS Key Management Service key to enable Server–Side Encryption (SSE) for Amazon S3 objects. |