# Google Cloud ClickHouse

InstantML-hosted workspaces store run metadata and metrics in an
InstantML-owned ClickHouse deployment on Google Cloud, while account records
live in a separate control-plane Postgres database.

Premium workspaces that want product data in their own infrastructure can use
[customer-owned ClickHouse](/docs/guides/customer-owned-clickhouse.md) instead.

## Hosted topology

| Source | Service | Storage |
| --- | --- | --- |
| Browser / dashboard | Control and data services | Control-plane Postgres (account records) + InstantML-owned ClickHouse (tenant data) |
| Python SDK / uploader | Data service | InstantML-owned ClickHouse on Google Cloud |
| Artifact upload/download paths | Data service | Private object-storage artifact buckets |

The control service stores account, session, billing, API-key, and
tenant-route records in Postgres. The data service stores projects, runs,
metrics, console logs, attributes, artifacts, reports, imports, and usage
snapshots for the authenticated workspace in its routed ClickHouse database.

## Tenant isolation

Tenant databases are routed by workspace. Each tenant database owns its
product tables and metric tables, and account records stay in the separate
control-plane database.

Hosted artifact bytes are not stored in ClickHouse. They live in private
per-workspace object-storage buckets; ClickHouse stores only the artifact
metadata: byte count, hash, MIME type, and an opaque storage reference.
Downloads stream through the InstantML API rather than exposing bucket URLs.

Usage accounting follows the same boundary. Metric-point counts are always
bound to the resolved workspace. Exact warehouse-storage bytes are counted
only when a ClickHouse database is scoped to a single workspace; shared cells
and customer-owned deployments use workspace-local artifact and metadata
accounting instead.

Production and staging environments run as separate services with separate
control-plane databases, so staging traffic cannot write production records.

## What this means for you

- The SDK and dashboard APIs are the same regardless of which storage path
  your workspace routes to.
- Run-list and chart endpoints stay bounded; raw metric history is fetched
  through dedicated series endpoints.
- Artifact uploads and downloads always go through InstantML API routes.
- Customer-owned GCP ClickHouse remains available for Premium teams.

## Current benchmark signal

The hosted GCP ClickHouse path has been benchmarked through the production
data service against the `normal-runs-50k` showcase project: 50,000 runs and
522,000,000 metric points (measured 2026-05-23).

| Query | p95 |
| --- | ---: |
| Project newest-100 run list | 236 ms |
| Metric-best sort | 307 ms |
| Project overview | 418 ms |
| 1,000-point chart read from a 20,000-step series | 224 ms |

See [Benchmarks](/docs/benchmarks.md) for the full methodology, fairness notes, and
comparison data.

## Next steps

- [Benchmarks](/docs/benchmarks.md)
- [Customer-owned ClickHouse](/docs/guides/customer-owned-clickhouse.md)
- [Storage model](/docs/architecture/storage-model.md)
- [Service planes](/docs/architecture/service-planes.md)
- [Health and observability API](/docs/api/health-observability.md)

## Agent navigation

- [Docs index](/llms.txt)
- [Full docs bundle](/llms-full.txt)

### Get Started

- [Overview](/docs/index.md)
- [Quickstart](/docs/quickstart.md)
- [Core Concepts](/docs/concepts/core-concepts.md)
- [Pricing](/docs/pricing.md)
- [Benchmarks](/docs/benchmarks.md)
- [Examples](/docs/guides/examples.md)
- [Troubleshooting](/docs/troubleshooting.md)

### SDK

- [Installation Auth](/docs/sdk/installation-auth.md)
- [Logging](/docs/sdk/logging.md)
- [Tracing](/docs/sdk/tracing.md)
- [Metrics Steps](/docs/sdk/metrics-steps.md)
- [Config Tags Notes](/docs/sdk/config-tags-notes.md)
- [Artifacts Checkpoints](/docs/sdk/artifacts-checkpoints.md)
- [Rich Objects](/docs/sdk/rich-objects.md)
- [Distributed Training](/docs/sdk/distributed-training.md)
- [Console System Integrations](/docs/sdk/console-system-integrations.md)
- [Reliability](/docs/sdk/reliability.md)
- [Cli Login](/docs/sdk/cli-login.md)
- [Querying Data](/docs/sdk/querying-data.md)
- [Agent Mcp](/docs/sdk/agent-mcp.md)
- [Examples Patterns](/docs/sdk/examples-patterns.md)

### Integrations

- [Overview](/docs/integrations/overview.md)
- [Pytorch Lightning](/docs/integrations/pytorch-lightning.md)
- [Huggingface Transformers](/docs/integrations/huggingface-transformers.md)
- [Keras](/docs/integrations/keras.md)
- [Wandb](/docs/integrations/wandb.md)

### Dashboard

- [Tour](/docs/dashboard/tour.md)
- [Organizations Workspaces](/docs/dashboard/organizations-workspaces.md)
- [Runs Workspace](/docs/dashboard/runs-workspace.md)
- [Metrics Charts](/docs/dashboard/metrics-charts.md)
- [Run Detail](/docs/dashboard/run-detail.md)
- [Traces](/docs/dashboard/traces.md)
- [Compare Runs](/docs/dashboard/compare-runs.md)
- [Research Dashboards](/docs/dashboard/research-dashboards.md)
- [Artifacts Files](/docs/dashboard/artifacts-files.md)
- [Run Health](/docs/dashboard/alerts.md)
- [Datasets](/docs/dashboard/datasets.md)
- [Checkpoints](/docs/dashboard/checkpoints.md)
- [Reports](/docs/dashboard/reports.md)
- [Settings Api Keys](/docs/dashboard/settings-api-keys.md)
- [Api Tab](/docs/dashboard/api-tab.md)
- [Onboarding Team Billing](/docs/dashboard/onboarding-team-billing.md)

### Data

- [Imports](/docs/guides/imports.md)
- [W&B alternative](/docs/guides/wandb-alternative.md)
- [InstantML vs MLflow](/docs/guides/instantml-vs-mlflow.md)
- [W&B import guide](/docs/guides/wandb-import-guide.md)
- [W&B and Neptune imports](/docs/guides/wandb-neptune-imports.md)
- [Export Usage Limits](/docs/guides/export-usage-limits.md)
- [Pricing Limits Billing](/docs/guides/pricing-limits-billing.md)
- [Auth Billing Storage](/docs/guides/auth-billing-storage.md)
- [Customer Owned Clickhouse](/docs/guides/customer-owned-clickhouse.md)
- [Observability](/docs/guides/observability.md)

### API

**Practical API guides**

- [Authentication](/docs/api/authentication.md)
- [Errors And Limits](/docs/api/errors-and-limits.md)
- [Health Observability](/docs/api/health-observability.md)
- [Projects Runs](/docs/api/projects-runs.md)
- [Metrics Series](/docs/api/metrics-series.md)
- [Attributes Objects](/docs/api/attributes-objects.md)
- [Artifacts](/docs/api/artifacts.md)
- [Reports](/docs/api/reports.md)
- [Iframe Embeds](/docs/api/iframe-embeds.md)
- [Import Export Usage](/docs/api/import-export-usage.md)
- [Dashboard Control State](/docs/api/dashboard-control-state.md)
**Architecture**

- [System Overview](/docs/architecture/system-overview.md)
- [Service Planes](/docs/architecture/service-planes.md)
- [Storage Model](/docs/architecture/storage-model.md)
- [Google Clickhouse](/docs/architecture/google-clickhouse.md) (current page)
- [Auth Tenancy](/docs/architecture/auth-tenancy.md)
- [Schema Reference](/docs/architecture/schema-reference.md)

### API Reference

- [API Reference](/docs/api-reference.md)
