# ClickHouse

Integrate, catalog, and govern ClickHouse assets in Atlan.

## Required permissions

- [Preflight checks for ClickHouse](https://docs.atlan.com/llms/connectors/clickhouse/preflight-checks-for-clickhouse/llms.txt): Before running the ClickHouse crawler, you can run preflight checks to perform the necessary technical validations.

## Setup options

- [Set up ClickHouse](https://docs.atlan.com/llms/connectors/clickhouse/set-up-clickhouse/llms.txt): Configure a dedicated ClickHouse user with read-only access so Atlan can connect and extract metadata.

## Crawl and mine

- [Crawl ClickHouse](https://docs.atlan.com/llms/connectors/clickhouse/crawl-clickhouse/llms.txt): Create a ClickHouse crawler workflow in Atlan to extract metadata from your database.
- [Mine ClickHouse](https://docs.atlan.com/llms/connectors/clickhouse/mine-clickhouse/llms.txt): Once you have crawled assets from ClickHouse, you can mine its query history to construct lineage.
- [Generate lineage](https://docs.atlan.com/llms/connectors/clickhouse/generate-lineage-with-clickhouse-miner/llms.txt): Enable query logging and configure your ClickHouse instance so the ClickHouse Miner workflow can extract query history and generate lineage.

## Reference

- [How Atlan connects to ClickHouse](https://docs.atlan.com/llms/connectors/clickhouse/how-atlan-connects-to-clickhouse/llms.txt): Understand how Atlan securely connects to your ClickHouse database to extract metadata.
- [What does Atlan crawl from ClickHouse?](https://docs.atlan.com/llms/connectors/clickhouse/what-does-atlan-crawl-from-clickhouse/llms.txt): During a ClickHouse crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Columns. Reference tables map each ClickHouse property to its Atlan asset.

## Troubleshooting

- [Troubleshooting ClickHouse connectivity](https://docs.atlan.com/llms/connectors/clickhouse/troubleshooting-clickhouse-connectivity/llms.txt): Resolve common ClickHouse connection issues and errors.