Skip to content
Product
DBaaS
Service-Specific
ClickHouse
Reference
Table functions supported in Managed ClickHouse®

Table functions supported in Managed 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.

Note

Sample usage of the Delta Lake table function

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

Note

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

Note

Table functions that read from an external source, such as s3 and url, require the matching grants. The main service user avnadmin holds them by default, other users need an explicit GRANT, see Prerequisites.

Managed ClickHouse® supports the following table functions:

  • azureBlobStorage
  • cluster
  • clusterAllReplicas
  • cosn
  • deltaLake
  • format
  • fuzzQuery
  • gcs
  • generateRandom
  • hudi
  • iceberg
  • input
  • loop
  • merge
  • mysql
  • null
  • numbers
  • numbers_mt
  • oss
  • postgresql
  • remoteSecure
  • s3
  • s3Cluster
  • url
  • values
  • view
  • viewExplain
  • viewIfPermitted
  • zeros
  • zeros_mt
Last updated on
Supported table engines in Managed ClickHouse®Managed ClickHouse® version support policy