Workflows (by intent)

This page is a routing layer: start from what you’re trying to do and jump to the most relevant guide/recipe.

If you’re new to the core concepts first, read:

• Mental model

Transform workflows

• Joins + groupby: Join + groupby recipe
• Windows:
• Windows framing primer
• Window semantics (SQL-style)
• Selectors / column sets: Selectors

I/O workflows

• Pick an I/O entrypoint: I/O decision tree
• Format overview and per-format guides: I/O overview
• SQL read/write: SQL I/O
• HTTP + Parquet pattern: HTTP parquet ctx recipe
• Write a lazy pipeline: Lazy pipeline write recipe

Service workflows (FastAPI)

• Start-to-finish service path: Golden path (FastAPI)
• Columnar request/response bodies: FastAPI columnar bodies
• Async materialization patterns: FastAPI async materialization
• End-to-end examples: FastAPI end-to-end examples
• Background tasks: FastAPI background tasks
• Observability: FastAPI observability
• Settings: FastAPI settings

Execution workflows

• Understand cost / display / interchange: Execution
• Choose a materialization mode: Materialization

Typing workflows

• How typing works (mypy/pyright/ty): Typing
• Common issues / sharp edges: Troubleshooting

“Where does pydantable fit?”

• Why pydantable?
• Comparisons