#2079 [Docs] How to display Flyte metrics stored in the admin DB Issue created by veggiemonk Description As we discussed with @freezing-airport-6809, we were thinking about a way to extract metadata from the database. This could be useful for reporting and resources usage optimisation. Few things that we find cumbersome: A) Getting the data. Right now it leaves in the admin DB where production data are, and access control is more restricted. B) The schema of the DB is not so obvious. Some column have a name that is not so self explanatory. C) The queries are difficult to get right as they query a DAG. • One possibility for us at Spotify is to sync the data from the DB to BigQuery and do the analytics there. • Another possibility is to modify flyte-admin to add a command that can run a SQL query and expose the metrics to Prometheus. As the reporting metrics are not needed in near real time, modifying flyte-admin is a bit of work but with proper guidance/documentation people could contribute their queries upstream. Let me know what do you think? Are you sure this issue hasn't been raised already? ☑︎ Yes Have you read the Code of Conduct? ☑︎ Yes flyteorg/flyte

#2079 [Docs] How to display Flyte metrics stored in the admin DB Issue closed as not planned by github-actions[bot] flyteorg/flyte