How to disable SPICE for BigQuery dataset?

Question & Answer
, ,
1

I have a Dataset that uses table in BigQuery. The table is pretty big, about a billion rows, it is nicely partitioned and allows very fast queries via native BigQuery SQL.

Unfortunately, I can’t make QuickSight use DIRECT mode of queries. Instead, it automatically uses SPICE and there is no option to switch to DIRECT query. How can I do it?

There are no additional datasets used in this Dataset - one single BigQuery table.

2

Hi @Eugene
for me it looks like its not supported yet.

BR