Which security features supported by Synapse SQL pool and Spark pool

pmscorca 1,007

Hi,

I'm searching a summary matrix that reports the all security features supported by the Synapse dedicated SQL pool, the serverless SQL pool and the Spark pool.

I've already read several articles about this subject.

F.e. are the access keys supported? and the SASs?

Following this article Choose an authentication method in Azure Synapse serverless SQL pools, it seems that the serverless SQL pool supports the SAS authentication.

Any helps to me, please? Thanks

AnnuKumari-MSFT 33,476 Reputation points Microsoft Employee

2024-08-26T10:40:09.7666667+00:00

Hi pmscorca ,

Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

1 answer

Vinodh247 23,671 Reputation points MVP

2024-08-03T10:18:31.29+00:00

Hi pmscorca,

Thanks for reaching out to Microsoft Q&A.

Does the below answer your question? let me know if you need more information.

additional info:

https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-network-security

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.
Please sign in to rate this answer.
pmscorca 1,007 Reputation points

2024-08-03T13:06:55.9533333+00:00

Hi, many thanks for your reply.

Also I've tried tried to make a such matrix.

You report that the serverless SQL pool doesn't support the auditing feature, but I can see this

You say that the serverless SQL pool supports the row level security, but I can read this

You don't talk about the access keys, the object level security (ols), the column level security (cls) and the managed vnet.

Thanks

Vinodh247 23,671 Reputation points MVP

2024-08-04T14:08:32.82+00:00

yes, you are right. i believe there was some new updates to the documentation.

ols:

https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-access-control#object-level-security

cls:

https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-access-control#column-level-security

managed vnet:

https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-network-security#managed-vnet

auditing:

https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-threat-protection#auditing
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Which security features supported by Synapse SQL pool and Spark pool

1 answer

Your answer