GitHub user dosubot[bot] added a comment to the discussion: Not able to load the dashboards after upgrading superset to v3.0.0
<!-- Answer --> The 'UNKNOWN' status for your timestamp column means Superset couldn't recognize it as a datetime column—usually because it couldn't determine the column's type during metadata fetching, often due to missing or ambiguous type info from the database driver or schema ([source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/connectors/sqla/utils.py)). This prevents Superset from using it as the main datetime column for time-series queries, which leads to the "Missing columns: 'timestamp'" error. To fix this: 1. In the dataset editor, explicitly set the column type for your timestamp field to a recognized datetime type and provide a valid datetime format if possible. 2. Make sure the main datetime column (`main_dttm_col`) is set to your actual timestamp column, not left blank or set to a default. 3. Save and refresh the dataset metadata—this triggers Superset to re-fetch column types and update its internal mapping ([source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/connectors/sqla/models.py)). If Superset still shows 'UNKNOWN', check your ClickHouse schema to confirm the column is defined as a Date or DateTime type, and that the driver is returning correct type info. Manually entering the datetime format in the UI can help Superset recognize the column as temporal. Once the column is recognized, dashboards should load as expected. <!-- 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/e85d39fe-6ef9-4adc-8940-63716ebec101?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/e85d39fe-6ef9-4adc-8940-63716ebec101?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/e85d39fe-6ef9-4adc-8940-63716ebec101?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/e85d39fe-6ef9-4adc-8940-63716ebec101?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/e85d39fe-6ef9-4adc-8940-63716ebec101?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/e85d39fe-6ef9-4adc-8940-63716ebec101?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/e85d39fe-6ef9-4adc-8940-63716ebec101?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-14399903 ---- 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]
