Acces Azure Synapse from Databricks using system managed identity

Question

I'm following this guide: https://joeho.xyz/blog-posts/how-to-connect-to-azure-synapse-in-azure-databricks/ to connect to Azure Synapse from Databricks. Specificaly I'm stuck on this part:

# Azure Synapse Connection Configuration
dwDatabase = <<your-database-name>>
dwServer = <<your-sql-sever-name>>
dwUser = <<your-database-account>>
dwPass = <<your-database-account-password>>
dwJdbcPort =  "1433"
dwJdbcExtraOptions = "encrypt=true;trustServerCertificate=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;"
sqlDwUrl = f"jdbc:sqlserver://{dwServer}:{dwJdbcPort};database={dwDatabase};user={dwUser};password={dwPass};${dwJdbcExtraOptions}"

Problem is I can't use user and password, I can only connect through system managed identity. How do I do this? Any help appreciated!

The Spark driver can connect to Azure Synapse using these two authentications 1) JDBC with a username and password. 2) OAuth 2.0 with a service principal for authentication. — Pratik Lad
– Pratik Lad, Commented Oct 3, 2022 at 9:06

Alex Ott · Accepted Answer · 2022-10-03 09:25:13Z

0

Azure Databricks clusters doesn't have managed identity, so you can't do it right now. As of right now, the only supported options are either username + password, or service principal with OAuth. See documentation for more details.

answered Oct 3, 2022 at 9:25

Alex Ott

88.1k10 gold badges110 silver badges157 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Acces Azure Synapse from Databricks using system managed identity

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related