# StorageParameters

The storage parameter keys that are currently known, this list is not exhaustive and other keys may be used.

- Source: [`lib/storage-parameter.ts`](https://github.com/aws/aws-cdk/blob/v2.274.0-alpha.0/packages/@aws-cdk/aws-glue-alpha/lib/storage-parameter.ts#L217)
- Type last changed: v2.270.0-alpha.0 · 18 Sep 2026

## 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. |