dosubot[bot] commented on issue #34748: URL: https://github.com/apache/superset/issues/34748#issuecomment-3200746236
<!-- Answer --> The column type `'TEXTT'` is likely the root causeāSuperset expects the GeoJSON column to be recognized as `'TEXT'` (or equivalent string type) in both your database/view and the Superset dataset definition. If the type is misspelled or unrecognized, Superset may not parse the data correctly, resulting in 0 rows in the chart even though SQL Lab shows results. To fix this: update your view or table so the column type is `'TEXT'`, then refresh (sync) the dataset schema in Superset so it picks up the correct type. After syncing, re-select the GeoJSON column in the chart controls. This should resolve the issue and allow your data to display as expected. Superset is case-sensitive with column names, so make sure the spelling matches exactly in both the dataset and chart controls. If you still see 0 rows, check for backend/server log errors and confirm there are no filters or row limits excluding data. More details on how Superset handles column types and schema sync can be found [here](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/0262bf84-e095-4c3e-a7e6-450571a0ea92?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/0262bf84-e095-4c3e-a7e6-450571a0ea92?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/0262bf84-e095-4c3e-a7e6-450571a0ea92?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/0262bf84-e095-4c3e-a7e6-450571a0ea92?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/0262bf84-e095-4c3e-a7e6-450571a0ea92?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/0262bf84-e095-4c3e-a7e6-450571a0ea92?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/0262bf84-e095-4c3e-a7e6-450571a0ea92?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/34748) -- 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
