# Joining datasets with RLS

**URL:** <https://community.amazonquick.com/t/joining-datasets-with-rls/30951>\
**Category:** Q&A\
**Tags:** feature-request, row-level-security, developer, quick-sight\
**Created:** [June 5, 2024, 10:15am UTC](https://community.amazonquick.com/t/joining-datasets-with-rls/30951 "2024-06-05T10:15:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sanskari\_lad](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@sanskari\_lad](https://community.amazonquick.com/u/sanskari_lad)\
**Post date:** [June 5, 2024, 10:15am UTC](https://community.amazonquick.com/t/joining-datasets-with-rls/30951/1 "2024-06-05T10:15:13Z")

</div>

Hello,

I’m getting following error when trying to left-join two datasets with the RLS rules applied to each.

```auto
Joining tables from different sources requires SPICE, which this dataset isn't permitted to use. To continue, you'll need to remove the join.

```

But I’m also able to see the joined datasets, just not able to publish it.

Would appreciate some help on this one.

---

<div class="post-metadata">

**Author:** ![Koushik\_Muthanna](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/koushik_muthanna/32/3290_2.png) [@Koushik\_Muthanna](https://community.amazonquick.com/u/Koushik_Muthanna)\
**Post date:** [June 5, 2024, 12:56pm UTC](https://community.amazonquick.com/t/joining-datasets-with-rls/30951/2 "2024-06-05T12:56:35Z")

</div>

@sanskari_lad ,

Yes this is not possible. You would have first join and then apply RLS on the final dataset.

Kind regards,  
Koushik

---

<div class="post-metadata">

**Author:** ![sanskari\_lad](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@sanskari\_lad](https://community.amazonquick.com/u/sanskari_lad)\
**Post date:** [June 5, 2024, 11:14pm UTC](https://community.amazonquick.com/t/joining-datasets-with-rls/30951/3 "2024-06-05T23:14:40Z")

</div>

Hi @Koushik_Muthanna  
Thanks for your response.

I think then applying a RLS on top of a dataset is also making it no-longer extensible.  
It would be a good feature to have though for our case we were able to find a work around.

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 7, 2024, 2:19am UTC](https://community.amazonquick.com/t/joining-datasets-with-rls/30951/4 "2024-06-07T02:19:36Z")

</div>

Hi @sanskari_lad, sorry, currently this is not possible but it’s on feature request. At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request. More features are being added on a regular basis, so please keep an eye on the [What’s New / Blog](https://community.amazonquick.com/c/announcements/). You can set up a Watching Alert by clicking on the bell icon.

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 7, 2024, 2:19am UTC](https://community.amazonquick.com/t/joining-datasets-with-rls/30951/5 "2024-06-07T02:19:59Z")

</div>