Hello, I have a database that has around 50 million rows per month. This database is occupying almost 30Gb of data on SPICE. The intention is to bring 4 months of data, and this volume will increase a lot. When do you know if it is better to use direct query instead of SPICE? Thanks!

Direct Query or SPICE?

July December 18, 2023, 1:01pm 4

Hi ErikG

I have already reduced the columns. If I group the query, I don’t have the same scenario (according to the post Analytical query vs grouped query -> calculate field - #12 by ErikG).
So, I have nothing else to do…

Topic		Replies	Views
When dealing with a large dataset in Amazon Quick Sight, what is the best mode to use: SPICE mode or Direct Query? Q&A Business-Intelligence-Engineer	3	116	June 26, 2024
Questions about efficiency, costs and usage of Spice vs. Direct Query in Quick Sight Q&A admin , direct-query , billing , qls-spice-schedule-api	3	560	August 27, 2024
Can anyone explain Quicksight backend query mechanism with spice and without spice Q&A spice	3	780	May 15, 2023
Performance issues due to huge dataset Q&A data-source , analysis , Business-Intelligence-Engineer	4	49	July 12, 2024
Dataset parameters with SPICE Q&A developer , qls-spice-schedule-api	7	777	December 20, 2023