Table functions supported in Aiven for ClickHouse®

Table functions can be used to construct tables, for example, in a FROM clause of a query or in an INSERT INTO TABLE FUNCTION statement.

Sample usage of the S3 table function

SELECT *
FROM deltaLake('s3://bucket/path/to/lake')

Note

Occasionally, you may find specific table functions disabled for security reasons.

Aiven for ClickHouse® supports the following table functions:

• cluster

• clusterAllReplicas

• cosn

• deltaLake

• format

• gcs

• generateRandom

• hudi

• iceberg

• input

• merge

• mysql

• null

• numbers

• numbers_mt

• oss

• postgresql

• remoteSecure

• s3

• s3Cluster

• url

• values

• view

• viewExplain

• viewIfPermitted

• zeros

• zeros_mt