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년 전
관련 콘텐츠
- 질문됨 7달 전
- AWS 공식업데이트됨 일 년 전
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?