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