Skip to main content

Command Reference

The oh CLI is organized into command groups, one per resource type. Commands with --show-sql can preview the generated SQL without making a network call; each page lists where the flag is available.

GroupCommandsDescription
oh clustershow describe create alter deleteCompute clusters
oh lakeshow describe create alter deleteLakes (storage namespaces)
oh databaseshow create deleteDatabases within a lake
oh tableshow · service subgroupTables and background table services
oh flowshow describe create alter deleteIngestion pipelines from a source to a table
oh sourceshow describe create deleteData sources (Kafka, S3, Postgres, …)
oh catalogshow describe create deleteExternal metastore catalogs
oh transformationshow describe create deleteRow-level transformations applied during ingestion
oh validationshow describe create deleteData quality validations applied during ingestion
oh jobshow describe create create-and-run alter delete run show-runs describe-run cancel-run upload-jar replace-jar show-jars describe-jar delete-jarJAR and Python Spark jobs
oh service-principalshow create alter deleteNon-human identities for programmatic access
oh groupshow create alter deleteGroups of users
oh grant / oh revokeprivilege role member row-filter column-mask column-access data-admin · grant adds show show-rolesGrant or revoke privileges, roles, membership and fine-grained data access
oh policyshow import sync grant revoke resetImport, sync and inspect access-control policies on an external catalog
oh ocualterProject-wide OCU (Onehouse Compute Unit) limit
oh dataplanedescribe validate-storage set node-types template create status drop · storage subgroupCustomer-run Kubernetes data planes with S3-compatible storage
oh api-tokencreate deleteAPI tokens scoped to a service principal
oh login / oh logout—Sign in as yourself through the browser instead of an API key
oh ai-gatewaylogin logout token run proxyAI Gateway tokens for Claude Code and Codex
oh skill / oh installskill · install agent-skillRead or install the bundled agent skill
oh sqlexec statusExecute raw SQL or check request status

For global flags (--profile, --timeout, --output) that apply to every command, see Global options.