Associating policies and fetching details using Cloudera Lakehouse Optimizer REST APIs

You can append or remove a policy association, fetch the list of policies associated with a specific policy, specific table, or at catalog level, fetch the policy names associated with all the tables in a specific namespace using Cloudera Lakehouse Optimizer REST APIs.

  • Append or remove the association of a policy to the table in the association file using the following APIs:
    • Define the association using the POST /policies/{policyName}/tables/{tableName}/subs API.
    • Add or update the association using the PUT /policies/{policyName}/tables/{tableName}/subs API.
    • Delete the association using the DELETE /policies/{policyName}/tables/{tableName}/subs API.
  • List the table names associated with a specific policy using the GET /policies/{policyName}/tables API.
  • List the policy names associated with the specified table using the GET /tables/{tableId}/policies API.
  • List the policies associated with all the tables in a catalog using the GET /policies/active API.
  • Retrieve the policy names associated with all the tables in the specified namespace using the GET /namespaces/{namespace}/policies API.
  • List all the active onboarded namespaces available for table maintenance using the GET /namespaces/active API. When you set the fetch parameter for the GET /namespaces API to true, the API fetches all the namespaces in the catalog. When you set it to false, the API fetches only the declared namespaces to be maintained by Cloudera Lakehouse Optimizer.