Welcome
Find your way around Saiku
Guides, references, and answers to common questions.
Getting started
Quick overview of the Saiku Cloud workflow.
- 1Connect a warehouseAdd Postgres, Snowflake, BigQuery, ClickHouse, or MotherDuck. Credentials are encrypted at rest; queries run against your warehouse on demand.
- 2Design a cubeDescribe what you want to measure in plain English. Claude proposes a Mondrian cube; you tweak measures, dimensions, and joins inline.
- 3Query & exploreOpen the Saiku UI with your cube preloaded. Drag fields onto rows and columns, save workbooks, share with teammates.
Documentation
Guides for every dashboard surface.
Frequently asked questions
Common questions about Saiku Cloud.
Can I use my own data warehouse?
Yes. Saiku Cloud connects to your existing Postgres, Snowflake, BigQuery, ClickHouse, or MotherDuck instance. Credentials are stored encrypted (Vault Transit + KMS). We never copy your data — queries run against your warehouse on demand.
How does the AI cube designer work?
You point at a warehouse table and describe what you want to measure in plain English. Claude proposes a Mondrian cube — measures, dimensions, joins. You review and tweak inline, then save. The AI only sees schema metadata, never row-level data.
Is Saiku Cloud different from the open-source engine?
Saiku Cloud is the hosted control plane wrapped around the open-source engine. It adds tenant isolation, audit logging, SSO, hosted schema authoring, KMS-encrypted credentials, and an agent gateway. The query engine itself remains open source.
What's included in the 14-day trial?
Every plan starts with a 14-day free trial — no card required. You get the full feature set of whichever tier you pick during sign-up. After 14 days, add a card to continue or downgrade.
Do you support SSO?
SAML SSO is available on Team and above. Enterprise customers get SCIM provisioning and a dedicated single-tenant VPC.
Recently updated
Docs that changed most recently.
- Self Hosting Self-hosting Saiku
Run Saiku on your own infrastructure — Docker, upgrades, backups, sizing, auth. Same Apache 2.0 build the Cloud runs on.
Created - Security Tenant Isolation Tenant isolation
How Saiku Cloud keeps your cubes, queries, and data invisible to other customers.
Created - Security Posture Security & trust posture
Where Saiku Cloud stands today on compliance, encryption, isolation, incident response, and third-party attestations — kept honest and current.
Created - Saiku UI Workbench The Saiku workbench
A tour of the Query Editor — cube picker, shelves, toolbar, and the five ways to view a result.
Created - Saiku UI Querying Building a query
Drag, drill, filter, sort, rank — the actual mechanics of getting numbers out of a cube.
Created - Saiku UI MDX And Export MDX & export
The MDX editor for power users, and how to get data out to Excel, CSV, and PDF.
Created - Saiku UI Getting Insight Getting insight from your data
How analysts actually use Saiku to answer real questions — patterns, anti-patterns, and a worked example.
Created - Saiku UI Charts Charts and visualisations
Sixteen chart types, when each one earns its place, and the editor controls that make a chart presentable.
Created - Saiku UI AI Query Ask the AI
The Saiku workbench's chat panel — type a question, get a query, drop it into the canvas.
Created - Plans Whats Included What's included
Compare Saiku Cloud plans — what each tier unlocks, side by side.
Created - Plans Trial And Billing Trial, billing & cancellation
How the 14-day trial works, what happens at trial end, and how to manage your subscription.
Created - Mondrian YAML Schemas YAML schemas
Write Mondrian-4 schemas in readable, diffable YAML — full element reference with examples.
Created - Mondrian Well Known Extensions Well-known Ossie extensions
The saiku.* well-known keys on Ossie custom_extensions[] — override display, gate visibility by role, and grade PII redaction from a single vendor blob.
Created - Mondrian Time Intelligence Time intelligence (declarative YoY, PoP, YTD, rolling)
Declare common time-intelligence metrics with <TimeCalc> instead of hand-writing MDX — year-over-year, period-over-period, year-to-date, and rolling window calculations in Mondrian 4.
Created - Mondrian SQL Adapter SQL adapter over Apache Ossie
Query your Ossie semantic models with standard SQL via Apache Calcite — a portable JDBC surface that pushes SELECT, WHERE, GROUP BY and JOIN down to your warehouse.
Created - Mondrian Semantic Annotations Saiku semantic annotations
The saiku.semantic.* annotation namespace — describe measures and levels for the AI Ask layer, mark PII columns, and enforce policy at query time.
Created - Mondrian Schema Structure Schema structure
A tour of the top-level layout of a Mondrian-4 schema — the XML document hierarchy, the Schema element, and how Annotations work.
Created - Mondrian Query Parameters Query-context parameters
Declare bounded, typed, sandboxed parameters that resolve per-request from a user's session attributes — and use them to restrict rows or switch fields without free-form SQL templating.
Created - Mondrian Physical Schema Physical schema
Tables, columns, calculated columns, inline tables, SQL queries, physical links, table hints, snowflake dimensions, and shared dimensions in Mondrian 4.
Created - Mondrian Ossie Export Exporting to Apache Ossie
Convert your Mondrian schema into Apache Ossie YAML — a portable, vendor-neutral semantic model format the wider analytics ecosystem can consume alongside Saiku.
Created - Mondrian Observability Observability: metrics and the Calcite parity guard
The OpenTelemetry metrics Mondrian emits — queries, SQL, segment cache, Calcite fallback — plus the opt-in Calcite parity guard that surfaces silent "valid-but-wrong SQL" divergences.
Created - Mondrian LookML Migration Migrating from Looker (LookML)
Import Looker LookML models into Mondrian-4 schemas with a validating transpiler — a migration accelerator with a hard safety gate, plus a coverage report that tells you exactly what ports and what does not.
Created - Mondrian Mondrian schemas
What a Mondrian schema is, how XML and YAML both work in Saiku, and where to go next.
Created - Mondrian Extensions Extensions: functions and formatters
Extend your Mondrian schema with user-defined functions, custom cell/member/property formatters, and multi-language caption support.
Created - Mondrian Dimensions Dimensions, attributes and hierarchies
How Mondrian-4 dimensions, attributes, hierarchies, levels, and related features work — from simple star schemas to snowflake joins, time dimensions, member properties, and SQL optimizations.
Created - Mondrian Currency Conversion Currency conversion (declarative FX via <CurrencyConversion>)
Declare foreign-exchange conversions directly in a Mondrian 4 schema — effective-date interval band joins pick the right rate automatically, no hand-written MDX required.
Created - Mondrian Cubes And Measures Cubes and measures
How Mondrian-4 cubes, measure groups, and measures work — fact tables, aggregator types, format strings, and calculated columns.
Created - Mondrian Cli Schema CLI
Convert Mondrian schemas between XML and YAML, and lint them, from the command line.
Created - Mondrian Advanced Advanced: virtual cubes, parent-child, calculated members
Multi-fact cubes via multiple measure groups, parent-child hierarchies with closure tables, calculated members, named sets, and bridge (many-to-many) dimensions in Mondrian 4.
Created - Mondrian Access Control Access control and roles
Define roles in your Mondrian schema to control which cubes, dimensions, hierarchies, and members each user can see.
Created - Help Contact Contact Support
How to reach the Saiku team — support, sales, and security disclosure.
Created - Help Common Issues Common Issues
Troubleshooting Saiku Cloud — known problems and how to work around them.
Created - Getting Started Quickstart
Five minutes from sign-up to your first cube query. Prefer to try before signing up? A no-signup path with screenshots at the bottom.
Created - First Cube Sign up & first cube
Step-by-step walkthrough from fresh signup to a working cube with sample data.
Created - Dashboard Workspaces Workspaces
Your tenant's workspace, the cubes your key can reach inside it, and the Mondrian roles applied to your queries.
Created - Dashboard Usage Usage
Request volume, latency percentiles, error rate and storage quota — the last 30 days by default.
Created - Dashboard Schemas Schemas
The cube catalog — every schema your tenant has saved, every version of it, and the three ways to start a new one.
Created - Dashboard Schema Designer Schema designer
Two ways to build a Mondrian cube — draw it on the visual canvas, or describe it in a sentence and let AI draft it.
Created - Dashboard Members Members
Invite teammates, pick their role, and revoke access — plus the invite link you'll need to send yourself.
Created - Dashboard Measure Lineage Measure lineage
Browse a schema's cubes, measures, and dimensions in the Lineage Explorer — and trace each back to its physical table, columns, and database. Team tier and above.
Created - Dashboard Home Home
The landing page after you sign in — quick actions, your team, traffic in the last 24 hours, and what you edited most recently.
Created - Dashboard Files Files
Upload CSV, Parquet, JSON or Excel and Saiku builds a database from them — a queryable cube without a warehouse.
Created - Dashboard Embed Tokens Embed tokens
Every embed token minted for your saved queries and dashboards — what it reaches, whether PII redaction is forced on it, and how to revoke it.
Created - Dashboard Cube Library Cube library
Four ready-made cubes for common domains. One click creates the tables, seeds sample data, and deploys a queryable cube.
Created - Dashboard Connections Snowflake Connecting a Snowflake warehouse
Connect a Snowflake account to Saiku Cloud — role + user, JDBC URL, and the wizard.
Created - Dashboard Connections Postgres Connecting a Postgres warehouse
Connect a PostgreSQL database to Saiku Cloud — allowlist, read-only role, JDBC URL, and the wizard.
Created - Dashboard Connections Mysql Connecting a MySQL / MariaDB warehouse
Connect a MySQL or MariaDB database to Saiku Cloud using the bundled MariaDB Connector/J driver.
Created - Dashboard Connections Motherduck Connecting MotherDuck
Connect a MotherDuck (cloud DuckDB) database to Saiku Cloud — token-based, no firewall setup.
Created - Dashboard Connections Foodmart Downloads FoodMart sample datasets
Pre-packaged FoodMart for every supported dialect — load it into your test instance to try Saiku Cloud before connecting your real warehouse.
Created - Dashboard Connections Duckdb File Querying an uploaded file via DuckDB
Saiku Cloud's Starter-tier data path — upload a parquet/CSV/JSON and query it in-process via DuckDB.
Created - Dashboard Connections Clickhouse Connecting a ClickHouse warehouse
Connect ClickHouse Cloud or self-hosted ClickHouse to Saiku Cloud via the HTTP-based JDBC driver.
Created - Dashboard Connections Bigquery Connecting a BigQuery warehouse
Connect a Google BigQuery dataset to Saiku Cloud using a service-account JSON key.
Created - Dashboard Connections Data sources
Connect a warehouse you already run, or upload files and let Saiku build a database from them.
Created - Dashboard Connected Agents Connected agents
The AI assistants connected to your cubes over MCP — see which ones hold access, when they last used it, and cut any of them off.
Created - Dashboard Billing Billing
Start a trial, view your plan, or manage your subscription via the Stripe Customer Portal.
Created - Dashboard Audit Log Audit log
Every meaningful action in your tenant — who did what, when, with what outcome. Team tier and above.
Created - Dashboard API Keys API keys
Bearer tokens for agents and integrations — including the cube allowlist that keeps one key from seeing everything.
Created - Dashboard Analyze Analyze
The cube directory — every cube your tenant has, its health, and one click into the Saiku UI to query it.
Created - Dashboard Account Account
Your profile, your tenant's identity and the ID support will ask for, and the self-serve deletion flow.
Created - App Builder Theming Design & theming
Brand an App without code — the Design inspector gives you a preset gallery, colour/type/form pickers, describe-your-brand, and graphical control over the header, navigation, assistant and pages.
Created
No docs changed in this range.