Forum Discussion
Errors enabling Native Query / Query Folding for Snowflake queries
Just because View Native Query is greyed out, it doesn't mean your query isn't folding. You can confirm by looking at the query hitting Snowflake, or just do a simple experiment. Try refreshing your preview or loading a small amount of data with a narrow filter (e.g., one day, one dimension value) and confirm it loads quickly. With Snowflake, if your query is simple filters, select columns, etc., it should fold (do those steps first if you also need to do more complex transforms that may not fold.
Pat
Why are you using Value.NativeQuery? You should be able to just choose that view, perform any filtering/column selection steps, etc. and it should fold back to your source.
Pat
Hi ppm1 I am trying to set up Incremental Refresh. From what I've read, in order to do so, this option "View Native Query" has to be active. In order to do that, I need to insert the Value.NativeQuery step earlier in the Applied Steps.
Just because View Native Query is greyed out, it doesn't mean your query isn't folding. You can confirm by looking at the query hitting Snowflake, or just do a simple experiment. Try refreshing your preview or loading a small amount of data with a narrow filter (e.g., one day, one dimension value) and confirm it loads quickly. With Snowflake, if your query is simple filters, select columns, etc., it should fold (do those steps first if you also need to do more complex transforms that may not fold.
Pat