Search for tables by column

Is it possible to search for tables that have particular columns? For example, searching for all tables that have a product_id column. Thanks!

@ahr if you have access to your application database, you could do a query to the metabase_field table and search for the tables that have those columns. Remember that you can do the same in your database by going to the information schema

1 Like

Hey Luiggi, thanks for the tip! I'm a very technical user who has access to my raw database, but not many of my users can or want to go to those lengths to search for tables by column name. I was hoping that Metabase had a user-friendly way to search for such things.

i suggest that you add the app database as a data source in your metabase instance and build SQL queries with filters that users can use to achieve that