Create a table from query results (CTAS) - Amazon Athena

A CREATE TABLE AS SELECT (CTAS) query in Athena allows you to create a new table from the results of a query in one step, without repeatedly querying raw data sets.