Shawn Wang (Airbyte)
08/16/2022, 5:07 PMOmni is comparable to existing BI tools like the aforementioned Looker and Tableau, Zima says. But the platform can also take raw SQL — the language used to communicate with databases — and break it into modeled components. Omni’s built-in tools generate data models and components from SQL, creating a “sandbox” data model and allowing users to promote metrics to the official, shared model that the whole organization can use. Beyond this, Omni runs “automated aggregates” in-database to accelerate queries and manage costs for users (and their employers).