How do I use the results of my Amazon Athena query in another query?
Last updated: 2018-10-30
I ran a query using Amazon Athena. Now I want to use the results of that first query to perform a second query. How do I do that?
Athena supports CREATE TABLE AS SELECT (CTAS) queries. A CTAS query creates a new table from the results of a SELECT statement from another query. For information about retrieving the results of a previous query, see How can I access and download the results from an Amazon Athena query?
For more information, see Examples of CTAS Queries.