Forum Discussion
Working with big datasets.
Hi I need to create a new report and use incremental refresh in the future. For that I can not use custom SQL while pulling data from data warehouse because then incremental refresh will not work...
Just create a sql view and select it like you would a table. Then incremental works just fine and can query fold succesfully.
If I create a view with a WHERE condition going back to almost a year doesn't that mean it still has to go through that same query that I am trying to avoid? This query takes too much time and resources on the data warehouse.