Sqalchemy + Alembic + Postgres Unlogged Table Example

alembic_migration.py

op.create_table(
    "unlogged_table",
    sa.Column("id", sa.BigInteger(), nullable=False),
    sa.PrimaryKeyConstraint("id", name=op.f("pk_unlogged_table")),
    prefixes=["UNLOGGED"],
)

models.py

class UnloggedTable(Model):
    """Table example for unlogged model. We use TEMPORARY/UNLOGGED table to minimize WAL writeups,
    In addition, this table won't be replicated to the cluster. This will also improve write speed.
    """

    __tablename__ = "unlogged_table"
    __table_args__ = {"prefixes": ["UNLOGGED"]}
    id = Column(db.BigInteger(), primary_key=True)