loop Table Function

Syntax

Parameters

database — database name.
table — table name.
other_table_function(...) — other table function. Example: SELECT * FROM loop(numbers(10)); other_table_function(...) here is numbers(10).

Returned Value

Infinite loop to return query results.

Examples

Selecting data from ClickHouse:

Or using other table function:

Was this page helpful?

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.