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.