Direct query on QS dataset

If a dataset is created in direct query mode, will it hit the redshift cluster all the time its used in an analysis?

Hi @gasowmya
my expectation would be yes. As you would like to have the most actual data all the time.

1 Like

Is it possible to create a dataset and do a timely update from redshift on a specific timings

Would be a SPICE dataset with scheduled updates.

Looks like spice dataset has a limitation of 1B records and my original data has more than that since we do a lot of YoY comparison. Is there a way to increase the SPICE data limit

So far there is no option to increase the limit.
Any chance to decrease your data?