enum StorageParameters
Language | Type name |
---|---|
![]() | Amazon.CDK.AWS.Glue.Alpha.StorageParameters |
![]() | github.com/aws/aws-cdk-go/awscdkgluealpha/v2#StorageParameters |
![]() | software.amazon.awscdk.services.glue.alpha.StorageParameters |
![]() | aws_cdk.aws_glue_alpha.StorageParameters |
![]() | @aws-cdk/aws-glue-alpha ยป StorageParameters |
The storage parameter keys that are currently known, this list is not exhaustive and other keys may be used.
Example
declare const glueDatabase: glue.IDatabase;
const table = new glue.Table(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
Name | 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. |
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.
This value overrides the compression type specified through the 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.
By default, Redshift Spectrum sets the value to null for data that exceeds the width of the column.
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.
By default, Redshift Spectrum sets the value to null for data that exceeds the width of the column.
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.
This property is only available for an uncompressed text file format.
NUM_ROWS
A property that sets the numRows value for the table definition.
To explicitly update an external table's statistics, set the numRows property to indicate the size of the table. Amazon Redshift doesn't analyze external tables to generate the table statistics that the query optimizer uses to generate a query plan. If table statistics aren't set for an external table, Amazon Redshift generates a query execution plan based on an assumption that external tables are the larger tables and local tables are the smaller tables.
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.
This property is ignored for other data formats.
WRITE_PARALLEL
A property that sets whether CREATE EXTERNAL TABLE AS should write data in parallel.
When 'write.parallel' is set to off, CREATE EXTERNAL TABLE AS writes to one or more data files serially onto Amazon S3. This table property also applies to any subsequent INSERT statement into the same external table.
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.
The size must be a valid integer between 5 and 6200. The default maximum file size is 6,200 MB. This table property also applies to any subsequent INSERT statement into the same external table.
WRITE_KMS_KEY_ID
You can specify an AWS Key Management Service key to enable ServerโSide Encryption (SSE) for Amazon S3 objects.