Enabling ADLS storage providers in Cloudera Data Warehouse

You can enable Cloudera Data Warehouse data service on Cloudera on premises to access Azure Data Lake Storage (ADLS Gen1 and Gen2) object storage if the Cloudera Base on premises cluster is configured to access it.

If you have installed the Cloudera Data Services on premises, including Cloudera Data Warehouse, before fine-tuning the base cluster configurations, then you must upload the Azure server certificates referenced in the fs.azure endpoint configuration on the Management Console > Administration > CA Certificates tab. Select Miscellaneous as the certificate type from the CA Certificate Type drop-down menu.

1. Log in to the Data Warehouse service as DWAdmin.
2. Go to the Advanced Configurations > Advanced Settings page.
3. Select the Enable ADLS as a storage provider option.
4. Click Update.
5. Refresh the Database Catalog and Virtual Warehouses by clicking > Refresh on the Database Catalog and Virtual Warehouse tile.