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?

Short Description

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?


Did this article help you?

Anything we could improve?

Need more help?