Context Queries in Athena

What are Context Queries in Athena and how can I use them to refine my search results?

Hello, @manojkumar.rajendran. Contextual queries refer to queries that can be posed using information from previous queries without explicitly mentioning that information. For instance, if you had previously asked a query about the revenue for 2020, you could ask Athena to display the preceding data by month or customer without having to mention the previous query. You can use phrases like “Show it to me by month” or “Show it to me by customer” to make the query. Kindly refer to the attached screenshot for more information.