1 Risposta
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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
con risposta 2 anni fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 3 anni fa
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?