Forum Discussion

visheshjain's avatar
visheshjain
Impactful Individual
2 years ago

Query folding using AWS Athena

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 wor...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    visheshjain
    Impactful Individual
    2 years ago

    Hi Anonymous,

     

    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!