dosubot[bot] commented on issue #34718: URL: https://github.com/apache/superset/issues/34718#issuecomment-3191536886
<!-- Answer --> To check the raw type string DuckDB returns for your column (the value Superset's backend uses for type recognition), run this in SQL Lab: ```sql SELECT typeof(column_name) FROM table LIMIT 1; ``` The result is the exact type string DuckDB emits for that column. Superset 5.0.0 only recognizes columns as numeric (for the # icon) if this string starts with `float`, `double`, `decimal`, or `numeric` (case-insensitive). If your type string is something like `DOUBLE PRECISION` or `DECIMAL(18,4)`, Superset won't treat it as numeric for histograms [details](https://github.com/apache/superset/discussions/34717#discussioncomment-14115291). If you want to see the backend metadata Superset uses, you can also fetch it via the `/external_metadata_by_name/` API endpoint, which returns the raw type string for each column as seen by Superset's backend [source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/views/datasource/views.py). Keep in mind: the type shown in SQL Lab's preview (e.g., FLOAT) is based on SQLAlchemy's mapping and may differ from the raw type string used for chart controls and icons. The backend logic is stricter and relies on the actual string DuckDB returns. <!-- 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/97a6f310-c991-43d8-ac36-c6916c41c7f3?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/97a6f310-c991-43d8-ac36-c6916c41c7f3?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/97a6f310-c991-43d8-ac36-c6916c41c7f3?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/97a6f310-c991-43d8-ac36-c6916c41c7f3?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/97a6f310-c991-43d8-ac36-c6916c41c7f3?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/97a6f310-c991-43d8-ac36-c6916c41c7f3?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/97a6f310-c991-43d8-ac36-c6916c41c7f3?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](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/issues/34718) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
