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?
Resolution
For more information, see Examples of CTAS Queries.
Related Information
Did this article help you?
Anything we could improve?
Need more help?