Establish a database connection using SQLAlchemy with Pandas

database_connection.py

import pandas as pd
from sqlalchemy import create_engine, URL
from sqlalchemy.sql import text

url_object = URL.create(
    drivername="DIALECT+DRIVER",
    username="username",
    password="password",
    host="host",
    database="database_name",
)

engine = create_engine(url=url_object)

with engine.connect() as db_conn:
    sql_query = "SELECT COUNT(*) FROM table_name"
    df = pd.read_sql_query(sql=text(sql_query), con=db_conn)