Cloudera

Cloudera Lakehouseopt API

The Lakehouseopt API from Cloudera — 30 operation(s) for lakehouseopt.

GitHub OpenAPI

Operations 30

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

POST /api/v1/lakehouseopt/getHealth Check health of Lakehouse Optimizer components · Performs health check on CLO components #
Ask an LLM
“Are the Lakehouse Optimizer scheduler, dispatcher and DAO services healthy?”
“Can I limit a CLO health check to a specific scope?”
Tell an agent
Run a health check on the Lakehouse Optimizer for Data Hub {datahubCrn}.
Check CLO component health for {datahubCrn} with scope {scope}.
POST /api/v1/lakehouseopt/listEnvironments List environments with their CLO Data Hub · List environments #
Ask an LLM
“Which of my environments have a Lakehouse Optimizer Data Hub enabled?”
“Can I page through the environments known to Lakehouse Optimizer?”
Tell an agent
List my environments along with their Lakehouse Optimizer Data Hub details.
List Lakehouse Optimizer environments, {pageSize} per page.
POST /api/v1/lakehouseopt/getDatahubCrn Look up the Data Hub CRN for an environment · Fetches Data Hub CRN for an environment #
Ask an LLM
“What is the Data Hub CRN I should use for Lakehouse Optimizer calls in my environment?”
“Can I resolve an environment CRN to its Data Hub CRN?”
Tell an agent
Get the Data Hub CRN for environment {environmentCrn}.
Resolve environment {environmentCrn} to its Data Hub CRN only.
POST /api/v1/lakehouseopt/getCloDatahub Get the CLO Data Hub for an environment · Fetches CLO Data Hub for an environment #
Ask an LLM
“Which Data Hub runs Lakehouse Optimizer in a given environment, and what are its details?”
“Can I fetch the full CLO Data Hub record for one environment?”
Tell an agent
Fetch the Lakehouse Optimizer Data Hub record for environment {environmentCrn}.
Show the CLO Data Hub details in environment {environmentCrn}.
POST /api/v1/lakehouseopt/listPolicies List table maintenance policies · Lists policies #
Ask an LLM
“What maintenance policies are defined in Lakehouse Optimizer?”
“Can I list only the policies that apply to one namespace?”
Tell an agent
List all Lakehouse Optimizer policies on Data Hub {datahubCrn}.
List the policies with full details in namespace {namespace} on {datahubCrn}.
POST /api/v1/lakehouseopt/getPolicy Get details of a maintenance policy · Fetches the policy details #
Ask an LLM
“What actions, scope, versions and status does a particular policy have?”
“Can I see which tables a single named policy is associated with?”
Tell an agent
Get the details of policy {policyName} on Data Hub {datahubCrn}.
Show version IDs and actions for policy {policyName} on {datahubCrn}.
POST /api/v1/lakehouseopt/downloadPolicy Download a policy version's definition · Downloads the policy definition for a particular policy version #
Ask an LLM
“How do I get the scripts and arguments behind a specific policy version?”
“Can I export the definition of an older version of a policy?”
Tell an agent
Download version {policyVersion} of policy {policyName} from {datahubCrn}.
Export the scripts for policy {policyName} version {policyVersion} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/getNamespaces List namespaces in the catalog · Get all namespaces #
Ask an LLM
“Which namespaces exist in the catalog Lakehouse Optimizer manages?”
“What databases can I target with optimization policies?”
Tell an agent
List all namespaces in the catalog for Data Hub {datahubCrn}.
Show me every namespace Lakehouse Optimizer sees on {datahubCrn}.
POST /api/v1/lakehouseopt/getTableNames Get just the table names in a namespace · Get table names in a namespace #
Ask an LLM
“What are the names of the tables in a given namespace?”
“Can I get a plain list of table names without the extra table details?”
Tell an agent
Get the table names in namespace {namespace} on Data Hub {datahubCrn}.
Give me only the names of tables in {namespace} on {datahubCrn}.
POST /api/v1/lakehouseopt/listTables List tables in a namespace with details · List tables in a namespace #
Ask an LLM
“Which tables in a namespace does Lakehouse Optimizer track, with their details?”
“Can I list the table records in one namespace?”
Tell an agent
List the tables with their details in namespace {namespace} on {datahubCrn}.
Show the table entries for namespace {namespace} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/getTablePolicies Get policies applied to a table · get policies of a table in a namespace #
Ask an LLM
“Which maintenance policies are applied to a particular table?”
“Can I check what policies run against one table in a namespace?”
Tell an agent
Get the policies on table {tableName} in namespace {namespace} on {datahubCrn}.
Show which policies cover table {namespace}.{tableName} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/getPolicyNames Get policy names linked to a namespace · get all policy names associated with a namespace #
Ask an LLM
“What policy names are associated with a namespace?”
“Can I get just the names of policies tied to one database?”
Tell an agent
Get the policy names associated with namespace {namespace} on {datahubCrn}.
List only the names of policies linked to {namespace} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/createTablePoliciesAssociations Attach policies to a table · create associations of a table and policies #
Ask an LLM
“How do I attach several maintenance policies to one table at once?”
“Can I associate a table with a list of policies?”
Tell an agent
Associate table {tableName} in {namespace} on {datahubCrn} with policies {policies}.
Attach policies {policies} to table {namespace}.{tableName} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/getScripts List default and catalog-level scripts · Get scripts #
Ask an LLM
“Which maintenance scripts are available to build policies from?”
“What default or catalog-defined scripts does Lakehouse Optimizer provide?”
Tell an agent
Get the available policy scripts on Data Hub {datahubCrn}.
List the default and catalog-level scripts for {datahubCrn}.
POST /api/v1/lakehouseopt/getAssociations Get tables associated with a policy · Get policy to table associations #
Ask an LLM
“Which tables, grouped by namespace, is a policy currently associated with?”
“Can I see the current table associations for a single policy?”
Tell an agent
Get the table associations for policy {policyName} on {datahubCrn}.
Show the tables per namespace currently bound to policy {policyName} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/createAssociations Associate tables with a policy · Create policy to table associations #
Ask an LLM
“How do I apply one policy to a set of tables across namespaces?”
“Can I bind many tables to a single policy in one call?”
Tell an agent
Associate policy {policyName} with tables {associations} on {datahubCrn}.
Bind the table set {associations} to policy {policyName} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/createPolicy Create a table maintenance policy · Create a new policy #
Ask an LLM
“How do I define a new optimization policy in Lakehouse Optimizer?”
“What resources do I need to supply when creating a policy?”
Tell an agent
Create policy {policyName} with resources {resources} on Data Hub {datahubCrn}.
Define a new Lakehouse Optimizer policy named {policyName} on {datahubCrn} using {resources}.
POST /api/v1/lakehouseopt/updatePolicy Update an existing maintenance policy · Update an existing policy #
Ask an LLM
“Can I change the resources of a policy that already exists?”
“What do I send to modify an existing optimization policy?”
Tell an agent
Update existing policy {policyName} on {datahubCrn} with resources {resources}.
Replace the resources of policy {policyName} on Data Hub {datahubCrn} with {resources}.
POST /api/v1/lakehouseopt/unsubscribePolicy Remove a policy from a table · Unsubscribe a policy from the table #
Ask an LLM
“How do I stop a single policy from applying to one table?”
“Can I unsubscribe one table from a policy without deleting the policy?”
Tell an agent destructive · confirm first
Unsubscribe policy {policyName} from table {tableName} in {namespace} on {datahubCrn}.
Detach policy {policyName} from {namespace}.{tableName} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/pauseTable Pause maintenance on a table · Pause a table #
Ask an LLM
“Can I temporarily stop all maintenance actions on a table?”
“How do I put optimization of one table on hold?”
Tell an agent
Pause maintenance on table {tableName} in {namespace} on {datahubCrn}.
Put all maintenance actions for {namespace}.{tableName} on hold on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/unpauseTable Resume maintenance on a paused table · Unpause a table #
Ask an LLM
“How do I restart maintenance on a table I paused earlier?”
“Can I unpause a table so its policies run again?”
Tell an agent
Unpause table {tableName} in {namespace} on {datahubCrn}.
Resume maintenance actions on paused table {namespace}.{tableName} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/listTasks List maintenance tasks in a namespace · Retrieves CLO maintenance tasks #
Ask an LLM
“What maintenance tasks has Lakehouse Optimizer run in a namespace?”
“Can I page through CLO tasks for one namespace?”
Tell an agent
List maintenance tasks for namespace {namespace} on {datahubCrn}.
Show {pageSize} CLO maintenance tasks at a time for {namespace} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/changeTablePolicy Add, remove or replace policies on a table · Perform policy change operations on a table #
Ask an LLM
“Can I swap the policies on a table for a different set?”
“Which operations can I perform to change a table's policies?”
Tell an agent
Run the {operation} policy change with {policies} on table {tableName} in {namespace} on {datahubCrn}.
Replace the policies on {namespace}.{tableName} with {policies} using operation {operation} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/deletePolicy Delete a policy definition for a resource · Delete a policy definition for a resource #
Ask an LLM
“How do I delete a policy definition for a namespace or table?”
“What happens if I use a wildcard namespace when deleting a policy?”
Tell an agent destructive · confirm first
Delete policy {policyName} for resource scope {resourceScope} on {datahubCrn}.
Remove the definition of policy {policyName} on Data Hub {datahubCrn} for {resourceScope}.
POST /api/v1/lakehouseopt/getTimezones List supported policy schedule timezones · Get all supported timezones #
Ask an LLM
“Which timezones can I use when scheduling a policy?”
“What timezone values does Lakehouse Optimizer accept for schedules?”
Tell an agent
List the supported timezones for policy schedules.
Show every timezone I can schedule a Lakehouse Optimizer policy in.
POST /api/v1/lakehouseopt/getAssociatedTables Show all tables flagged by policy association · Get all associated tables for a policy #
Ask an LLM
“For a policy, which tables are associated and which are not?”
“Can I see every table with a flag showing whether a policy covers it?”
Tell an agent
Show all tables with an association flag for policy {policyName} on {datahubCrn}.
List every table and whether policy {policyName} applies to it on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/getAssociatedNamespaces Show namespaces flagged by policy association · Get all associated namespaces for a policy #
Ask an LLM
“Which namespaces is a policy associated with, and which are left out?”
“Can I get all namespaces with a flag for a given policy?”
Tell an agent
Show all namespaces with an association flag for policy {policyName} on {datahubCrn}.
List each namespace and whether it is tied to policy {policyName} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/getTableStatusDetails Get a table's current policy status details · Get table status details #
Ask an LLM
“Why is a table showing a particular status for one of its policies?”
“Can I drill into the current status of a table under a given policy?”
Tell an agent
Get status {status} details for table {tableName} in {namespace} under policy {policyName} on {datahubCrn}.
Explain the {status} status of {namespace}.{tableName} for policy {policyName} on Data Hub {datahubCrn}.
POST /api/v1/lakehouseopt/executePolicy Run a policy on a table now · Execute a policy on a table #
Ask an LLM
“Can I trigger a maintenance policy on a table right away instead of waiting for its schedule?”
“Is there a dry-run mode to evaluate a policy without changing the table?”
Tell an agent
Execute policy {policyName} on table {tableName} in {namespace} on {datahubCrn}.
Dry-run policy {policyName} against {namespace}.{tableName} on Data Hub {datahubCrn} without changing anything.
POST /api/v1/lakehouseopt/getAssociationDetails Get direct and wildcard policy association details · Get policy association details #
Ask an LLM
“Which policies are associated directly versus through a wildcard association?”
“Can I get an overview of all policy associations on my Data Hub?”
Tell an agent
Get the direct and star policy association details for Data Hub {datahubCrn}.
Summarize every policy association on {datahubCrn}.

Documentation

📖
Documentation
https://docs.cloudera.com/cdp-public-cloud/cloud/api/topics/mc-api-overview.html
📖
APIReference
https://cloudera.github.io/cdp-dev-docs/api-docs/

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/cloudera/refs/heads/main/openapi/cloudera-lakehouseopt-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/cloudera/refs/heads/main/json-schema/cloudera-get-policy-response-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/cloudera/refs/heads/main/json-schema/cloudera-change-table-policy-request-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/cloudera/refs/heads/main/json-schema/cloudera-get-table-status-details-request-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/cloudera/refs/heads/main/json-schema/cloudera-list-tasks-request-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/cloudera/refs/heads/main/json-schema/cloudera-delete-policy-request-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/cloudera/refs/heads/main/json-schema/cloudera-execute-policy-request-schema.json

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/cloudera:cloudera-lakehouseopt-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

cloudera-lakehouseopt-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  version: 0.9.163
  title: Cloudera Lakehouse Optimizer Service Lakehouseopt API
  license:
    name: Apache 2.0
  description: CDP Cloudera Lakehouse Optimizer Service does the iceberg table maintenance, it allows users to define policies to schedule iceberg spark actions to perform regular maintenance.
tags:


# --- truncated at 32 KB (68 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/cloudera/refs/heads/main/openapi/cloudera-lakehouseopt-api-openapi.yml