Enabling the S3 File Browser for Hue in Cloudera Data Warehouse

To enable access to S3 buckets from the Hue web interface, you must add the AWS environment details in the hue-safety-valve configuration from your Virtual Warehouse. After enabling the S3 File Browser, you can browse the S3 buckets, create folders, and upload files from your computer, and import files to create tables.

  1. Sign in to Cloudera Data Warehouse.
  2. Go to the Virtual Warehouse from which you want to access the S3 buckets and click .
  3. On the Virtual Warehouses detail page, click the Hue tab and select hue-safety-valve from the drop-down menu.
  4. Add the following configuration for Hive or Impala Virtual Warehouse in the space provided:
    For the Hive Virtual Warehouse:
    [desktop]
    # Remove the file browser from the blocked list of apps.
    # Tweak the app_blacklist property to suit your app configuration.
    app_blacklist=oozie,search,hbase,security,pig,sqoop,spark,impala
    
    [aws]
    [[aws_accounts]]
    [[[default]]]
    access_key_id=[***AWS-ACCESS-KEY***]
    secret_access_key=[***SECRET-ACCESS-KEY***]
    region=[***AWS-REGION***]
    
    [filebrowser]
    # (Optional) To set a specific home directory path:
    remote_storage_home=s3a://[***S3-BUCKET-NAME***]
    For Impala Virtual Warehouse:
    [desktop]
    # Remove the file browser from the blocked list of apps.
    # Tweak the app_blacklist property to suit your app configuration.
    app_blacklist=spark,zookeeper,hive,hbase,search,oozie,jobsub,pig,sqoop,security
    
    [aws]
    [[aws_accounts]]
    [[[default]]]
    access_key_id=[***AWS-ACCESS-KEY***]
    secret_access_key=[***SECRET-ACCESS-KEY***]
    region=[***AWS-REGION***]
    
    [filebrowser]
    # (Optional) To set a specific home directory path:
    remote_storage_home=s3a://[***S3-BUCKET-NAME***]
  5. Click APPLY.
    The S3 File Browser icon appears on the left Assist panel on the Hue web interface after the Virtual Warehouse restarts.