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