Class DatePartitionProjectionConfigurationProps

(experimental) Properties for DATE partition projection configuration.

Inheritance

object

DatePartitionProjectionConfigurationProps

Implements

IDatePartitionProjectionConfigurationProps

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Namespace: Amazon.CDK.AWS.Glue.Alpha

Assembly: Amazon.CDK.AWS.Glue.Alpha.dll

Syntax (csharp)

public class DatePartitionProjectionConfigurationProps : IDatePartitionProjectionConfigurationProps

Syntax (vb)

Public Class DatePartitionProjectionConfigurationProps Implements IDatePartitionProjectionConfigurationProps

Remarks

Stability: Experimental

ExampleMetadata: infused

Examples

Database myDatabase;

             new S3Table(this, "MyTable", new S3TableProps {
                 Database = myDatabase,
                 Columns = new [] { new Column {
                     Name = "data",
                     Type = Schema.STRING
                 } },
                 PartitionKeys = new [] { new Column {
                     Name = "date",
                     Type = Schema.STRING
                 } },
                 DataFormat = DataFormat.JSON,
                 PartitionProjection = new Dictionary<string, PartitionProjectionConfiguration> {
                     { "date", PartitionProjectionConfiguration.Date(new DatePartitionProjectionConfigurationProps {
                         Min = "2020-01-01",
                         Max = "2023-12-31",
                         Format = "yyyy-MM-dd",
                         Interval = 1,  // optional, defaults to 1
                         IntervalUnit = DateIntervalUnit.DAYS
                     }) }
                 }
             });

Synopsis

Constructors

DatePartitionProjectionConfigurationProps()

(experimental) Properties for DATE partition projection configuration.

Properties

Format	(experimental) Date format for partition values.
Interval	(experimental) Interval between partition values.
IntervalUnit	(experimental) Unit for the interval.
Max	(experimental) End date for the partition range (inclusive).
Min	(experimental) Start date for the partition range (inclusive).

Constructors

DatePartitionProjectionConfigurationProps()

(experimental) Properties for DATE partition projection configuration.

public DatePartitionProjectionConfigurationProps()

Remarks

Stability: Experimental

ExampleMetadata: infused

Examples

Database myDatabase;

             new S3Table(this, "MyTable", new S3TableProps {
                 Database = myDatabase,
                 Columns = new [] { new Column {
                     Name = "data",
                     Type = Schema.STRING
                 } },
                 PartitionKeys = new [] { new Column {
                     Name = "date",
                     Type = Schema.STRING
                 } },
                 DataFormat = DataFormat.JSON,
                 PartitionProjection = new Dictionary<string, PartitionProjectionConfiguration> {
                     { "date", PartitionProjectionConfiguration.Date(new DatePartitionProjectionConfigurationProps {
                         Min = "2020-01-01",
                         Max = "2023-12-31",
                         Format = "yyyy-MM-dd",
                         Interval = 1,  // optional, defaults to 1
                         IntervalUnit = DateIntervalUnit.DAYS
                     }) }
                 }
             });

Properties

Format

(experimental) Date format for partition values.

public string Format { get; set; }

Property Value

string

Remarks

Uses Java SimpleDateFormat patterns.

Stability: Experimental

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

Interval

(experimental) Interval between partition values.

public double? Interval { get; set; }

Property Value

double?

Remarks

Required (together with intervalUnit) when format carries sub-day precision — i.e. a field finer than a day, such as hours or AM/PM. At day or coarser precision Athena defaults the step, so it is optional.

Default: - Athena's default step for the format's precision; required when format is sub-day precision

Stability: Experimental

IntervalUnit

(experimental) Unit for the interval.

public DateIntervalUnit? IntervalUnit { get; set; }

Property Value

DateIntervalUnit?

Remarks

Required (together with interval) when format carries sub-day precision — i.e. a field finer than a day, such as hours or AM/PM. At day or coarser precision Athena defaults the step, so it is optional.

Default: - Athena's default unit for the format's precision; required when format is sub-day precision

Stability: Experimental