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

  1. Review the Considerations and Limitations for CTAS Queries.
  2. Create a CTAS query from another query.

For more information, see Examples of CTAS Queries.

Views

Limitations

Did this article help you?

Yes
No

Anything we could improve?

Let us know

Need more help?

Contact AWS Support