I am using Metabase for production use. My database that I use for production is MySQL. I would like to access the Metabase Metadata to get details of all Metabase cards and Dashboard information.
How can I access the metadata to run the below queries.
I was planning to run the below queries -
SELECT rd.id, rd.name as DashboardName, rd.description as DashboardQuestion, q.name as QuestionName, q.description as QuestionDescription, q.display as QuestionDisplay
FROM report_dashboard rd
INNER JOIN report_dashboardcard rdc on rd.id = rdc.dashboard_id
INNER JOIN report_card q on q.id = rdc.card_id
where rd.archived = 0 and q.archived = 0;
SELECT * FROM metabase.report_card where dataset_query like ‘%native%’