DatePartitionProjectionConfigurationProps

class aws_cdk.aws_glue_alpha.DatePartitionProjectionConfigurationProps(*, format, max, min, interval=None, interval_unit=None)

Bases: object

(experimental) Properties for DATE partition projection configuration.

Parameters:

format (str) – (experimental) Date format for partition values. Uses Java SimpleDateFormat patterns.
max (str) – (experimental) End date for the partition range (inclusive). Can be either: - Fixed date in the format specified by format property - Relative date using NOW syntax Same format constraints as min.
min (str) – (experimental) Start date for the partition range (inclusive). Can be either: - Fixed date in the format specified by format property (e.g., ‘2020-01-01’ for format ‘yyyy-MM-dd’) - Relative date using NOW syntax (e.g., ‘NOW’, ‘NOW-3YEARS’, ‘NOW+1MONTH’)
interval (Union[int, float, None]) – (experimental) Interval between partition values. When the provided dates are at single-day or single-month precision, the interval is optional and defaults to 1 day or 1 month, respectively. Otherwise, interval is required. Default: - 1 for single-day or single-month precision, otherwise required
interval_unit (Optional[DateIntervalUnit]) – (experimental) Unit for the interval. When the provided dates are at single-day or single-month precision, the intervalUnit is optional and defaults to 1 day or 1 month, respectively. Otherwise, the intervalUnit is required. Default: - DAYS for single-day precision, MONTHS for single-month precision, otherwise required

Stability:

experimental

ExampleMetadata:

infused

Example:

# my_database: glue.Database

glue.S3Table(self, "MyTable",
    database=my_database,
    columns=[glue.Column(
        name="data",
        type=glue.Schema.STRING
    )],
    partition_keys=[glue.Column(
        name="date",
        type=glue.Schema.STRING
    )],
    data_format=glue.DataFormat.JSON,
    partition_projection={
        "date": glue.PartitionProjectionConfiguration.date(
            min="2020-01-01",
            max="2023-12-31",
            format="yyyy-MM-dd",
            interval=1,  # optional, defaults to 1
            interval_unit=glue.DateIntervalUnit.DAYS
        )
    }
)

Attributes

format

(experimental) Date format for partition values.

Uses Java SimpleDateFormat patterns.

See:: https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html
Stability:: experimental

interval

(experimental) Interval between partition values.

When the provided dates are at single-day or single-month precision, the interval is optional and defaults to 1 day or 1 month, respectively. Otherwise, interval is required.

Default:

1 for single-day or single-month precision, otherwise required

Stability:

experimental

interval_unit

(experimental) Unit for the interval.

When the provided dates are at single-day or single-month precision, the intervalUnit is optional and defaults to 1 day or 1 month, respectively. Otherwise, the intervalUnit is required.

Default:

DAYS for single-day precision, MONTHS for single-month precision, otherwise required

Stability:

experimental

max

(experimental) End date for the partition range (inclusive).

Can be either:

Fixed date in the format specified by format property
Relative date using NOW syntax

Same format constraints as min.

Stability:: experimental

min

(experimental) Start date for the partition range (inclusive).

Can be either:

Fixed date in the format specified by format property (e.g., ‘2020-01-01’ for format ‘yyyy-MM-dd’)
Relative date using NOW syntax (e.g., ‘NOW’, ‘NOW-3YEARS’, ‘NOW+1MONTH’)

See:: https://docs.aws.amazon.com/athena/latest/ug/partition-projection-supported-types.html#partition-projection-date-type
Stability:: experimental