How to connect Azure SQL database from Python Function App using managed identity or access token

Thanks! This method/code worked successfully using the pyodbc library. Has anyone tried sqlalchemy instead? I believe this should work, but I am getting an error. 

params = urllib.parse.quote_plus("DRIVER={ODBC Driver 17 for SQL Server};SERVER="+server+";DATABASE="+database+";Authentication=ActiveDirectoryMsi;Encrypt=yes;") conn_str = 'mssql+pyodbc:///?odbc_connect={}'.format(params) engine = sqlalchemy.create_engine(conn_str, echo=True) 
conn_str = 'mssql+pyodbc:///?odbc_connect={}'.format(params) 
engine = sqlalchemy.create_engine(conn_str, echo=True)

These are the messages I see in Monitor. 

SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)
[raw sql] ()
SELECT schema_name()
[generated in 0.00095s] ()
SELECT CAST('test max support' AS NVARCHAR(max))
[generated in 0.00089s] ()
SELECT 1 FROM fn_listextendedproperty(default, default, default, default, default, default, default)
[generated in 0.00273s] ()
BEGIN (implicit)
SELECT TOP 2 * FROM [dbo].[mytable]
[generated in 0.00226s] ()