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 analytical interface — sidebar, drop zones, toolbar, results table.
Created - Saiku UI Querying Building a query
Drag, drill, filter, sort — 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
Picking the right chart type for your question — bar, line, pie, sunburst, treemap, heatmap, and the variants.
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
Group schemas by environment, audience, or customer — useful once your tenant has more than a handful of cubes.
Created - Dashboard Usage Usage
Hourly and daily request volume, latency percentiles, error rate, and storage quota.
Created - Dashboard Schemas Schemas
The cube catalog — every Mondrian schema your tenant has saved, plus the XML editor.
Created - Dashboard Schema Designer Schema designer
Draft a working Mondrian cube in minutes — Saiku samples your warehouse, Claude proposes the model, you tweak and save.
Created - Dashboard Members Members
Invite teammates, set roles, and revoke access. Available on Team and above.
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 — orientation, next steps, and quick links.
Created - Dashboard Files Files
Upload Parquet, CSV, or JSON when you don't have a warehouse — prototype a cube against a file in minutes.
Created - Dashboard Cube Library Cube library
Pre-built cube templates for common domains — adopt one in a couple of clicks and adapt to your warehouse.
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 Connections
Save warehouse credentials so the rest of Saiku Cloud can read your data.
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 that call Saiku Cloud from outside the dashboard.
Created - Dashboard Analyze Analyze
The cube directory — every cube your tenant has, with one-click launch into the Saiku UI for ad-hoc query.
Created - Dashboard Account Account
Tenant identity, your tenant ID for support tickets, and the self-serve deletion flow.
Created - API Spaces Agent Spaces
Named admin-authored personas that scope an AI ask. Each space bundles a system prompt, cube allowlist, skill allowlist, and suggested prompts — enforced server-side so users can't escape the persona by injecting their own cube refs.
Created - API Skills Agent Skills
Admin-authored markdown workflows the AI Ask endpoint discovers automatically. Turn your team's canonical questions into slash-commands agents (and users) invoke by name.
Created - API React SDK React SDK
Typed React wrapper around the <saiku-embed> Web Component. Same runtime, typed props, autocomplete-friendly imports for React shops.
Created
No docs changed in this range.