Create a view in AWS Athena by merging two SQL queries using Union All

Today we will lean on how to create a view in AWS Athena by merging multiple queries result in one query

To merge multiple queries in Athena, we will be creating a view in Athena by using:

• With common table expression (CTE) to hold the result of each query in a separate temp table
• Union ALL to merge multiple queries results
• To use Union keyword, both queries should return exact same columns

• Once the view is created, run the view to see the result of two queries merged into one view