How to get the number of columns in one or more athena tables
Connections
Enjoy
SELECT table_name, COUNT(*)
FROM information_schema.columns AS columns_number
GROUP BY table_name
ORDER BY 2 desc
Enjoy
SELECT table_name, COUNT(*)
FROM information_schema.columns AS columns_number
GROUP BY table_name
ORDER BY 2 desc