Please provide instructions how to use TokenLibrary with Azure SQL Database

[piotrgwiazda]

Please provide some documentation for how to use an Azure SQL Database Linked Service (with Synapse Managed Instance) to connect from Spark pool with the use of TokenLibrary.

With this piece of code

conn = TokenLibrary.getConnectionString("MyAzureSQLDatabaseLinkedService")
print(conn)

I am getting a string that looks like Base64-encoded JWT token plus some additional unknown characters.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 56d638cd-6592-ce95-90aa-dc8d6e4e90ba
• Version Independent ID: 5360961f-6bfc-ecad-cf49-22eee26bd010
• Content: Secure access credentials with Linked Services in Apache Spark for Azure Synapse Analytics - Azure Synapse Analytics
• Content Source: articles/synapse-analytics/spark/apache-spark-secure-credentials-with-tokenlibrary.md
• Service: synapse-analytics
• Sub-service: spark
• GitHub Login: @mlee3gsd
• Microsoft Alias: martinle

[KranthiPakala-MSFT]

@piotrgwiazda Thanks for the feedback! We have assigned the issue to the content author to further review this feedback and provide an update as appropriate.

[julieMSFT]

assign:luisquintanilla

[piotrgwiazda]

One of my team members found a solution by using a new (unreleased as of now) Spark connector. See: https://stackoverflow.com/a/67124073/221951 This might be useful if it was in the documentation. Mind that you still need to provide a database URL.

[julieMSFT]

reassign:mlee3gsd

[bandersmsft]

Thanks for your dedication to our documentation. Unfortunately, at this time we have been unable to review your issue in a timely manner and we sincerely apologize for the delayed response. We are closing this issue for now, but if you feel that it's still a concern, please respond and let us know. If you determine another possible update to our documentation, please don't hesitate to reach out again. #please-close