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?


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2016-12-15

Updated: 2018-10-30