Search for a "value" in a whole DataSource

1

Hello,

I am “exploring” one of the Database I got (MySQL) in order to retrieve some specific data.

I would like to know if anyone of you got a way to “search” for a value.

Usually you search by the name of the column, but I don’t have any idea of what it could be (except that’s “ID” should be in there). I would like to type the value of the ID I got (like 123456789) and get the table / column name where it’s been stored.

have you already facing something like that ? It would helps me a lot :wink:

Thank you.

KR

2

Hello Yen,

You have a value and want to search for the columnname and tablename with it?

I don’t think we have a way to figure it out to the best of my knowledge in any database.

Also Dremio has ‘search catalog’ in the UI where you can search of a Database/tablename to know the path and not with the column value.

Thanks,
Rakesh

3

Thank you Rakesh,

Yes, I were hoping finding a way to discover the column name based on actual value. But it didn’t seems to be possible, thank you.

Yannick