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()