SQLAlchemy connect to Azure SQL, using PyODBC

sqlalchemy_azure_mssql_pyodbc.py

# On mac, run these first:
# - brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
# - brew update
# - brew install msodbcsql17 mssql-tools
#
# Install requirements:
# - pip install pyodbc sqlalchemny

import urllib
from sqlalchemy import create_engine

server = "<YOUR_AZURE_DB_NAME>.database.windows.net"
database = "<DB NAME>"
username = "<USER NAME>"
password = "<PASSWORD>"

driver = '{ODBC Driver 17 for SQL Server}'

odbc_str = 'DRIVER='+driver+';SERVER='+server+';PORT=1433;UID='+username+';DATABASE='+ database + ';PWD='+ password
connect_str = 'mssql+pyodbc:///?odbc_connect=' + urllib.quote_plus(odbc_str)

print connect_str

engine = create_engine(connect_str)

print engine.execute("SELECT 1").fetchall()

Great!

Thanks! There are a lot of examples online that are not quite right. This one is great!

How can i use ORM for Azure sql?
Can you please suggest..

pip install pyodbc sqlalchemy

Thank you.

Also, to anyone using a current version of urllib please, change this:
urllib.quote_plus(odbc_str)

to this:
urllib.parse.quote_plus(odbc_str)

I need to use authorization level : Azure Active Directory interactive. Anyone how knows how to use this level?