List 10 largest tables in Snowflake

Query below returns top 10 largest tables (largest by bytes accessed by a scan of the table) in a database with space they use.


select table_schema,
       round(bytes/1024/1024, 2) as table_size
from information_schema.tables
where table_type = 'BASE TABLE'
order by table_size desc
limit 10;


  • table_schema - name of table schema
  • table_name - name of table
  • table_size - space used by table in MB


  • One row represents one table in a database
  • Scope of rows: top 10 tables in a database by data size
  • Ordered by table used size from largest to smallest

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.