Duplication is unsupported for datasets with row level security configured

Question & Answer
,
1

It appears to be impossible to duplicate a data set with RLS.

I see the following tooltip:

Duplication is unsupported for datasets with row level security configured.

This seems like a really strange, and backward limitation.

This will certainly cause an unaware user to disable the RLS to duplicate a dataset.

But also, in general, why would that even be a limitation?

Any known workarounds?

1 Like
2

Also, on top of that, I am getting this error on a dataset where RLS is NOT configured.

image
image3230×1232 261 KB

4

I also don’t understand why this is a limitation but as a workaround you can use the API to create the duplicate. It works even if RLS is applied to the original dataset.

2 Likes
5

Thanks @David_Wong. So duplicate date set can be created with RLS via API not via UI?

Hi @Koushik_Muthanna - Any advise on this.

Regards - Sanjeeb

6

Yes, that’s what we’ve done.

But now it requires an engineer to do this duplication, whereas an analyst should be able to do this on their own to test changes and make development-grade datasets before they get integrated by engineering.

2 Likes
7

@Sanjeeb2022

Yes, you can use DescribeDataset on the original dataset and copy the dataset definition which includes the RLS configuration. Then, use CreateDataset and paste the dataset definition from the original to create the duplicate.

2 Likes
8

Sadly appears to be also not possible :frowning: