How to Enable S3 Cloud Storage in Hue

1. Log on to Cloudera Manager.
2. Select Administration > External Accounts.
3. Click Add Access Key Credentials or Add IAM Role-based Authentication.
4. Add any Name and enter your S3 credentials:
   1. To connect your AWS root user, add the Access Key ID and Secret Access Key for your root account.
   2. To connect an IAM user, add the Access Key ID and Secret Access Key for a read-only IAM account.
5. If you have an Amazon DynamoDB database, check Enable S3Guard for consistent read operations.
6. Click Enable for <cluster name> to give Hue access to S3 and S3-backed tables. Impala must have permissions defined in Sentry.
7. If using access keys, select Secure or Unsecure mode.
8. Click Continue (at Step 1) if your cluster passes validation. You are automatically taken to step 5.
9. Click Continue (at Step 5) to restart Hive, Impala, Oozie, and Hue.
10. When finished, click Home to see the S3 Connector.
    
    
    
    
11. If using IAM roles, set the region to us-east-1 (N. Virginia) in hue_safety_valve.ini. If not, ignore this step.
    1. Select Configuration > Advanced Configuration Snippets.
    2. Filter by Scope > Hue.
    3. Set Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini with the following:

       [aws]
        [[aws_accounts]]
        [[[default]]]
        region=us-east-1

    4. Click Save Changes.
    5. Restart Hue: select Cluster > Hue and Actions > Restart.

You can connect to S3 using three safety valves (also known as Advanced Configuration Snippets):

• Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini
• Cluster-wide Advanced Configuration Snippet (Safety Valve) for core-site.xml
• Hive Service Advanced Configuration Snippet (Safety Valve) for core-site.xml.

1. Log on to Cloudera Manager and select Clusters > your cluster.
2. Select Configuration > Advanced Configuration Snippets.
3. Filter by Scope > Hue.
4. Set your S3 credentials in Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini:

   [aws]
   [[aws_accounts]]
   [[[default]]]
   access_key_id_script=</path/to/access_key_script>
   secret_access_key_script=</path/to/secret_key_script>
   #security_token=<your AWS security token>
   allow_environment_credentials=false
   region=<your region, such as us-east-1> 

   For a proof-of-concept installation, you can add the IDs directly.

   access_key_id=<your_access_key_id>
   secret_access_key=<your_secret_access_key>

5. Clear the scope filters and search on "core-site.xml".
6. To enable the S3 Browser, set your S3 credentials in Cluster-wide Advanced Configuration Snippet (Safety Valve) for core-site.xml:

   <property>
   <name>fs.s3a.access.key</name>
   <value>AWS access key ID</value>
   </property>
   
   <property>
   <name>fs.s3a.secret.key</name>
   <value>AWS secret key</value>
   </property>

7. To enable Hive with S3, set your S3 credentials in Hive Service Advanced Configuration Snippet (Safety Valve) for core-site.xml.
8. Click Save Changes.
9. Restart Hue: select Cluster > Hue and Actions > Restart.
10. Restart Hive: select Cluster > Hive and Actions > Restart.

1. Create an AWS account and sign in to the AWS Console.
2. Create access keys for this AWS root account:
   1. Expand the drop-down menu under your account name and select My Security Credentials.
   2. Click Continue to Security Credentials.
   3. Expand Access Keys (Access Key ID and Secret Access Key).
   4. Click Create New Access Key.
   5. Click Show Access Key or Download Key File. These are your AWS root credentials.

1. Create two IAM groups (AWS admin and S3 Read-only):
   1. Go to the IAM service.
   2. Click Groups and Create New Group.
   3. Enter a name and click Next Step.
   4. Filter on "admin" and select the AdministratorAccess policy.
   5. Click Next Step and Create Group.
   6. Create a second group with AmazonS3ReadOnlyAccess.
2. Create two IAM users and assign one to the admin policy and one to the S3 read policy.
   1. Click Users and Add User.
   2. Enter a name, and at a minimum, select Programmatic access.
   3. Click Next: Permissions.
   4. Select the group with administrator permissions.
   5. Click Next: Review and Create User.
   6. Create a second user and assign the group with S3 read-only access.
3. Create access keys for your read-only IAM user:
   1. Click the name of your read-only IAM user.
   2. Click the Security Credentials tab.
   3. Click Create Access Key.
   4. Click Show Access Key or Download Key File. These are your IAM user credentials.

Use the AWS Policy Generator to create the IAM file, keeping in mind the following requirements:

• Only the Hue servers need to have an IAM role applied to them to access S3 with the browser.
• The Hue S3 browser does not become available until the Amazon S3 connector service is added to the cluster.
• ListBucket on the Amazon S3 resource is necessary to drill down into that bucket, along with ListAllMyBuckets on all resources.
• These permissions do not give access to other private buckets in that AWS account, although public buckets are accessible.
• For the Hue S3 browser, your Hue servers require permissions for the following methods:
  • s3:ListBucket
  • s3:PutObject
  • s3:GetObject
  • s3:DeleteObject
  • s3:PutObjectAcl
  • s3:ListAllMyBuckets

The following example IAM policy shows the format to use for the Hue server permissions. Your Amazon Resource Name (ARN) will be different. For more information on ARNs, see Amazon Resource Names (ARNs) and AWS Service Namespaces in the AWS documentation.

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "S3BucketPermissions",
            "Effect": "Allow",
            "Action": [
                "s3:ListBucket"
            ],
            "Resource": [
                "arn:aws:s3:::<S3BucketARN>"
            ],
        },
        {
            "Sid": "S3ObjectPermissions",
            "Effect": "Allow",
            "Action": [
                "s3:PutObject",
                "s3:GetObject",
                "s3:DeleteObject",
                "s3:PutObjectAcl"
            ],
            "Resource": [
                "arn:aws:s3:::<S3BucketARN>/*"
            ],
        },
        {
            "Sid": "AllS3",
            "Effect": "Allow",
            "Action": [
                "s3:ListAllMyBuckets"
            ],
            "Resource": "*"
        }
    ]
}