I’m trying to get MGRS grids from the coordinates available in my redash tables. Is there any way to get it?
Welcome to the forum!
I think you’ll need some custom script / tool to gather this for you. MGRS grids aren’t JOINable since there is a many-to-one relationship between LatLong and MGRS.
You could probably use something like this mgrs library to read coordinates from your database tables and then
UPDATE a new column with the calculated MGRS grid. Then in Redash you could just
SELECT from this new column.