Query (create a new dataset) on an existing RLS implemented dataset on Quicksight

Q&A
,
1

Hi,

I have a RLS implemted dataset on quicksight. I want to show user ‘rls implemented data / analysis’ vs ‘non-rls implemented data/analysis’. The only way I can think of is to create a new data set and then left join with a RLS implemented data set. So that I have the before and after RLS data.

  1. is it possiable to query directlty on a dataset that is created in quicksight? How to do that?
  2. Will the previous RLS still working?

Thanks in advance!

2
  1. No it’s not possible to run a query on a dataset. You can use quicksight to create joins from existing datasets. But you can’t say like SELECT * FROM dataset.
  2. It should work.

My question to you is why do you need to join it?

Can you just make a separate dataset without RLS and run analytics on two separate datasets?

Then you can create visuals side by side.

1 Like