'How to get stats for all tables in a schema (Presto)?

I'm trying to get the stats (particularly the row_count and the max value for one column that is common for all tables) for all the tables in a particular schema. I know I can run this command to get what I need:

SHOW STATS FOR SCHEMA.TABLE

However this only works for 1 table at a time. Is there any way to have a similar output, but for all tables in a particular schema in Presto?

Thanks a lot for any help!

sqlpresto


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions