Dell Data Lakehouse: How to Configure Access Control Rules using a URL

How to configure Dell Data Lakehouse to fetch and use access control rules from a specific URL:

Use Case:
This configuration is intended for customers who have an existing Trino configuration that they want to duplicate in Dell Data Analytics Engines (DDAE). The access control rules are fetched from a specific URL.

URL: https://company.com/api/v1/integration/trino/access-control

Current Trino configuration: 

coordinator:
  additionalConfigFiles:
    access-control.properties:
      access-control.name=file
      security.refresh-period=120s
      security.config-file=https://company.com/api/v1/integration/trino/access-control

Solution:

1. Log in to the Dell Data Lakehouse System Software user interface.
2. Go to your Cluster.
3. Go to Manage Configuration.
4. Backup your Existing Configuration - If the DDAE Properties field already contains information, copy and paste it to your notes if you must revert to the original configuration.
5. If other properties are in the field, include the coordinator information shown below where appropriate.
6. In the DDAE Properties field, enter the following configuration:

{
   "coordinator": {
     "etcFiles": {
       "properties": {
         "access-control.properties": "access-control.name=file\nsecurity.refresh-period=120s\nsecurity.config-file=https://company.com/api/v1/integration/trino/access-control"
       }
     }
   }
 }

7. Click Apply and then Exit.
8. Type CONFIRM.
9. Restart the cluster.
10. The cluster should return to an available state after a few minutes.
11. Verify that the access control rules are being fetched and used as expected.

Reference:
File-based access control — Dell Data Analytics Engine