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'