When using pandas "read_sql_query", do I need to close the connection? Or should I use a "with" statement? Or can I just use the following and be good?
from sqlalchemy import create_engine
import pandas as pd
sql = """
SELECT * FROM Table_Name;
"""
engine = create_engine('blah')
df = pd.read_sql_query(sql, engine)
print df.head()
For anyone who finds this question and wonders how to close the connection in this example, the following method worked for me: engine.dispose()
Looking at the source code, I can't find a con.close() method on any SQL connection object, only the cursor objects for the queries.
I'd close for safe-measure. Whether you do that using with or not is up to you.