# ClickHouse Integration: Dashboards and AI Analytics | Silicon

URL: https://meetsilicon.com/integrations/clickhouse/

> Connect Silicon to ClickHouse and query it live through your semantic layer. Fast analytics on ClickHouse, self-hosted or in ClickHouse Cloud.

Integrations / ClickHouse
# Silicon + ClickHouse
Connect Silicon to ClickHouse and query it live through your semantic layer. Fast analytics on ClickHouse, self-hosted or in ClickHouse Cloud.
Available on: All plans
Book a demo
30-minute demo with the founder
Features
## What you can do
- Dashboards, scheduled reports and alerts on ClickHouse data
- AI analyst answers that run as governed SQL against ClickHouse
- Schema checks that compare pull requests with your live warehouse
- Row- and column-level permissions applied to every query
Set-up
## Connect ClickHouse
- Create a user or service account in ClickHouse with read access to the schemas your dbt models build into.
- Add the ClickHouse connection details in your Silicon project settings.
- Connect your dbt project, or define metrics in Silicon YAML, so Silicon knows your models and metrics.
- Build dashboards, ask the AI analyst or schedule reports. Queries run live in ClickHouse.
Detailed instructions for connecting ClickHouse are in the Silicon docs. Questions about your setup? Talk to Sujay.
FAQ
## ClickHouse questions
### Does Silicon copy my data out of ClickHouse? +
Silicon queries ClickHouse live through your semantic layer, so the data stays in your ClickHouse account.
### What access does Silicon need in ClickHouse? +
Read access to the schemas and tables your dashboards and metrics use. Silicon does not need write access to your data.
### Do we need dbt? +
It helps, because Silicon reads your models and descriptions from it. Metrics can also be defined in Silicon YAML without a dbt project.
### Which Silicon plans include ClickHouse? +
All plans. See the pricing page for what each plan includes.
## More warehouses integrations
- Snowflake ->
- BigQuery ->
- Databricks ->
- Amazon Redshift ->
- All integrations ->
## Tell us where your data lives today.
Book 30 minutes with the founder. Tell us where your data is today, and see Silicon running on sample data.
Book a demo
30-minute demo with the founder