cdk-athena 2.1.0

CDK Construct for creating Athena resources

CDK Athena WorkGroup

AWS CDK L3 construct for managing Athena WorkGroups and named queries.

Because I couldn't get @aws-cdk/aws-athena.CfnWorkGroup to work and @aws-cdk/custom-resources.AwsCustomResource has no support for tags.

# Example automatically generated without compilation. See https://github.com/aws/jsii/issues/826
workgroup = WorkGroup(self, "WorkGroup",
    name="TheName", # required
    desc="Some description",
    publish_cloud_watch_metrics_enabled=True,
    enforce_work_group_configuration=True,
    requester_pays_enabled=True,
    bytes_scanned_cutoff_per_query=11000000,
    result_configuration={
        "output_location": "s3://some-bucket/prefix",
        "encryption_configuration": {
            "encryption_option": EncryptionOption.SSE_S3
        }
    }
)

query = NamedQuery(self, "a-query",
    name="A Test Query",
    database="audit",
    desc="This is the description",
    query_string="""
        SELECT
          count(*) AS assumed,
          split(useridentity.principalid, ':')[2] AS user,
          resources[1].arn AS role
        FROM cloudtrail_logs
        WHERE
          eventname='AssumeRole' AND
          useridentity.principalid is NOT NULL AND
          useridentity.principalid LIKE '%@%'
        GROUP BY
          split(useridentity.principalid,':')[2],
          resources[1].arn
      """,
    work_group=workgroup
)

cdk.Tag.add(workgroup, "HelloTag", "ok")

cdk.CfnOutput(self, "WorkGroupArn",
    value=workgroup.arn
)

cdk.CfnOutput(self, "WorkGroupName",
    value=workgroup.name
)

cdk.CfnOutput(self, "QueryId",
    value=query.id
)