Hi Everyone, How can I keep my dataset from automatically switching to use the SPICE engine? I work with large datasets (10+million) records and I want my redshift cluster to perform the queries instead of the SPICE engine. Thanks in advance

What do you mean automatically? How are you creating these? If you are doing it via the console you can click on direct query. [image]

Thanks @Max … Yes when you created the data set, you can change the query mode. As always @Max the solutions are really useful. Regards - San

@ROBERT_J_ESTEVES : Do we have used any custom sql as part of the data set? If yes, we observed the same issue and raise a post for the same as well. I am awaiting response from the community, planning to raise a ticket to AWS product team soon. For now, please check whether custom sql have been us…

Thanks @Sanjeeb2022 . I look forward to an answer soon.

Thanks @ROBERT_J_ESTEVES . Hopefully this will be a feature request for Quicksight down the line and we will wait. For now, you can marked the view approach as solution. Regards - San

Hi @ROBERT_J_ESTEVES , Please look at the details in the below post and then compare the scenario at your end. [image] Importing data into spice for a dashboard currently using direct query Question & Answer If the data is coming from the same source , for eg : Athena, a…

Thanks @Koushik_Muthanna . You are correct, I can see custom sql with nomal database, we can see SPICE now. Any recent changes. @Biswajit_1993 - Can you check this as well. Now if we have a custom sql data set and normal data set, the result can be stored in Direct Query. See the screenshot below. …

Thanks for taking the time to answer my question @Koushik_Muthanna , based on your diagram I should be able to use direct query, because all my data sources come from Redshift (dimensions and Fact). [image] Yet. this is what I see in Quicksight. [image]

Thanks @ROBERT_J_ESTEVES . If you see my comment case -1, this is what I exactly put… Thanks for detail information. Regards - San

I believe that Quick Sight considers your dataset 1 and dataset 2 as different sources even though the underlying source is the same for both of them. Each parent dataset used in your child dataset is treated as a data source. It’s what they refer to as “dataset-as-a-source”. Amazon Quick…

Direct Query vs. Spice Engine

Q&A

ROBERT_J_ESTEVES March 20, 2023, 8:25pm 4

Hi Max, When I add dimensions to my fact table. the model automatically switches to SPICE instead of remaining in DIRECT mode. See the attached image.
spice_mode_only

Topic		Replies	Views
Quick Sight Direct Query vs SPICE Q&A data-source , quick-sight	1	550	May 18, 2023
Regarding the quick sight Q&A data-source , quick-sight	4	227	July 14, 2023
Change dataset from Spice to Direct Q&A spice , direct-query , quick-sight	7	2469	January 17, 2023
Joining direct query dataset to SPICE dataset Q&A quick-sight , qls-basic-calc	1	623	February 8, 2023
When I am trying to join two Data Sets then the data is automatically move to SPICE instead of Direct Query? Q&A data-source , quick-sight	4	982	December 6, 2022

Direct Query vs. Spice Engine

Related topics