search

metabase / metabase

The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
https://metabase.com
Other
37.3k stars 4.95k forks source link

Making a model with a native question that was "transformed" with "Explore results" will lead to model with no metadata #45146

Open paoliniluis opened 4 days ago

paoliniluis commented 4 days ago

Describe the bug

In the process of hunting where metadata gets lots, I found a flow that might actually be a big culprit of why things don't work: if you make a native question look like a GUI question and then transform this question into a model, Metabase will treat this question as a GUI one, but without any metadata on it

To Reproduce

1) new native question -> select * from people 2) click on "explore results", then transform it into a model 3) try to map the state field to the actual state field that exists on the table, you can't image image

... now: 1) new native question -> select * from people 2) transform this into a model 3) see that the field now can be mapped to the state field in the table image image

Expected behavior

We should know that the query is a native one and offer the metadata mapping

Logs

NA

Information about your Metabase installation

I think it has always been like that

Severity

P1

Additional context

This might be a big reason why we lose Metadata and we don't know why, it might be that the users made a SQL question and masked it as a GUI one, and then we "believe" that metadata should be there as it seems like a normal GUI question

paoliniluis commented 3 days ago

moving into a P1, as this can cause real trouble