1

I am looking at a Data Lake csv file and want to create an external table in the serverless SQL Pool of Microsoft Synapse. The goal is to query this file with Row Level Security constraints in place.

When the external table is created on a dedicated Server, I am able to query the file with Row Level Security constraints in place.

How can I make the Row Level security for external tables on a serverless SQL Pool?

CHEEKATLAPRADEEP
  • 12,191
  • 1
  • 19
  • 42
Tim Rusche
  • 31
  • 3

2 Answers2

2

Unfortunately, row level-security is not supported in serverless SQL pool at the moment.

Can you please vote for this on our User Voice? https://feedback.azure.com/forums/307516-sql-data-warehouse?category_id=171048

vvasic-MSFT
  • 219
  • 1
  • 2
1

You can't use the feature as it is. T-SQL support on Serverless is limited.

E.g. CREATE FUNCTION isn't supported.

This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

You could of course try to DIY using Views which are supported in Serverless.

  • In the figure below Entitlements would become another CSV and EXTERNAL TABLE that you would create.
  • You'll have to either find the right function to get current user and/or role for View's SELECT query, or provide it via some wrapper code from some other place where you maintain your own Context.

Disclaimer: I've not done this in Serverless so can't say for sure.

enter image description here

Kashyap
  • 15,354
  • 13
  • 64
  • 103