Hi team,
Hi team,
Is there a way to get row level security to apply only on the right side of an left outer join? Right now it seems to apply in the where clause effectively making it an inner join.
Example use case:
I have a table Products (with a list of products available to many stores). I have a table ProductSalesByStore with the total sales $ by store for each product they sell. I have RLS on ProductSalesByStore so only users belonging to that store can see their sales. My goal is to allow them access to a worksheet where they can see all fields in Product for all products but also have the column from ProductSalesByStore that displays their sales volume for the products they've sold (would be null in many cases since they don't sell all products).
Right now my workaround would be to join the two tables outside of ThoughtSpot and create a record for every Product for every store (which is a large duplication of data and doesn't allow me to leverage the existing Product worksheet well (duplication of worksheets)).
4 Replies
Can you create a support ticket for this, we will get the relevant team to help you with this request.
Hi @shikharTS , I created a case (case no 00373260). I'm still waiting on a response beyond looking into it
Hi @joel that is a different team that will respond there. cc @sainadh
I appreciate that. Thank you for the direction and clarification.