How to get the number of columns in one or more athena tables

Posted: 2021-02-01   |   Categories: tech

SELECT table_name, COUNT(*)
FROM   information_schema.columns AS columns_number
GROUP BY  table_name 
ORDER BY 2 desc