---
title: Pipes
meta:
    description: Pipes help you to bring your SQL queries together to achieve a purpose, like publishing an endpoint.
---

# {% icon name="pipe" /%} Pipes

A pipe is a collection of one or more SQL queries. Each query is called a node.

Use Pipes to build features over your data. For example, you can write SQL that joins, aggregates, or otherwise transforms your data and publish the result as an endpoint.

{% snippet title="nodes" /%}

## Display Limits

When viewing query results in the UI, there is a 5000 character limit for displaying data in a cell value. If a cell contains more than 5000 characters, the data will be truncated. This limit applies only to the UI display and does not affect the actual data or query results returned through API Endpoints.

## Create generic pipes

Pipes are defined in a .pipe file without a specific `TYPE`. See [Pipe files](/forward/dev-reference/datafiles/pipe-files).

## List your pipes

To list your pipes, run the following command:

```bash
tb pipe ls
```

## Next steps

- Learn about [Endpoints](/forward/work-with-data/publish-data/endpoints).
- Learn about [Copy pipes](/forward/work-with-data/optimize/copy-pipes).
- Learn about [Materialized views](/forward/work-with-data/optimize/materialized-views).