ClickHouse supports integration with multiple catalogs (OneLake, Unity, Glue, Polaris, etc.). This guide will walk you through the steps to query your data stored in Microsoft OneLake using ClickHouse and OneLake.
Microsoft OneLake supports multiple table formats for their lakehouse. With ClickHouse, you can query Iceberg tables.
As this feature is beta, you will need to enable it using:
SET allow_database_iceberg = 1;
Gathering Requirements OneLake
Before querying your table in Microsoft Fabric, you’ll need to collect the following information:
- A OneLake tenant ID (Your Entra ID)
- An Application (client) ID
- A client secret
- A warehouse ID and a data item ID
Your warehouse ID is your Workspace ID.
For Data Item ID - we recommend using your Lakehouse ID. In our testing, it doesn’t work with a Warehouse ID.
See Microsoft OneLake’s documentation for help finding these values.
Creating a connection between OneLake and ClickHouse
With the required info above you can now create a connection between Microsoft OneLake and ClickHouse, but before that you need to enable catalogs:
Connect to OneLake
Querying OneLake using ClickHouse
Now that the connection is in place, you can start querying OneLake:
If you’re using the Iceberg client, only the Delta tables with Uniform-enabled will be shown:
To query a table:
Backticks requiredBackticks are required because ClickHouse doesn’t support more than one namespace.
Loading data from your Data Lake into ClickHouse
If you need to load data from OneLake into ClickHouse:
