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)

library(odbc)

con <- dbConnect(odbc(),
                 Driver = "/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.0.so.1.1",
                 Server = "something.camh.ca",
                 Database = "MyDatabaseName",
                 UID = "MyUserId",
                 PWD = "MyPassword",
                 TrustServerCertificate='Yes',
                 MARS_Connection='Yes'
                 )

#Setup the query:
Query = "SELECT * FROM MyDatabaseName.dbo.TableName"

#Send the query to the database
res <- dbSendQuery(con, Query)

#Fetch data coming out from that query in R Dataframe format
df = dbFetch(res)