You can translate the question and the replies:

Query to AWS Athena

Do the Denodo query optimizations (aggregation pushdown etc) works with AWS Athena?
user
01-06-2020 08:56:53 -0400

1 Answer

Hi, As Amazon Athena is a [JDBC data source](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources) and also it has its own [database adapter](https://community.denodo.com/docs/html/browse/latest/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources#jdbc-adapters-included-in-the-denodo-platform), then the Execution Engine will perform optimizations based on the **scenario** and **types** of queries. However, the Execution Engine will optimize the queries only if the optimization is enabled in the Server Configuration of Virtual DataPort. Hence, I would make sure that I have enabled Queries optimization in the Server Configuration. You could refer to the [Queries Optimization](https://community.denodo.com/docs/html/browse/latest/vdp/administration/server_administration_-_configuring_the_server/queries_optimization/queries_optimization) section under the Virtual DataPort Administration Guide for more details. Also, I suggest you to refer the Knowledge Base (KB) article [Best Practices to Maximize Performance II: Configuring the Query Optimizer](https://community.denodo.com/kb/view/document/Best%20Practices%20to%20Maximize%20Performance%20II%3A%20Configuring%20the%20Query%20Optimizer?category=Best+Practices) which explains more about the Query Optimizer. Hope this helps!
Denodo Team
02-06-2020 08:04:38 -0400
You must sign in to add an answer. If you do not have an account, you can register here