How to get the record count of all tables in athena aws

Question

I'm trying to figure out how to get the total number of records across all tables (in all table schemas) in my aws Athena. The following is what I tried, but it appears that the information schema does not offer the record count. Someone please assist.

SELECT t.table_schema, t.table_name, t.table_rows
FROM   "information_schema"."schemata" s
INNER JOIN "information_schema"."tables" t on s.schema_name = t.table_schema
INNER JOIN "information_schema"."columns" c on c.table_name = t.table_name AND c.table_schema = t.table_schema
WHERE c.table_catalog = 'awsdatacatalog'