GitHub user dosubot[bot] added a comment to the discussion: 422 Unprocessable Entity while syncing the columns from hydrolix using clickhouse connect driver
<!-- Answer --> A 422 Unprocessable Entity error during column sync from Hydrolix using the ClickHouse Connect driver in Superset is often caused by schema or datatype issues. Common root causes include using the wrong query parameter (e.g., 'table' instead of 'name') when calling the table metadata API, or having columns in Hydrolix with NULL or unsupported types, which show up as UNKNOWN in Superset and trigger validation errors during sync. To resolve this, make sure your API calls use the correct parameters ([details](https://github.com/apache/superset/issues/32685)), and ensure all columns—especially timestamp columns—have explicit, supported types like TIMESTAMP or DATETIME in Hydrolix ([details](https://github.com/apache/superset/discussions/35188)). If you can't change the schema, you may need to patch the connector to handle NULL types. Also, upgrading to Superset 3.0.2 or later can help with time column recognition issues. <!-- 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/a6f4e298-68be-4029-b07c-6ec59b062721?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/a6f4e298-68be-4029-b07c-6ec59b062721?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/a6f4e298-68be-4029-b07c-6ec59b062721?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/a6f4e298-68be-4029-b07c-6ec59b062721?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/a6f4e298-68be-4029-b07c-6ec59b062721?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/a6f4e298-68be-4029-b07c-6ec59b062721?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/a6f4e298-68be-4029-b07c-6ec59b062721?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/35230) GitHub link: https://github.com/apache/superset/discussions/35230#discussioncomment-14476571 ---- 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
