Forum Discussion
Query folding in Snowflake DirectQuery is failing
Hi Anonymous ,
Are you using a native database query when connecting to Snowflake, and if so, there are some limitation on query folding:
Query folding while using a native database query is limited to the PostgreSQL connector only. No other connectors support query folding if you use a native database query. Also, for folding to work in the PostgreSQL connector, the native database query you enter has to work as a subquery.
Also, in this case below, it is mentioned that query folding does not work if there are arrays involved in the data source query.
Does Snowflake support query folding when used as a data source by Power BI?
Power BI Incremental Refresh with Snowflake
Best Regards
Anonymous In Power Query Editor, right-click each step of the query and see when View Native Query gets greyed out. That is the step that is negating query folding.
Greg_Deckler "View native query" is not supported with Snowflake. Even if query folding is working, this feature is always greyed out.
Anonymous Well then you answered your own question? View native query is present when query folding is occurring so if Snowflake doesn't support view native query then it doesn't support query folding...yes?
No...
if "View Native Query" is enabled, then query folding is working.
If "View Native Query" is disabled then you cannot draw any conclusions.