Hello I am using sqlalchemy and pandas to process some data and then save everything to a table in an sql database. I am trying to find a quick easy and standardized way to check if a table exists in a database based on a table name.
I have found the has_table() function but no working examples. Does anyone has something like give "engine connection" & "table name"-> return true or false if table exists
With SQLAlchemy 1.4+ you can call has_table by using an inspect object, like so:
import sqlalchemy as sa
# …
engine = sa.create_engine(connection_uri)
insp = sa.inspect(engine)
print(insp.has_table("team", schema="dbo")) # True (or False, as the case may be)
For earlier versions of SQLAlchemy, see the other answer here.
mssql+pyodbc.schema= keyword argument defaults to None so you can simply omit it.
so I made this function based on this idea from the first reposnse:
def table_exists(engine,name):
ins = inspect(engine)
ret =ins.dialect.has_table(engine.connect(),name)
print('Table "{}" exists: {}'.format(name, ret))
return ret
sqlalchemy .inspect for those who wonders.NOTE: This method is discouragued by SQLAlchemy, is published only for third party dialects or a plugin, use at this conditions.
For SQLAlchemy==2.0.25
from sqlalchemy import create_engine
from sqlalchemy.engine import URL
url = URL.create(drivername=drivername,
username=youruser,
password=yourpass,
host=yourhost,
database=yourdbname)
engine = create_engine(url, echo=True)
if engine.dialect.has_table(table_name=YOURTABLENAME,connection=engine.connect()):
echo "table exist"
