Collecting project size information

Configure your project size information to be available in your Cloudera AI Workbench.

This configuration enables a scheduled job to update the Cloudera AI Workbench database project table daily with the size of the project.

  1. Configure Cloudera AI to collect the project sizes for each project daily, go to:Cloudera AI UI > Site Administration > Settings > Collect Project Sizes.
  2. View the project sizes by running the following command:
    # export KUBECONFIG=<kubeconfig_file> 
    # kubectl exec -it $(kubectl get pods  -n [***CLOUDERA AI NAMESPACE***] -l app=db -o jsonpath='{.items[*].metadata.name}') -c db -n [***CLOUDERA AI NAMESPACE***] -- psql -P pager=off -U sense -c " select p.id, p.name,u.username, u.email,u.type,u.name,p.size from projects p, users u where p.user_id=u.id" 

Enabling this will update Cloudera AI Workbench with the project size information on the last accessed date of the project.