Azure Stream Analytics now supports managed identity authentication with Azure SQL Database. Managed identities eliminate the limitations of user-based authentication methods, like needing to reauthenticate due to password changes or user token expirations that occur every 90 days. Additionally, managed identities help with the automation of Stream Analytics job deployments that output to Azure SQL Database.
Learn more.