I found this tab in Metabase; for a single Bigquery table, I can see the "Questions About This Table". This is extremely useful information when updating tables upstream! Is there a way to fetch this information programmatically? I would like to generate a mapping of Bigquery tables to Questions that I can reference when changing table definitions upstream
You probably could using the API or just reading the database. However, it won't be easy to see the use of any columns in SQL questions.
Better to use views for Metabase, then just manage the views.