Map visualisation


I have a SQL query returning GeoJSON points e.g.

I can't seem to use the map visualisation on this.

Reading it seems I need to "edit metadata"? I think this can only be done with static data, not with an ad-hoc query? Is this correct?
Please don't say "just create a database view".
Surely it should be possible to use any visualisation with any ad-hoc query? Why can't I just tell the visualisation "this is the latitude, this is the longitude"?

Many thanks

Hi @mausch
Metabase does not support the point column type: - upvote by clicking :+1: on the first post
On newer versions of Metabase you can use the Map visualization even on SQL questions.