we have Metabase connected to Druid, everything works great, and it’s helping us a lot. The only problem is that we haven’t been able to find a way to add MySQL lookups (or any kind of lookup) for Druid dimensions.
The situation is we have some dimensions defined as lookups, so there is a direct relationship between the dimension value and the column of a MySQL table, and the dimension should be replaced by that value. You can understand how it works by reading the Druid docs about lookups.
Our issue is that after looking at the docs we haven’t found a way to add lookups to Metabase. Even if Metabase didn’t support MySQL lookups, static map lookups would also work, because we could extract the information and add it manually to Metabase. Is there any way to do that?