Bypassing Row-Level Security (RLS) in Azure SQL Server for ADF Copy Activity

Hi everyone,

I'm encountering a challenge within an Azure Data Factory pipeline. I'm copying data from underlying base tables in Azure SQL Server that have Row-Level Security (RLS) implemented. Unfortunately, the copy activity appears to be honoring the RLS policies.

Is there a method to bypass RLS in Azure Data Factory during the copy operation specifically for Azure SQL Server? I've explored the copy activity settings but haven't found any RLS-specific options.

Any advice on how to achieve this or alternative strategies for copying data while RLS remains active on the Azure SQL Server tables would be extremely helpful.

Thanks,

Kashish