LogoLogo
  • Introduction
    • Overview
    • Why Alvin?
    • Connect your systems
      • Data Warehouse
        • BigQuery
          • Provision source system credentials
          • Provision with GCloud CLI
        • Snowflake
        • Databricks
      • Business Intelligence
        • Looker
      • Orchestration
        • dbt
      • SSO (Single Sign-On)
    • Security & compliance
    • Types of metadata
    • FAQ
  • Cost Monitoring
    • Introduction to Cost Monitoring
    • Compute
    • Storage
  • BI Query Optimizer
    • Introduction to Query Optimizer
    • How does it work?
    • Getting started
  • Workflow automation
    • Introduction to Workflow Automation
    • Events definitions
    • Configuring Workflows
  • Anomaly Detection
    • Anomaly Detection
  • Exploring Metadata
    • Lineage
      • Depth of lineage
    • Impact Analysis
    • Entities
    • Entity View
    • Metadata Warehouse
Powered by GitBook
On this page
  1. BI Query Optimizer

Introduction to Query Optimizer

With Alvin's Query Optimizer it's possible to save more than 50% of your BI query spend automatically, with the flip of a switch!

The Query Optimizer is currently available for Looker, dbt and BigQuery, with more tools and data warehouses coming soon.

  • Whilst BigQuery/Looker is a great combination for BI, Looker generates very condensed and complex SQL from explores/filters and other sources of configuration like user attributes.

  • The generated SQL is not optimized to run in your data warehouse, leading to poor query performance and the busting of the BigQuery cache, even if the underlying data hasn't changed.

  • Many of these anti-patterns are, once you have the generated SQL, fixable on the fly.

  • Alvin's query optimizer is a proxy that intercepts and rewrites your Looker queries, allowing the same consistent data, delivered faster and cheaper, with zero impact on the results, and very little effort on the user end (simple configuration in Looker).

PreviousStorageNextHow does it work?

Last updated 2 months ago