I need to identify any tables that aren't currently used by any questions. There's not custom SQL questions, which makes life easier.
Looked easy - each report_card has a 'table_id', then you unfold the dataset_query to retrieve the other tables.
Problem is that this only returns the tables that are explicitly used in the queries. I also need to identify anything used in the filters or groups.
Has anyone managed to do this? It's all in there somewhere, it's just more work than I expected.