SNOWFLAKE.ACCOUNT_USAGE

WAREHOUSE_METERING_HISTORY

This view tracks warehouse credit consumption and supports cost analysis. Unravel uses hourly credit usage patterns to identify underutilized warehouses, recommend right-sizing, and detect cost spikes. You can use this information for warehouse optimization and to monitor costs in dashboards.

SNOWFLAKE.ACCOUNT_USAGE

WAREHOUSE_EVENTS_HISTORY

This view records warehouse lifecycle events, such as creation, suspension, and resumption. Unravel uses these events to understand warehouse utilization patterns, identify idle periods, and correlate warehouse state changes with performance metrics for optimization insights.

SNOWFLAKE.ACCOUNT_USAGE

WAREHOUSE_LOAD_HISTORY

This view provides warehouse load and queuing metrics over time. Unravel analyzes these load patterns to identify performance bottlenecks, recommend warehouse scaling strategies, and detect when warehouses are over- or under-provisioned.

SNOWFLAKE.ACCOUNT_USAGE

COLUMNS

This view contains metadata about table columns, including data types and constraints. Unravel uses this metadata for data lineage tracking, analyzing schema evolution, and providing column-level insights to support query optimization and data governance.

SNOWFLAKE.ACCOUNT_USAGE

TAGS

This view stores tag definitions for data governance and classification. Unravel uses these tags to provide cost attribution by business unit, deliver data classification insights, and generate compliance reports based on tagged objects.

SNOWFLAKE.ACCOUNT_USAGE

TAG_REFERENCES

This view maps tags to specific database objects. Unravel uses these tag-object associations to provide cost allocation, generate chargeback reports, and deliver governance insights by analyzing resource consumption per tagged entity.

SNOWFLAKE.ACCOUNT_USAGE

TABLES

This view contains comprehensive table metadata, including row counts, sizes, and timestamps. Unravel analyzes this metadata to identify hot, warm, and cold tables; track table growth trends; detect unused tables for cost optimization; and provide storage insights.

SNOWFLAKE.ACCOUNT_USAGE

TABLE_STORAGE_METRICS

This view provides a detailed storage breakdown, including active, Time Travel, and Fail-safe bytes. Unravel analyzes this information to optimize storage costs, identify tables with excessive Time Travel usage, and recommend changes to storage policies.

SNOWFLAKE.ACCOUNT_USAGE

VIEWS

This view contains view metadata and definitions. Unravel tracks how each view is used, analyzes view complexity to optimize performance, and provides insights on view dependencies to support data lineage analysis.

SNOWFLAKE.ACCOUNT_USAGE

PROCEDURES

This view stores stored procedure metadata and execution history. Unravel monitors the performance of procedures, identifies inefficient procedures, and provides recommendations to optimize procedural code.

SNOWFLAKE.ACCOUNT_USAGE

QUERY_INSIGHTS

Contains AI-generated query optimization suggestions from Snowflake. Unravel enhances these insights with additional context, correlates them with cost impact, and provides prioritized recommendations for query optimization.

SNOWFLAKE.ACCOUNT_USAGE

TASK_VERSIONS

This view tracks task definition changes over time. Unravel uses this information to understand task evolution, correlate performance changes with task modifications, and provide insights on task optimization strategies.

SNOWFLAKE.ACCOUNT_USAGE

TASK_HISTORY

This view records task execution history, including success or failure status and duration. Unravel uses this information to monitor task reliability, identify failing tasks, analyze task performance trends, and provide alerts for task issues.

SNOWFLAKE.ACCOUNT_USAGE

TABLE_PRUNING_HISTORY

This view shows partition pruning efficiency for tables. Unravel analyzes pruning patterns to recommend clustering keys, identify tables that benefit from clustering, and optimize query performance through improved data organization.

SNOWFLAKE.ACCOUNT_USAGE

TABLE_DML_HISTORY

This view tracks DML operations, including INSERT, UPDATE, and DELETE, on tables. Unravel uses this information to understand data modification patterns, identify high-churn tables, and provide insights on data lifecycle management and optimization.

SNOWFLAKE.ACCOUNT_USAGE

STORAGE_USAGE

This view provides account-level storage usage metrics over time. Unravel uses these metrics to track storage trends, identify rapid growth patterns, forecast storage costs, and provide recommendations for storage optimization strategies.

SNOWFLAKE.ACCOUNT_USAGE

STAGES

This view contains metadata about stages used for data loading operations. Unravel monitors stage usage, analyzes data loading patterns, identifies unused stages, and provides insights to optimize data ingestion.

SNOWFLAKE.ACCOUNT_USAGE

METERING_DAILY_HISTORY

This table provides a daily summary of Snowflake credit consumption across all services. Unravel uses this aggregated data to monitor account-level cost trends, track budgets, analyze daily costs, and detect usage anomalies that could indicate unexpected spending or operational issues.

SNOWFLAKE.ACCOUNT_USAGE

METERING_HISTORY

This view tracks hourly credit usage across all Snowflake services. Unravel analyzes these records for comprehensive cost monitoring, service-level cost attribution, and identifying key cost drivers across Snowflake features. Hourly credit tracking allows teams to pinpoint usage spikes, attribute costs to specific activities or features, and support strategic cost optimization decisions.

SNOWFLAKE.ACCOUNT_USAGE

DATABASE_REPLICATION_USAGE_HISTORY

This view records database replication activities and associated costs. Unravel monitors replication expenses, analyzes replication patterns, and provides recommendations to optimize disaster recovery and cross-region data strategies. Account teams use these insights to control replication costs, manage backup schedules, and improve business continuity through efficient replication and failover planning.

SNOWFLAKE.ACCOUNT_USAGE

REPLICATION_GROUP_USAGE_HISTORY

This view tracks replication group usage and associated costs. Unravel uses these metrics to analyze the efficiency of multi-database replication, monitor replication group performance, and optimize strategies for cross-region data synchronization.The data helps identify usage patterns, control costs, and tune replication processes for better availability and disaster recovery.

SNOWFLAKE.ACCOUNT_USAGE

AUTOMATIC_CLUSTERING_HISTORY

This view shows usage and cost for Snowflake's automatic clustering service. Unravel analyzes clustering effectiveness, monitors clustering costs in relation to performance benefits, and provides recommendations on when to enable or disable automatic clustering for your tables. Reviewing automatic clustering metrics helps ensure your organization maintains optimal query performance while managing associated operational expenses.

SNOWFLAKE.ACCOUNT_USAGE

SNOWPIPE_STREAMING_FILE_MIGRATION_HISTORY

This view tracks Snowpipe streaming file migration activities and associated costs. Unravel monitors the performance of streaming ingestion, analyzes migration patterns, and provides insights to optimize real-time data loading operations in Snowflake. These metrics and analyses help teams ensure efficient, low-latency ingest for analytics workloads while controlling operational expenses.

SNOWFLAKE.ACCOUNT_USAGE

DATABASE_STORAGE_USAGE_HISTORY

This view provides database-level storage usage metrics over time. Unravel uses this information for database-specific storage analysis, to identify databases with rapid growth, and to provide targeted recommendations for optimizing storage per database. These insights support cost-efficiency, capacity planning, and proactive data management within each Snowflake database.

SNOWFLAKE.ACCOUNT_USAGE

STAGE_STORAGE_USAGE_HISTORY

This view tracks storage usage in Snowflake stages over time. Unravel monitors stage storage costs, identifies stages that have accumulated large or outdated files, and provides recommendations for stage maintenance and cleanup. These metrics support storage cost control and help teams optimize data management by proactively managing files stored in internal and external stages.

SNOWFLAKE.ACCOUNT_USAGE

SEARCH_OPTIMIZATION_HISTORY

This view records usage and maintenance costs for the Snowflake search optimization service. Unravel analyzes the return on investment (ROI) for search optimization, monitors ongoing maintenance expenses, and provides recommendations on when enabling or disabling search optimization will deliver the most value. These insights guide teams to ensure efficient spend and performance gains when using specialized search indexing features in Snowflake.

SNOWFLAKE.ACCOUNT_USAGE

DATA_TRANSFER_HISTORY

This view tracks cross-cloud and cross-region data transfer costs in Snowflake. Unravel monitors data egress charges, identifies expensive transfer patterns, and provides recommendations to minimize data transfer costs through architecture optimization. These insights help organizations control costs by analyzing transfer activities, optimizing data locality, and designing efficient sharing strategies across cloud regions and providers.

SNOWFLAKE.ACCOUNT_USAGE

QUERY_HISTORY

This view provides a comprehensive history of query execution along with detailed performance metrics. Unravel leverages this data as the foundation for query optimization, performing in-depth analysis of query performance, calculating cost per query, identifying expensive queries, and generating targeted SQL optimization recommendations. By examining execution history, organizations can detect resource-intensive or slow-running queries, enforce best practices, and continually improve the efficiency and cost-effectiveness of their Snowflake workloads.

SNOWFLAKE.ACCOUNT_USAGE

ACCESS_HISTORY

This view records detailed data access patterns, including which columns are read and modified by each query. Unravel uses this column-level access information for comprehensive data lineage tracking, understanding data usage patterns, identifying unused or redundant data assets, and delivering actionable insights for data governance and compliance monitoring. By analyzing access history, organizations can strengthen governance controls, streamline audits, and optimize the value, trust, and compliance of their Snowflake data assets.

SNOWFLAKE.ACCOUNT_USAGE

SESSIONS

This view contains user session information and connection details, including user names, authentication methods, client versions, and session activity timestamps. Unravel analyzes session patterns to understand user behavior, identify connection or authentication issues, monitor usage trends, and provide user activity insights for security and operational optimization. These metrics support auditing, troubleshooting, and best-practice analysis for Snowflake access patterns at the session level.