How do I use the results of my Amazon Athena query in another query?

Issue

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 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