aws_cdk_glue_alpha_database_s3_table_with_partitions.py

1import aws_cdk as cdk
2from aws_cdk import aws_s3 as s3
3import aws_cdk.aws_glue_alpha as glue
4
5app = cdk.App()
6stack = cdk.Stack(app, "GlueStack")
7
8# Create a Glue Database
9database = glue.Database(stack, "MyDatabase",
10    database_name="my_database"
11)
12
13# Create a Glue Table with a schema
14table = glue.S3Table(stack, "MyTable",
15    database=database,
16    table_name="my_table",
17    columns=[glue.Column(
18        name="col1",
19        type=glue.Schema.STRING
20    ), glue.Column(
21        name="col2",
22        type=glue.Schema.INTEGER,
23        comment="col2 is an integer"
24    )],
25    partition_keys=[glue.Column(
26        name="year",
27        type=glue.Schema.SMALL_INT
28    ), glue.Column(
29        name="month",
30        type=glue.Schema.SMALL_INT
31    )],
32    data_format=glue.DataFormat.JSON,
33    bucket=s3.Bucket(stack, "TableBucket"),
34    s3_prefix="my-table-data/"
35)