Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Query Folding through ODBC Snowflake

Hi,   I use ODBC connection in PBI to import data from Snowflake DB. To be clear I do not use the Snowflake connector. I use Get Data --> ODBC (which connects to my snowflake DSN).   When I'm imp...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Query folding is definitely supported if Snowflake connector is used. Since you are using ODBC connector, whether query folding is working or not can be checked in 2 places as far as Snowflake is concerned as View native query is greyed out

1. Go to Tools in Power Query invoked through Power BI - Start Diagnostics, refresh your preview and then Stop Diagnostics and check logs. Logs are simple to read and will tell you if Query folding is happening or not.

2. Query history in Snowflake

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for the quick response.

 

It indeed does look like query folding is not supported while trying to go through ODBC to connect to snowflake. Tried both of your ways and I'm not seeing anything which can support query folding. Was looking for confirmation and seems that this will do. Appreciate it.