1 Risposta
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
0
CREATE TABLE AS does not update the underlying data. https://docs.aws.amazon.com/athena/latest/ug/create-table-as.html
Instead try CREATE VIEW and the VIEW would be updated as the underlying data in the TABLE is updated. https://docs.aws.amazon.com/athena/latest/ug/create-view.html
con risposta un anno fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
Thank you ananthtm!
For instance, to make my previous query work, I should replace "CREATE TABLE" with "CREATE OR REPLACE VIEW"?
yes, using "CREATE OR REPLACE VIEW" should address your question. Please upvote and/or accept answer so that it helps everyone in this forum