1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
Hi ,
A View in SQL is a logical object and by design is ephemeral.
If the customer requirements is to have a persistent copy of the view they should use a CTAS.
If their goal is actually to save the query result (running on that view or even on a table) they can follow the instructions in this documents (to backup the full view they could run a Select * from View):
https://aws.amazon.com/premiumsupport/knowledge-center/access-download-athena-query-results/
https://docs.aws.amazon.com/athena/latest/ug/querying.html#query-results-specify-location
hope this helps
관련 콘텐츠
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 2년 전