Query folding using AWS Athena

[visheshjain]

Hello everyone,

I am using AWS Athena as a data source with an ODBC connector.

I tried using the Athena connector in PBI Desktop but it was not working and I'm not sure if query folding will work with Athena.

I want to enable incremental refresh but for the you need query folding to be working.

For some reason, query folding is not working once the table is loaded in PQ.

Please share if you have any information on how to enable query folding?

Thank you,
Vishesh Jain

[v-xuxinyi-msft]

Hi @visheshjain 

Based on your description, You are using the ODBC connector to connect to AWS Athena. Are you now trying to switch to the Amazon Athena connector?

Query folding supports SQL Server, Oracle, and data sources that support ODBC connectivity. Data sources without any query mechanism are not supported.

You can use View Native Query or Query Diagnostics to see if query folding has occurred.

The View Native Query option is only available for certain relational DB/SQL generation connectors. For example, it does not apply to OData-based connectors, even if there is folding happening on the backend. The Query Diagnostics feature is the best way to see if folding has occurred for non-SQL connectors.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[visheshjain]

Hi @v-xuxinyi-msft,

I wasn't trying to switch to the Athena connector, but if anyone can show me that how/if query folding is working with Athena as a source, I would not mind switching.

If anyone has any other option, apart from the one that I have mentioned, in which I can connect PBI Desktop and Service to AWS Athena, I am all ears.

Please let me know if you have a solution for this.

Thank you for responding!