test_connection.py

def execute_query(params, query):
  # Build your engine
  engine = create_engine("mssql+pyodbc://some_uri_here/?odbc_connect={}".format(params))
  # Sanity check that you even get anything here
  with engine.connect() as conn:
    result = conn.execute("SELECT 1;")
    print(result)
  with engine.connect() as conn:
    try:
      return pd.read_sql_query(query, conn)
    except Exception as e:
      raise ValueError(e)
execute_query("test", "SELECT 1")