# Overview

The rest of the Pinot documentation covers individual features: schema design, ingestion modes, indexes, query syntax, and operational knobs. These playbooks stitch those features together into **complete, production-ready patterns** for the workloads adopters ask about most often.

Each playbook covers:

| Section                      | What it answers                                        |
| ---------------------------- | ------------------------------------------------------ |
| **When to use this pattern** | Is this the right fit for my workload?                 |
| **Architecture sketch**      | Which Pinot components are involved and how data flows |
| **Schema and table config**  | Concrete JSON you can adapt                            |
| **Ingestion setup**          | Stream and/or batch job configuration                  |
| **Indexing strategy**        | Which indexes to enable and why                        |
| **Query patterns**           | Representative SQL and performance tips                |
| **Operational checklist**    | Monitoring, scaling, and common pitfalls               |

## Playbooks

| Playbook                                                                          | Typical use case                                                                             |
| --------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------- |
| [Real-Time Product Analytics](/workload-playbooks/real-time-product-analytics.md) | Sub-second dashboards over Kafka event streams (page views, clicks, transactions)            |
| [CDC / Upsert Pipeline](/workload-playbooks/cdc-upsert-pipeline.md)               | Keep Pinot in sync with a transactional database via Debezium and upserts                    |
| [Hybrid Real-Time + Offline](/workload-playbooks/hybrid-offline-realtime.md)      | Combine low-latency streaming with high-quality batch backfills in a single logical table    |
| [Multi-Tenant Analytics](/workload-playbooks/multi-tenant-analytics.md)           | Serve many customers from one Pinot cluster with resource and data isolation                 |
| [Text Search Analytics](/workload-playbooks/text-search-analytics.md)             | Full-text search over logs, product catalogs, or support tickets alongside OLAP aggregations |

## How to use these playbooks

1. **Pick the playbook** closest to your workload.
2. **Copy the configs** and adjust field names, topic names, and resource sizes for your environment.
3. **Cross-reference the feature docs** linked inside each playbook for deep dives on any single capability.
4. **Check the operational checklist** before going to production.

{% hint style="info" %}
These playbooks target Pinot 1.x and assume familiarity with [Pinot's architecture](/architecture-and-concepts/concepts/architecture.md) and [table types](/architecture-and-concepts/components/table.md). If you are new to Pinot, start with the [10-Minute Quickstart](/start-here/ten-minute-quickstart.md) first.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pinot.apache.org/workload-playbooks/playbooks.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.