GitHub user dosubot[bot] added a comment to the discussion: Superset is not able to recognise the NULL datatype of any column
<!-- Answer --> Superset needs the timestamp column to have a recognized datetime type from Hydrolix; if the type is NULL, Superset marks it as UNKNOWN and disables time-based features. The most reliable fix is to update your Hydrolix table schema so the timestamp column has an explicit datetime type (like TIMESTAMP or DATETIME). After that, refresh the dataset metadata in Superset and set the main datetime column in the dataset editor if needed. If you can't change the schema, you would need to patch the connector's engine spec to handle NULL types, but that's a backend code change. If this works in another Superset instance with the same config, compare your Superset and connector versionsāupgrading may help, as newer versions have improved time column handling. There is no UI or API workaround for this; manual changes in Superset won't work if the database still reports NULL for the column type. [Reference: Superset code and engine spec handling](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/connectors/sqla/utils.py) [Related discussion](https://github.com/apache/superset/discussions/35135) <!-- 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/243496a5-5a29-4a55-b9af-ad65d2596bd4?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/243496a5-5a29-4a55-b9af-ad65d2596bd4?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/243496a5-5a29-4a55-b9af-ad65d2596bd4?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/243496a5-5a29-4a55-b9af-ad65d2596bd4?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/243496a5-5a29-4a55-b9af-ad65d2596bd4?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/243496a5-5a29-4a55-b9af-ad65d2596bd4?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/243496a5-5a29-4a55-b9af-ad65d2596bd4?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/35188) GitHub link: https://github.com/apache/superset/discussions/35188#discussioncomment-14443443 ---- This is an automatically sent email for notifications@superset.apache.org. To unsubscribe, please send an email to: notifications-unsubscr...@superset.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
