Is it Possible in Quicksight to get one table in direct query mode and another in SPICE Mode

In QS can we import fact table in direct query mode and all the dimension tables in SPICE mode. Is it Possible ?

Hi @achourey - If the fact and dimension tables are separate data sets, you can always set the mode. However the final model where you join fact and dimension, it has to be spice as one of the data set (dimension table ) is fact. You can give a small poc and try that.

Regards - Sanjeeb

1 Like