> ## Documentation Index
> Fetch the complete documentation index at: https://firebolt-aggregate-helm-docs-pr-4.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference for table-valued functions

# Table-valued functions

## Table-valued functions

A table-valued function (TVF) returns a set of rows. You can use a table-valued function anywhere you can use a table. For example, the `generate_series` TVF generates a range of numbers as rows.

The following code example generates a series of numbers from 1 to 100 and selects each number as x from the resulting series:

```sql theme={null}
SELECT x FROM generate_series(1, 100) r(x);
```

You can use the `list_objects` TVF to explore files on Amazon S3. Use functions such as `read_parquet` and `read_text` to read data from Amazon S3. Use `read_stream` to consume data from Kafka streams.