Skip to main content

Certification track: Professional Cloud Database Engineer (PCDE)

Metabase on GKE Autopilot

Metabase on GKE Autopilot

Metabase is an open-source business intelligence and analytics platform that lets non-technical users query, visualise, and share data without writing SQL. This module deploys Metabase on GKE Autopilot on top of the App_GKE foundation, which provisions and manages the shared Google Cloud and Kubernetes infrastructure.

This guide focuses on the cloud services Metabase uses and how to explore and operate them from the Google Cloud Console and the command line. For the mechanics that are common to every GKE application — Workload Identity, ingress, autoscaling, CI/CD, Cloud Armor, IAP, Binary Authorization, VPC Service Controls, backups, and the deployment lifecycle — refer to the App_GKE foundation guide rather than repeating them here.


What Metabase costs on RAD, and how that compares​

Running Metabase in your own GCP project costs about $136.37/month in Google Cloud charges; RAD's module fee is a one-time 175 credits (or 157.5 credits in a RAD-managed project), covering setup and support -- not the ongoing cloud bill, which Google bills you directly in your own project or RAD meters hourly in credits in a RAD-managed one. If a lower running cost matters more than the deployment target, see the Cloud Run guide for the lower-cost option; otherwise, if you deploy into a RAD-managed project you can pause the whole thing for free when you are not using it -- see Pause it for free below.

What you pay on RAD​

Your own projectRAD-managed project
Module fee175 credits, once157.5 credits, once (10% lower)
Build timemetered in credits as the build runs (a few credits, typically)same
Google Cloud running cost~$136.37/month, billed to your own billing account at Google's list price~105 credits/day, metered hourly by RAD at list price plus margin

Default running cost in your own project

ResourceUS$/month (Google list price, us-central1)
GKE Autopilot pod, 2x vCPU / 4 GiB$79.35
Cloud SQL for PostgreSQL, 1 vCPU / 3.75 GB, zonal, 10 GB SSD$51.02
Cloud NAT and networking$5.00
Cloud Storage (add-ons, backups)$1.00
GKE cluster management feeshared across every GKE app in the project; $0 if this is your only cluster, else ~$73
Total$136.37

How it compares​

  • Metabase's own official managed cloud (Metabase Cloud) starts at $90/month (Starter, billed monthly; $100/month list) (source: https://www.metabase.com/pricing), run by the project itself with no infrastructure to operate -- the comparison that matters here is less the sticker price and more whether you want the vendor's own cloud or your own GCP project with RAD managing it.
  • Running it yourself on a bare VPS is still the cheapest cash option -- Hetzner CPX22 (2 vCPU/4GB) runs about $24/month, a DigitalOcean 2 vCPU/4GB Droplet is also $24/month, and a GCP Compute Engine e2-standard-2 (2 vCPU/8GB) is about $49/month -- plus the admin's own time for backups, security patches and upgrades, which RAD's managed Cloud SQL, Secret Manager and monitoring cover for you -- but RAD's price is never meant to beat a VPS, only to replace the admin time a VPS still needs.
  • Either way, this is a team BI/analytics tool queried occasionally rather than continuously, so the running cost above is what actually drives the bill, not the module fee -- and that running cost is the one you can pause (see below).

Pause it for free: delete a RAD-managed project, restore it when you need it​

This is the headline for a RAD-managed project. Deleting a RAD-managed project first unlinks its billing, then asks Google to delete the project outright -- Google's own 30-day recoverable soft delete. Unlike deleting one module, this does not tear down Cloud SQL, any VM or the compute resource one by one: the whole project simply stops, and nothing is charged while it waits, because billing is already unlinked.

Restoring, within 30 days and only by the project's owner, asks Google to undelete the project and reattaches its billing account, then asks you to run Update on each deployment to confirm everything came back. Because nothing was individually destroyed, that Update finds the same resources already there -- it is a check, not a rebuild, and an Update never charges the module fee again. This costs only a handful of credits (under US$1) in total for a typical 2-3-deployment chain.

What this needs: you must own the project (not one RAD only manages billing for), you must restore it yourself within 30 days -- after that Google deletes it for good -- and restoring is admitted like creating a new project, so your purchased credit balance must still clear the tier's floor (100 credits for the sandbox tier most study/demo use fits). Google says most services are fully working again within 36 hours of a restore.

One real gap: nightly backups are written to a bucket inside the project, and that bucket has Cloud Storage's soft-delete explicitly turned off, so it is very likely gone as soon as you delete the project -- even though the project itself is recoverable for 30 days. If you have customised the app and want to keep that work, copy a backup out (to Google Drive, or a bucket outside the project) before deleting. For a default install with nothing irreplaceable in it, this does not matter.

Pay only while you use it, the other way: delete and redeploy​

In your own project (or once you are past the 30-day restore window above), the alternative is to delete Metabase outright and redeploy it later. A redeploy costs the module fee again, plus the builds -- roughly 175 + 3-6 credits of build time.

Deleting saves money only once Metabase would otherwise sit unused long enough to clear that redeploy cost against its own daily running cost -- against the own-project total above, that works out to about 4 days or more. Most of the running cost here is usually the database; it stops only when nothing else in the project uses it, so deleting this app while something else shares the project saves only this app's own compute part.

Keep data first: nightly backups go to a bucket inside the deployment and are deleted with it, so copy the latest backup out before deleting if you want to keep it.

Lab sessions and Managed Environments​

  • Lab sessions, for training: a trainer runs a session for a class. Each participant gets the app in their own Google Cloud project for 15 minutes to 24 hours, within an allowance the trainer sets. Either the trainer funds every place, or each participant pays for their own. Everything is deleted when the session ends and unused credits go back to the trainer.
  • Managed Environments, for consultancies: a partner runs the app for a client from a ring-fenced wallet it funds, and settles with the client directly. If the wallet runs low, billing pauses and the data is kept, so nobody receives an unexpected charge. At the end the partner hands the project over and the deployments become the client's own.
  • Credits can be bought in more than 20 currencies, including XAF, XOF, NGN, GHS, KES and ZAR, by card, bank transfer or mobile money.

Sources (8 October 2026): Google Cloud Billing Catalog API list prices; radmodules.dev/pricing for RAD's own fees and daily-credit estimates; https://cloud.google.com/resource-manager/docs/delete-restore-projects for the pause/restore mechanics; https://www.metabase.com/pricing for the named competitor's price.

1. Overview​

Metabase runs as a Java/JVM (Jetty) web workload. The deployment wires together a focused set of Google Cloud services:

CapabilityGoogle Cloud serviceNotes
ComputeGKE AutopilotJVM pods, 2 vCPU / 4 GiB by default, horizontally autoscaled
DatabaseCloud SQL for PostgreSQL 15Required — Metabase stores all application state (questions, dashboards, users) in PostgreSQL
SecretsSecret ManagerAuto-generated database password; no admin password is managed here (Metabase handles its own)
IngressCloud Load BalancingExternal LoadBalancer with a zero-config <ip>.nip.io HTTPS hostname by default (enable_custom_domain = true); set application_domains for a real custom domain

Sensible defaults worth knowing up front:

  • PostgreSQL 15 is the only supported engine. All application state — questions, dashboards, collections, users — lives in this database.
  • No Redis is required. Metabase does not use Redis for caching; enable_redis defaults to false.
  • Session affinity is ClientIP. Sticky routing keeps a browser session on one pod, avoiding session loss during HPA scale-out.
  • JVM startup takes 60–120 seconds. The startup probe targets /api/health with a 60-second initial delay and 18 retries, giving ~240 seconds total tolerance. min_instance_count = 1 keeps at least one pod warm.
  • MB_JETTY_PORT = "3000" and JAVA_TIMEZONE = "UTC" are injected automatically — do not override them.
  • No GCS storage bucket is created by default. Metabase stores everything in PostgreSQL. Add a bucket via storage_buckets only if needed.

2. Google Cloud Services & How to Explore Them​

All commands assume you have run gcloud container clusters get-credentials <cluster> --region <region> --project <project> and that PROJECT, REGION, and NAMESPACE are set. The namespace and other identifiers are reported in the deployment Outputs.

A. GKE Autopilot — the Metabase workload​

Metabase pods are scheduled on Autopilot, which bills for the CPU/memory the pods actually request. Horizontal Pod Autoscaling sizes the deployment between the minimum and maximum replica counts. Because the JVM takes 60–120 seconds to initialise, keep min_instance_count = 1 in production to avoid cold-start delays and probe failures.

  • Console: Kubernetes Engine → Workloads → select the Metabase workload to see pods, revisions, and events. Kubernetes Engine → Services & Ingress shows the external IP.
  • CLI:
    kubectl get pods,svc,hpa -n "$NAMESPACE"
    kubectl logs -n "$NAMESPACE" deploy/<service-name> --tail=100
    kubectl describe hpa -n "$NAMESPACE" # current vs target utilisation

See App_GKE for how Autopilot, scaling, and the workload type (Deployment vs StatefulSet) are managed.

B. Cloud SQL for PostgreSQL 15​

Metabase stores its entire application state — questions, dashboards, collections, users, permissions, and settings — in a managed Cloud SQL for PostgreSQL 15 instance. Pods reach it privately through the Cloud SQL Auth Proxy sidecar over a Unix socket, so no public IP is exposed. On first deploy an initialization Job creates the application database and user.

  • Console: SQL → select the instance for connections, backups, flags, and metrics.
  • CLI:
    gcloud sql instances list --project "$PROJECT"
    gcloud sql instances describe <instance-name> --project "$PROJECT"
    # Open an interactive shell to inspect schema/data:
    gcloud sql connect <instance-name> --user=<db-user> --project "$PROJECT"

The instance name, database name, user, and the Secret Manager secret holding the password are all surfaced in the Outputs. For the connection model, automated backups, and password rotation, see App_GKE.

C. Secret Manager​

The database password is stored as a Secret Manager secret and injected into pods at runtime; plaintext never appears in configuration. Metabase manages its own internal encryption key separately.

  • Console: Security → Secret Manager.
  • CLI:
    gcloud secrets list --project "$PROJECT"
    gcloud secrets versions access latest --secret=<secret-name> --project "$PROJECT"

The database password secret name is in the Outputs. See App_GKE for the Secret Store CSI integration and rotation.

D. Networking & ingress​

enable_custom_domain = true by default, so App_GKE provisions a Gateway-based HTTPS ingress out of the box. With no application_domains set, it derives a zero-config <ip>.nip.io hostname from the reserved static IP and a matching Google-managed certificate, so Metabase gets HTTPS immediately. Set application_domains to serve a real custom domain instead; a static IP is reserved by default so the address survives redeploys.

  • Console: Network services → Load balancing; VPC network → IP addresses.
  • CLI:
    kubectl get ingress,svc -n "$NAMESPACE"
    gcloud compute addresses list --project "$PROJECT"

See App_GKE for custom domains, Cloud CDN, and static IP details.

E. Cloud Logging & Monitoring​

Pod stdout/stderr (including Metabase JVM logs) flow to Cloud Logging; GKE and Cloud SQL metrics flow to Cloud Monitoring. Optional uptime checks and alert policies are available.

  • Console: Logging → Logs Explorer; Monitoring → Dashboards / Alerting.
  • CLI:
    gcloud logging read 'resource.type="k8s_container" AND resource.labels.namespace_name="'"$NAMESPACE"'"' \
    --project "$PROJECT" --limit 50

3. Metabase Application Behaviour​

  • First-deploy database setup. An initialization Job runs before the application workload, using postgres:15-alpine to connect to Cloud SQL through the Auth Proxy and idempotently create the application database and user. It is safe to re-run.
  • No auto-migration on startup. Unlike some other applications, Metabase does not run schema migrations on every start. Migrations run as part of the Metabase application process on first boot against an already-initialised database — hence the importance of the db-init job completing successfully first.
  • Upgrade caution. Metabase migrations are one-way. Downgrading after a migration has run corrupts the schema. Always test upgrades in a staging environment before applying to production.
  • Health path. Startup and liveness probes target /api/health, which returns HTTP 200 only when the JVM is fully initialised and connected to PostgreSQL. The startup probe uses a 60-second initial delay with 18 retries (period 10s), giving ~240 seconds total tolerance. Do not reduce these values.
  • Admin setup. On first boot Metabase presents a setup wizard in the browser. After setup, the admin credentials are managed inside Metabase itself — no SECRET_KEY or admin password is managed by this module.
  • Data sources. Metabase is a BI tool that queries external databases. After deployment, configure data sources in Metabase Admin → Databases. Common GCP-native sources include BigQuery, Cloud SQL PostgreSQL/MySQL, and Google Sheets.
  • MB_JETTY_PORT and JAVA_TIMEZONE are fixed. These are injected automatically by Metabase_Common. Overriding them via environment_variables breaks routing or produces incorrect report timestamps.

4. Configuration Variables​

Variables are grouped exactly as they appear on the deployment platform. Only settings specific to or notable for Metabase are listed; every other input is inherited from App_GKE with its standard behaviour and defaults.

Group 1 — Project & Identity​

VariableDefaultDescription
project_id(required)Target Google Cloud project.
regionus-central1Region for the workload and regional resources.

Group 2 — Deployment Environment​

VariableDefaultDescription
tenant_iddemoShort suffix that makes resource names unique per environment.
support_users[]Emails granted project access and monitoring alerts.
resource_labels{}Labels applied to all resources for cost/ownership tracking.

Group 3 — Application Identity​

VariableDefaultDescription
application_namemetabaseBase name for resources. Do not change after first deploy.
application_display_nameMetabase AnalyticsFriendly name shown in the Console.
application_description(set)Workload description annotation.
application_versionv0.51.3Metabase image version tag; increment to roll out a new version. Never downgrade — migrations are irreversible.

Group 4 — Runtime & Scaling​

VariableDefaultDescription
deploy_applicationtrueSet false to provision infrastructure only.
container_resources{ cpu_limit = "2000m", memory_limit = "4Gi" }CPU/memory limits. JVM requires at least 2 GiB; 4 GiB recommended for production.
min_instance_count1Minimum replicas. Keep ≥ 1 to avoid 60–120s JVM cold starts.
max_instance_count5Maximum replicas (autoscaler ceiling).
container_port3000Metabase's Jetty port — must match MB_JETTY_PORT.
enable_cloudsql_volumetrueCloud SQL Auth Proxy sidecar for Unix socket connections. Required.
enable_vertical_pod_autoscalingfalseLet Autopilot tune resource requests automatically — recommended for JVM right-sizing.

Group 5 — Environment Variables & Secrets​

VariableDefaultDescription
environment_variables{}Extra non-secret settings. MB_JETTY_PORT and JAVA_TIMEZONE are injected automatically — do not override.
secret_environment_variables{}Map of env var → Secret Manager secret name (e.g., SMTP password).

Group 6 — GKE Backend & Cluster​

VariableDefaultDescription
service_typeLoadBalancerHow the Service is exposed.
session_affinityClientIPSticky routing required to keep browser sessions on one pod during HPA scale-out.
workload_typenullAuto-resolves; Metabase is stateless so use "Deployment".
termination_grace_period_seconds60Seconds Kubernetes waits after SIGTERM; allows in-flight queries to complete.

Group 7 — StatefulSet (advanced)​

Not recommended for Metabase — it is stateless. See App_GKE for StatefulSet mechanics if needed.

Group 8 — Resource Quota​

VariableDefaultDescription
enable_resource_quotafalseCap namespace CPU/memory/object counts.
quota_memory_requests / quota_memory_limits""Must use binary units (4Gi, 8192Mi) — bare integers are read as bytes and block scheduling.

Group 9 — Reliability Policies​

VariableDefaultDescription
enable_pod_disruption_budgettrueProtect availability during node upgrades.
pdb_min_available1Raise min_instance_count above 1 if you need eviction headroom.
enable_topology_spreadfalseSpread pods across zones.

Group 10 — Observability & Health​

VariableDefaultDescription
startup_probe_config/api/health, initial delay 60s, failure threshold 18HTTP probe; total tolerance ~240s for JVM startup. Do not reduce.
health_check_config/api/health, initial delay 120s, failure threshold 3Liveness probe.
uptime_check_configdisabledOptional Cloud Monitoring uptime check.
alert_policies[]Optional metric alert policies.

Group 11 — Jobs & Scheduled Tasks​

VariableDefaultDescription
initialization_jobs[]Leave empty to use the built-in db-init job (PostgreSQL database + user creation).
cron_jobs[]Scheduled Kubernetes CronJobs for any recurring tasks.

Group 12 — CI/CD & GitHub Integration​

Standard App_GKE Cloud Build / Cloud Deploy integration — see App_GKE. Key inputs: enable_cicd_trigger, github_repository_url, github_token, enable_cloud_deploy.

Group 13 — Filesystem (NFS)​

VariableDefaultDescription
enable_nfsfalseNFS storage is not required for Metabase — all state is in PostgreSQL.

Group 14 — Cloud Storage & Artifact Registry​

VariableDefaultDescription
create_cloud_storagetrueProvision GCS buckets when storage_buckets is non-empty.
storage_buckets[]Empty by default — Metabase does not require object storage. Add buckets here only if needed (e.g., for Metabase Enterprise S3 storage).
manage_storage_kms_iam / enable_artifact_registry_cmekfalseCMEK options.

Group 16 — Database Backend​

VariableDefaultDescription
database_typePOSTGRES_15Fixed — do not change. Metabase requires PostgreSQL.
application_database_namemetabaseGeneric App_GKE database-name input. Inert for this module — App_GKE derives the actual database name from the module's db_name config (see below), not this variable.
application_database_usermetabaseGeneric App_GKE database-user input. Inert for this module — see db_user below.
database_password_length32Generated password length (16–64).
enable_auto_password_rotationfalseZero-downtime DB password rotation.
db_namemetabaseAuthoritative database name, forwarded to Metabase_Common. Immutable after first deploy — renaming recreates the database and destroys data.
db_usermetabaseAuthoritative application user, forwarded to Metabase_Common. Immutable after first deploy.

Group 17 — Backup & Maintenance​

VariableDefaultDescription
backup_schedule0 2 * * *Automated backup cron (UTC).
backup_retention_days7Retention; raise to 30–90 for production/compliance.
enable_backup_import / backup_source / backup_urirestore optionsRestore from a backup on deploy.

Group 18 — Custom SQL Scripts​

enable_custom_sql_scripts, custom_sql_scripts_bucket, custom_sql_scripts_path, custom_sql_scripts_use_root — run SQL from a GCS bucket after provisioning. See App_GKE.

Group 19 — Custom Domain, Static IP & Networking​

VariableDefaultDescription
enable_custom_domaintrueProvisions the Gateway HTTPS ingress; derives a zero-config <ip>.nip.io hostname when application_domains is empty.
application_domains[]Hostnames to serve.
reserve_static_iptrueStable external IP across redeploys.
network_tags['nfsserver']Node/pod tags for firewall rules.

Group 20 — Identity-Aware Proxy (IAP)​

VariableDefaultDescription
enable_iapfalseRequire Google sign-in in front of Metabase. Strongly recommended — Metabase's own login is otherwise publicly reachable.
iap_authorized_users / iap_authorized_groups[]Who may access.
iap_oauth_client_id / iap_oauth_client_secret""Required when IAP is enabled (sensitive).
iap_support_email""Shown on the OAuth consent screen.

Group 21 — Cloud Armor & CDN​

VariableDefaultDescription
enable_cloud_armorfalseAttach a Cloud Armor (WAF) policy to the Ingress backend.
admin_ip_ranges[]CIDRs allowed privileged access.
cloud_armor_policy_name(set)Policy name.
enable_cdnfalseEnable Cloud CDN on the GKE Ingress backend.

Group 22 — VPC Service Controls & Audit Logging​

VariableDefaultDescription
enable_vpc_scfalseEnforce a VPC-SC perimeter (requires organization_id).
vpc_cidr_ranges / vpc_sc_dry_run(set)Access level CIDRs / dry-run mode.
enable_audit_loggingfalseDetailed Cloud Audit Logs.

5. Outputs​

These values are returned on a successful deployment and are the quickest way to locate and explore the running resources.

OutputDescription
service_nameKubernetes Service name.
namespaceNamespace the workload runs in.
service_cluster_ipIn-cluster ClusterIP.
stage_service_cluster_ipsMap of ClusterIPs for stage-specific services.
service_external_ipExternal LoadBalancer IP (when a static IP is reserved).
service_urlURL to reach Metabase.
database_instance_nameCloud SQL instance name.
database_nameApplication database name.
database_userApplication database user.
database_password_secretSecret Manager secret holding the DB password.
database_host / database_portDB endpoint (127.0.0.1 via the Auth Proxy) / port.
storage_bucketsCreated Cloud Storage buckets (empty by default).
network_name / network_exists / regionsVPC network, presence, available regions.
container_image / container_registryDeployed image and Artifact Registry repo.
monitoring_enabled / monitoring_notification_channelsMonitoring status and channels.
initialization_jobs / db_import_jobNames of the setup and (optional) import jobs.
deployment_id / tenant_id / resource_prefixNaming identifiers.
project_id / project_numberProject identifiers.
cicd_enabled / github_repository_url / github_repository_owner / github_repository_name / cicd_configurationCI/CD status and details.
artifact_registry_repository / cloudbuild_trigger_name / cloudbuild_trigger_idRegistry and build trigger.
kubernetes_readyWhether the cluster/workload is ready.
vpc_sc_enabled / vpc_sc_perimeter_name / vpc_sc_dry_run_modeVPC-SC status.
audit_logging_enabled / artifact_registry_cmek_enabledAudit logging and CMEK status.

6. Configuration Pitfalls & Sensible Defaults​

Risk: Critical (data loss / outage / security) — High (service degraded) — Medium (cost or partial degradation) — Low (minor).

SettingSensible valueRiskConsequence if wrong
database_typePOSTGRES_15CriticalMetabase requires PostgreSQL; any other engine breaks startup.
enable_cloudsql_volumetrueCriticalDisabling breaks all database connections (Auth Proxy sidecar required).
container_resources.memory_limit4GiCriticalUnder 2 GiB the JVM crashes with OutOfMemoryError on startup.
db_name / db_userset onceCriticalThe actual DB name/user controls (forwarded to Metabase_Common); immutable after first deploy — renaming recreates the DB/user and destroys all application data. application_database_name/application_database_user are the generic App_GKE inputs but are shadowed/inert for this module (App_GKE derives the real name from the module's db_name config), so changing them has no effect.
enable_backup_importfalse unless restoringCriticalEnabling without a valid backup_uri fails the import job.
application_versionincrement carefullyCriticalMetabase migrations are one-way; downgrading corrupts the schema. Always test upgrades in staging.
quota_memory_requests / _limitsbinary unitsCriticalBare integers are bytes and block all scheduling.
startup_probe_config.failure_threshold18 (≥ 18)HighReducing causes premature pod kills before the JVM completes startup.
min_instance_count1High0 causes 60–120s cold starts; probe failures on first request.
container_resources.cpu_limit2000mHighUnder 500m JVM JIT compilation stalls startup, triggering probe failures.
session_affinityClientIPHighWithout stickiness, multi-pod deployments lose browser session state on scale-out.
enable_iap / enable_cloud_armorenable for prodHighMetabase login page is otherwise publicly reachable.
backup_retention_days7 (raise for prod)MediumToo short for compliance retention.
pdb_min_available vs min_instance_countleave headroomMedium1/1 can stall node upgrades (single pod cannot be evicted).
enable_redisfalseLowMetabase does not use Redis; enabling has no effect.

For the foundation behaviour referenced throughout — IAM and Workload Identity, autoscaling, ingress and certificates, CI/CD, Cloud Armor, IAP, Binary Authorization, VPC-SC, backups, and image mirroring — see App_GKE. Metabase-specific application configuration shared with the Cloud Run variant is described in Metabase_Common.

Need RAD to do something it does not do yet? Request it on the roadmap, or vote on what is already there.