import pyodbc
import pandas as pd

driver = '{ODBC Driver 18 for SQL Server}'
server = 'something.camh.ca'
user_id = 'myusername'
password = 'mypassword'
database = 'databasename'

conn = pyodbc.connect(
    DRIVER = driver,
    SERVER = server,
    UID = user_id,
    PWD = password,
    DATABASE = database,
    TrustServerCertificate = 'Yes',
    MARS_Connection = 'Yes'
)

data = pd.read_sql("select * from databasename.dbo.tablename", conn)