Direct Query mode is converted to SPICE mode after joining of 2 Athena tables

Question & Answer
, , , ,
1

Hi QS Team,
I have 3 datasets - connect to Athena ( 3 tables A, B, C ) are in Direct Query Mode in Quicksight.

C is a independent table - have used alone for the visualization purpose.

But for some of the visual i have to join A & B datasets.

I joined A ( main table - left join ) with B table Dimension table
then created a Joined Dataset with SPICE mode ( Why it can’t be a Direct Query mode ).

2

@Venkat.Metadata

I have highlighted here when the resulting dataset is SPICE or Direct Query ( Importing data into spice for a dashboard currently using direct query - #4 by Koushik_Muthanna )

Kind regards,
Koushik

3

Hi @Venkat.Metadata,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!