ClickHouse / ClickHouse/dbt-clickhouse

Database tab is empty in generated docs

Open
#311 9 comments 9 reactions 0 assignees View on GitHub
bug
Dominant language
Python
Stars
362
Forks
177
Avg merge
2d 10h
Merged PRs (30d)
8

Description

### Describe the bug
When serving the generated docs, I only have models under the Project tab. The Database tab is completely empty. Is this due to that dbt expects database.schema.table while ClickHouse skips the schema part?

Is this a concious choice or is my dbt version misconfigured?

### Steps to reproduce
1. run `dbt docs generate`
2. run `dbt docs serve`
3. Browse to the tab Overview -> Database

### Expected behaviour
I was expecting to look at trees of databases and tables.

### Configuration
#### Environment
* dbt version: 1.7.12
* dbt-clickhouse version: 1.7.6
* clickhouse-connect version (if using http): 0.7.0
* Python version: 3.11.9
* Operating system: macOS-14.5-arm64-arm-64bit

#### ClickHouse server
* ClickHouse Server version: 24.5.1.1763

Contributor guide

Open the contributing guide

Research direction

Reproduce the issue with `dbt docs generate` and `dbt docs serve`, then inspect the Overview → Database tab and the generated metadata used to populate it. Compare the expected database and table tree with the ClickHouse relation metadata; done means the Database tab displays the available databases and tables correctly.

Written by the indexing model from the issue text.

Assessment

Tech stack
clickhouse, python
Domain
databases, documentation
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.