> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/table-valued",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> 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={"theme":{"light":"github-light","dark":"github-dark"}}
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` to read data from Amazon S3.