Top Gradient

How can I find Unused Tables and Schemas in SELECT?

Method 1: Using Insights

Go to the Insights page, Explorer tab (at the top), then add a filter for "Insight is Unused Table"

Insights Explorer tab filtered to the "Insight is Unused Table" condition

Method 2: Using the Storage page

You can create a flexible, customizable view of unused tables or schemas on the Storage page by applying filters. Navigate to the Tables or Schemas tab.

The example below shows advanced filters on the Schemas tab to find schemas that haven’t been queried or altered in the last 30 days. The same approach works on the Tables tab. You can set any date range you prefer, or remove the “last altered” filter to identify tables or schemas that no one is reading but have active ETL.

Schemas tab filtered to schemas not queried or altered in the last 30 days

Get up and running in less than 15 minutes

Connect your Snowflake, Databricks, or BigQuery account and instantly understand your savings potential.

CTA Screen