I get an error message when trying to join two different types of datasets. Admins have no problem, but I get this after I choose the fields to join on and click Apply. And both datasets are SPICE. [image]

Hi @durl When joining two datasets together from different sources it will default to SPICE and should allow you to do the join. Regardless of if they are datasets or other datasources. I wonder if this is a permissions issue. Are you able to create a simple dataset using spice? Thanks, Ramon …

Thanks for the reply. Like you, I’m thinking it’s a permissions issue. An Admin can do the join, but I get the error. I’m having them check with other Users (non-admin) at the main office to see if they encounter the same problem. I can create a simple database using SPICE, yes.

Hi drul, You are encountering this error as mixing data from two datasets (from different sources) requires that the child dataset be in SPICE mode. There is a permission setting in parent datasets which controls whether SPICE copies are allowed or not. Please check / ask owners of parent datasets …

Thank you for the reply. They looked and Allow SPICE copies is checked but the error about requiring SPICE to join is still there. There’s a Redshift dataset (SPICE, with row-level security) I’m attempting to join to, but when attempt to use it for a new dataset, the Query Mode is locked at Direct. …

Have you looked into this? [image] Joined dataset with RLS Question & Answer Hi Max, both on SPICE before applying RLS. I think the RLS change the query mode to direct query. if it possible, I would like to avoid change in the dataset or analysis because it takes a lot…

I’m going to pass this along and see if RLS was applied before SPICE. Thank you.

Join Error

Q&A

Max March 8, 2023, 7:21pm 6

Have you looked into this?

Topic		Replies	Views
Joining two SPICE datasets not allowed Q&A data-source , spice , quick-sight	3	1443	March 31, 2023
Joined dataset with RLS Q&A row-level-security , quick-sight	5	1020	January 19, 2023
Facing issues with Join between two datasets? Q&A data-source , quick-sight , calculations	3	1348	August 19, 2022
Child dataset of RLS-enabled SPICE dataset fixed to Direct Query mode Q&A quick-sight , dataset , Business-Intelligence-Engineer , qls-RlsCls	5	99	October 18, 2024
Invalid_dataprep_syntax Q&A error , quick-sight , dataset	5	554	June 14, 2023

Join Error

Related topics