GitHub user dosubot[bot] added a comment to the discussion: Not able to load the dashboards after upgrading superset to v3.0.0
<!-- Answer --> This error is happening because Superset expects a main datetime column (often called `timestamp`) in your dataset metadata. After upgrading to v3.0.0, Superset handles time columns more strictly—if the `main_dttm_col` property isn't set correctly, Superset will default to looking for a column named `timestamp`, which may not exist in your ClickHouse table. To fix this, go to the Superset UI, open the affected dataset(s), and make sure the main date/time column (`main_dttm_col`) is set to the actual datetime column in your ClickHouse table. Then refresh the dataset metadata. This will ensure Superset generates queries using the correct column name and resolves the missing column error. This behavior is rooted in how Superset maps time columns for time-series queries and was surfaced by stricter handling in v3.0.0 ([reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/connectors/sqla/models.py)). <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/ebd1ce41-9054-40e4-bc45-e00caab4661b?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/ebd1ce41-9054-40e4-bc45-e00caab4661b?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/ebd1ce41-9054-40e4-bc45-e00caab4661b?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/ebd1ce41-9054-40e4-bc45-e00caab4661b?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/ebd1ce41-9054-40e4-bc45-e00caab4661b?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/ebd1ce41-9054-40e4-bc45-e00caab4661b?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/ebd1ce41-9054-40e4-bc45-e00caab4661b?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)& nbsp;[](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/35135) GitHub link: https://github.com/apache/superset/discussions/35135#discussioncomment-14399823 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
