Find number of tables in Snowflake

Query below returns total number of tables in current database.

Query

select count(*) as tables
from information_schema.tables 
where table_type = 'BASE TABLE';   

Columns

  • tables - number of tables in a database

Rows

Query returns just one row.

Sample results

Those results show that there are 87 tables in SNOWFLAKE_SAMPLE_DATA database.

0
There are no comments. Click here to write the first comment.