How to create Athena View using CDK

0

I want to use this CREATE VIEW option in the Athena console to run a query which will create a View in the Glue Database. But I want to use CDK. My question is : What’s the easiest way to create an Athena View using monocdk, which will create a view in the Glue DataBase?

Seeing that creating CfnNamedQuery construct with the 'CREATE OR REPLACE VIEW' query will just create a Saved Query. So I’ll have to run it once via the console to actually create the view, which defeats the purpose. I’m fairly new to Athena and CDK, so would be great help if anyone can point me towards the right direction. Thanks!

(PS : Markdown for the embedding the picture doesn't seem to be working. The picture is a screenshot of the Athena console : https://tiny.amazon.com/1dzv084cv/drivcorpamazviewananpublScre)

posta 2 anni fa3814 visualizzazioni
1 Risposta
0
Risposta accettata

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

didone
con risposta 2 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?

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande