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:

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.

---

• GENERATE_SERIES
• LIST_OBJECTS
• READ_CSV
• READ_PARQUET