Store Amazon Athena Query Results into new Table

I need to store Amazon Athena query results into New Amazon Athena Table.

Solution

Recently they have added Create Table as CTAS support to Athena.

boto3 check if Athena database exists
Store Amazon Athena Query Results into new Table
SQL - Replace column values with another table column ONLY where they match, else keep original value?
How to create an array by replacing values from another array?
Athena JDBC Driver 2.0.7 in maven repo?
Using Athena to get terminatingrule from rulegrouplist in AWS WAF logs
How to authenticate using Python Boto3 Library to AWS Secret Manager and AWS Athena Python on two different accounts
AccessDenied on AWS Athena
How can I query attributes with struck array data type?
How to query an multi-AWS Athena databases in a single query from Lambda function using python?
Different results, when using FILTER WHERE vs. WHERE in AWS Athena
Set True to duplicate records that occur within 1 hour window
Athena/iceberg MERGE INTO not applying both DELETE and UPDATE on the same key
Can AWS Athena DynamoDB Connector not able to scan DynamoDB tables with Upper Case letters in their name?
How to duplicate same row X number of times based on the value of a column?
How to rename a table in Athena?
Athena unable to parse date using OpenCSVSerde
Preserve columns names case in Parquet produced by UNLOAD
How can I add conditions in athena view definition in order to modify column values?
`lag()` with `over` and `range between` returns a value if even the previous record is out of range
AWS Athena: Right function
Querying HTML Content in Common Crawl Dataset Using Amazon Athena
Amazon Athena CREATE EXTERNAL TABLE mismatched input 'external' invalidrequestexception
How to calculate an array of differences from an original array?
Proper Case in Athena SQL
Converting Date Timestamp from UTC to EST without the Timezone in Athena
Creating Glue table with serverless.yaml gives 'Table name must not contain uppercase characters' error even if name is in lower case
Is it possible to add fields to struct in an existing AWS Athena table?
How to lag using dynamic offset in SQL AWS Athena?
AWS Athena with python - is it possible to mock with moto while still testing the sql?