Read an external sql file into a pandas dataframe.

read_sql.py

import pyodbc
import pandas as pd

def rs(fname, conn):
    """ Returns a pandas dataframe from external file. """
    with open(fname, 'r') as f:
        return pd.read_sql_query(f.read(), conn)
      
conn = pyodbc.connect('Driver={SQL Server};'
                      'Server=servername;'
                      'Database=StateExternalComparison;'
                      'Trusted_Connection=yes;')

df = rs('my_file.sql', conn)

Love your code :)

But how to read multiple external sql files and put them in the loop to execute multiple queries?

Thank you.