Read from SQL Using SQLAlchemy, Connect With Config Details

import pandas as pd
import sqlalchemy as sa
import configparser
from os import path

configfile = 'config.ini'
config = configparser.ConfigParser()
config.read(path.dirname(__file__) + '/' + configfile)


server = config['Database']['server']
database = config['Database']['Database']
driver = "SQL Server"
connection_string = "mssql://{server}/{database}?driver={driver}?trusted_connection=True"
"mssql://{server}/{database}?driver={driver}?trusted_connection=True"

engine = sa.create_engine(connection_string.format(server=server, database=database, driver=driver))

columns = ['GasFlowDate','LDZ','ALP','DAF','SNCWV','SND'
      ,'WSENS'
      ,'EWCF'
      ,'WAALP'
      ,'WAALP_adjusted']

df = pd.read_sql_table(table_name= 'vwWAALP', schema= 'gas', con = engine, columns =columns)

sql_file = open(r'example.sql')
sql = sql_file.read()

df2 = pd.read_sql(sql = sql,  con = engine )