| Category | AI-native analytics engine with an integrated data stack | Enterprise BI suite with a governed LookML semantic layer |
|---|
| Who it is built for | AI product and analytics teams, plus anyone who works with data — spreadsheet users through ML engineers | A central BI or analytics org serving the wider enterprise |
|---|
| Primary interface | The agent you already use, over MCP — plus Workspaces, notebooks, reports and data apps for the people who want a UI. All of them consume the same model rather than being the place it lives | Its own UI — dashboards and Explores to consume, LookML authored in-app, with Gemini chat alongside |
|---|
| Modeling language | Malloy — a modeling and query language with imports, inheritance, and public and private members | LookML — a declarative modeling format, paired with Looker’s own query generation |
|---|
| What is open | Open core. Malloy is open source, and we build and maintain Malloy Publisher, the open-source server for Malloy models. Your model is code in your repository, and Credible is in the Apache Ossie ecosystem for semantic interchange | Vendor-owned — LookML and the platform are Google Cloud products, and Looker now reads BigQuery and Snowflake semantic definitions |
|---|
| How the model gets built | A coding agent with open-source MCP tools and agent skills, capturing context from where it already lives | Hand-authored LookML, maintained by data engineers |
|---|
| Governance | Governance as code. Access rules are annotations in the model itself — versioned, reviewed and composable like any other code | access_filter and access_grants, declared in LookML and keyed to user attributes managed in Looker |
|---|
| Materialization and caching | One annotation on the source, in the same file as the logic it materializes — no derived-table block, no rollup definitions, no refresh triggers, no orchestration run to schedule. Optional per source: query your own warehouse directly, or hold a source hot in Credible’s in-memory serving layer, which is how a team on Postgres gets fast serving without buying a warehouse to get it | Persistent derived tables, materialized as real warehouse tables on a TTL or trigger, plus aggregate awareness. Mature and warehouse-native |
|---|
| How an agent finds the right data | Search. Typed targets — source, dimension, measure, view, even a dimensional value — are matched against an index of the model and come back ranked, so an agent asks for what it needs instead of picking a model and touring it | A walk through the model: get_models, then get_explores for a model, then get_dimensions and get_measures for an Explore, per Google’s own guide |
|---|
| Where the model can be used | One model served to every surface — agents over MCP, plus APIs, an SDK, embedded dashboards, notebooks and HTML data apps. Results carry an interactive UI resource (MCP Apps, the official extension), so a client that supports it renders a real chart or table instead of the model re-narrating rows | The Looker UI, embeds and its API, plus a managed MCP server; also reads BigQuery and Snowflake semantic definitions |
|---|
| Scale and portability | Built for globally distributed, high-availability workloads. Warehouse-agnostic on open-source Malloy — BigQuery, Snowflake, Postgres, MySQL, Trino, Presto and DuckDB, which also reads Parquet straight out of object storage including Azure Data Lake — so the model travels | Runs in a Looker instance, with gravity toward BigQuery |
|---|
| What you pay for | Usage, not seats — unlimited users on every plan, so adding people never changes the bill. Metered per organization on tokens, bytes processed, bytes served and hot storage, starting free. Your own agent’s tokens are never billed, and a query that runs on your own warehouse is not metered for the scan — only for the result it hands back | A platform fee plus per-user licences by role, with token overage announced for its AI features from late 2026 |
|---|