# Table functions supported in Managed ClickHouse®

[Table
functions](https://clickhouse.com/docs/reference/functions/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**
> ```sql
> 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](/product/dbaas/service-specific/clickhouse/how-to/run-federated-queries/#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`