1 個回答
- 最新
- 最多得票
- 最多評論
0
Views are tables with some additional properties on glue catalog.
So, you can create a glue table informing the properties: view_expanded_text
and view_original_text
. This tables will be executed as a view on Athena.
More details on https://docs.aws.amazon.com/cdk/api/v1/python/aws_cdk.aws_glue/CfnTable.html#tableinputproperty
已回答 2 年前
相關內容
- AWS 官方已更新 1 年前
- AWS 官方已更新 1 年前
Please not that the text to be used in the 2 parameter needs to follow some rule, for example view_original_text must contain an encoded Presto view , you can look at this stackoverflow answer for further information https://stackoverflow.com/questions/56289272/create-aws-athena-view-programmatically
Thanks for this! One concern : I want to create the view from an existing CDK generated glue table(which is populated by a Glue Crawler). Let's say I add a column to the source glue table(ie, its schema changes), can there be a stale view issue(since I read that glue tables are created parallely). What sort of 'stale view' cases like this should I look out for?