Your BigQuery data.
Any business app.

You moved to BigQuery to leave behind extracts, stale copies and per-seat bills. Most BI tools just rebuild them on top – and still only hand you a chart to read.

Describe the app you need and Astrato builds it: live on BigQuery, with writeback, so your team acts on the numbers instead of just reading them. No copies, nothing leaves Google Cloud.

Google Analytics dashboard displaying website audience metrics, page views vs product detail views bar chart, bounce rate and new visits statistics, traffic heatmap by hour and day, top 10 bounce rates by page bar chart, sessions by channel horizontal bars, and AI-generated insights on trends and growth.

What teams build on Astrato + BigQuery

Data Apps & Workflows

Write back to BigQuery from any app and chain no-code actions into guided workflows – approvals, forecasts, scenario plans. Act on the numbers without leaving the app.

See Data Apps in Action

Customer-Facing Apps

Embed pixel-perfect, white-labelled apps in your product in days – multi-tenant by design, isolated at BigQuery's own row level.

See Embedded Apps

Guided Self-Service

Business users explore live BigQuery data through no-code apps on a governed semantic layer – self-service that never breaks the numbers.

Explore Self-Service

A modern warehouse with read-only BI bolted on top is half a migration.

Astrato is the half that finishes it – live queries and data apps, native to BigQuery.

Nothing to size, nothing to run – live from BigQuery

BigQuery is serverless, and Astrato keeps it that way: no BI engine in the middle, no warehouse to provision, no cluster to right-size. Queries push straight down to BigQuery and scale themselves from fifty users to five thousand, while repeat views come back from cache for free. Your internal apps, customer-facing embeds and workflows all run on that one serverless connection.

Describe the app. Nash builds it on BigQuery.

Nash, Astrato's AI assistant, turns a plain-language request into a working app – semantic model, pages and all – on live BigQuery data. Each query runs inside that user's BigQuery IAM rules, and you pick the LLM, governed feature by feature. Prefer Claude or ChatGPT? Connect them through MCP and they work from the same governed definitions.

The whole setup is a Google sign-in.

Sign in with OAuth and Astrato inherits your BigQuery IAM and row-level rules – no keys to hand around, nothing to provision. (Need service-to-service? A JWT service account works too.) Pick a project and dataset, name the connection, and your first live app is minutes away.

Dashboard showing product sales metrics with total sales $551.61k, average sales per order $163, 339 customers per month, average basket size 21 items, and 77 SKUs. Includes charts for sales by month and year, revenue target reached, product count by price range, category sales by month, category sales totals, and top 5 products.

We moved to BigQuery to modernize our data infrastructure… Astrato gave us everything we wanted – an intuitive UI that enables self-service across the organization, native writeback and a baked-in semantic layer for governed AI use cases.

Rod Menchaca Betancur
Global Director of Digital Skin, ISDIN
g2-score-5

Everything you need to build business apps on BigQuery

Semantic
Layer

Define each metric once, get the same numbers in every app.

IAM & Row-level security

Access controls, row-level security and column masking, inherited on every query.

Native
Writeback

From any app, straight to native BigQuery tables.

Executive reports

Branded reports in PDF, Excel, or PPT, delivered on a schedule. The data comes to them.

Custom Report

A sandbox where users build their own views from pre-approved dimensions and measures.
Automate branded Excel, PDF, or PPT reports to Email or Slack

AI insights in every app

Trends, anomalies, and natural language queries. Surfaced automatically, grounded in your semantic layer.
Direct writeback with real-time sync

Google checked our work – and called it Cloud Ready.

Astrato earned the Google Cloud Ready – BigQuery designation after a technical review by Google Cloud's own engineering team – validated against enterprise-grade standards for performance, security and governance.

Connect Astrato to BigQuery

Build your first app on BigQuery

Describe what you need – Astrato builds it on live BigQuery data.
SOC 2 Type II & ISO 27001
GDPR Compliant
Predictable costs

Frequently asked questions

We're already on Looker / Looker Studio. Why add Astrato?

Because reporting is where they stop. Looker and Looker Studio are built to show you the numbers. Astrato is built to act on them – writeback, no-code data apps, approval flows and customer-facing apps, all on the same live BigQuery data. Sometimes teams run Astrato alongside Looker rather than instead of it: Looker for governed reporting, Astrato for the work that has to write back, ship to customers, or move at self-service speed. But you can achieve both in Astrato.

Do we have to move or copy our data into Astrato?

Astrato queries BigQuery live – no extracts, no copies, nothing leaving Google Cloud. Every app reads the current data in your warehouse, so there's no overnight refresh to wait on and no second copy for security to worry about.

How do security and governance work?

Astrato inherits them. Connect with OAuth and every user queries BigQuery under their own Google identity, so IAM permissions, row-level security and column masking all carry through automatically – there's no second rulebook to maintain, and nothing for governance to drift away from. For the IT review: ISO 27001, SOC 2 Type II and HIPAA, on a Google-validated integration.

Can users write data back to BigQuery?

Yes. Writeback updates your BigQuery tables directly from an app – approvals, forecasts, status changes, scenario inputs – and BigQuery time travel lets you look back at or restore a table's earlier state. It's what turns a read-only report into a data app.

Can we embed Astrato in our own product?

Yes – pixel-perfect, white-labelled apps embed in your product in days, multi-tenant by design and isolated at BigQuery's own row level. Enolytics built their entire customer-facing product on BigQuery and Astrato, serving real-time insights to any number of customers without ever moving data out of the warehouse.

We're moving off Tableau / Power BI / Qlik. How painful is the switch?

Less than you'd expect, because Nash does the rewriting. Paste in your old logic – Qlik set analysis, Power BI DAX, Tableau, even Excel – and Nash translates it to its BigQuery-native equivalent, shown next to the original so you can check it before you trust it. The migration that usually eats weeks tends to take an afternoon.