Get a list of all fields in all tables from Metabase

[kgl_m]

We are using Metabase (0.32.1) with Postgres 9.6 (RDS). The application database is also on Postgres 9.6 (RDS).

I would like to get a list of all tables and fields in the data warehouse from Metabase, along with associated constraints like PK, indexes etc. I need this information in order to start writing a data dictionary, and a guide on how to write queries using our Metabase.

I would be happy to get this information from Metabase including the friendly name that Metabase assigns a field that it indexes. Otherwise if someone could show me how to get this from Postgres that would also be great.

[flamber]

Hi @kgl_m
I think most of what you're looking for is located in the table metabase_field - have you looked in that?
Also, there's a list of various queries, which might help you figure things out:

Metabase Metadata SQL

Metabase is lacking in some of the management information I’d like to see. Hopefully the queries below will help a few others build up a management dashboard too. In summary: List of Dashboards List of Questions List of Questions in each Dashboard List of Questions not in any Dashboard List of Users LIst of Users who have never logged in List of Dashboards viewed by each user and count of views Pretty much anything else you can dream up /* All dashboards */ SELECT rd.id, rd.name, rd.descript…