| Method | Description |
|---|---|
Using the azureBlobStorage Table Function | Involves using ClickHouse’s azureBlobStorage Table Function to transfer data directly from Azure Blob Storage. |
| Using the ClickHouse HTTP interface | Uses the ClickHouse HTTP interface as a data source within Azure Data Factory, allowing you to copy data or use it in data flow activities as part of your pipelines. |
Bringing Azure Data into ClickHouse
Bringing Azure Data into ClickHouse - Overview
Microsoft Azure offers a wide range of tools to store, transform, and analyze
data. However, in many scenarios, ClickHouse can provide significantly better
performance for low-latency querying and processing of huge datasets. In
addition, ClickHouse’s columnar storage and compression can greatly reduce the
cost of querying large volumes of analytical data compared to general-purpose
Azure databases.
In this section of the docs, we will explore two ways to ingest data from Microsoft Azure
into ClickHouse: