Is there a way to get the latest values of all tables and their column names instead of selecting each table. I came across the following select query but it only returns column names and if I use * instead of column_name there is a lot of unnecessary details that I don't need.
SELECT column_name FROM information_schema.columns where table_schema = 'classicmodels' order by table_name, ordinal_position
I only need the column name that contains the latest record in that column.
I can read the latest records of all tables using phyton sql connector. There may be a better way to do this, but since I'm not allowed to work in a running database, I chose this method.