Snowflake SELECT* Queries

November 18, 2025

Watch this short video to see how Revefi’s AI Agent, RADEN, identifies and analyzes excessive SELECT * queries that increase scan costs, slow down performance, and create unmanageable results across your Snowflake environment.

Our innovative technology empowers you to:

  • Identify how frequently SELECT * is used, including total counts, daily patterns, top users, and top warehouses
  • Understand the performance and cost impact of large scans driven by SELECT * usage, especially in DBT-driven workloads
  • Receive actionable recommendations to refine DBT policies, monitor large scans, and establish development guidelines to reduce unnecessary SELECT * usage

See our Agentic AI in Action Without Any Setup

Explore a secure test environment, and watch how Revefi’s AI Agent transforms your Snowflake query efficiency and development best practices instantly.

Try our Sandbox