topic Re: Best Practice to use/implement SQL Persona using Azure Databricks in Data Engineering

Best Practice to use/implement SQL Persona using Azure Databricks

VJ3 — Wed, 17 Jan 2024 22:22:37 GMT

Hello,

I am looking for details of Security Controls to use/implement SQL Persona using Azure Databricks.

Re: Best Practice to use/implement SQL Persona using Azure Databricks

Debayan — Thu, 18 Jan 2024 19:21:22 GMT

Hi, Is this the one you are mentioning about: https://www.databricks.com/discover/pages/access-control , thanks!

Re: Best Practice to use/implement SQL Persona using Azure Databricks

VJ3 — Thu, 18 Jan 2024 19:26:29 GMT

Hello Debayan, Thank you for the link. I am looking for Best practices in terms of security controls need to apply to prevent data exfiltration, data encryption in transit, ODBC/JDBC connection, IP Whitelisting , SQL Injection, etc..

Re: Best Practice to use/implement SQL Persona using Azure Databricks

Debayan — Thu, 18 Jan 2024 19:32:01 GMT

Hi, There are several documents for the same and can be followed, let me know if the below helps.

https://learn.microsoft.com/en-us/answers/questions/1039176/whitelist-databricks-to-read-and-write-into-azure

https://www.databricks.com/blog/2020/03/27/data-exfiltration-protection-with-azure-databricks.html

https://learn.microsoft.com/en-us/azure/databricks/best-practices-index

https://learn.microsoft.com/en-us/azure/databricks/integrations/jdbc-odbc-bi

https://www.databricks.com/product/azure/security-and-compliance#:~:text=Data%20security,-Azure%20storage%20automatically&text=By%20default%2C%20all%20Azure%20Databricks,your%20own%20key%20(BYOK).