Enabling the ABFS File Browser

To enable access to ADLS Gen2 containers from the Data Explorer web interface, you must add the Azure environment details in the hue-safety-valve configuration from your Virtual Warehouse. After enabling the ABFS File Browser, you can browse the ADLS Gen2 containers, create folders, and upload files from your computer, and import files to create tables.

Sign in to Cloudera Data Warehouse.
Go to the Virtual Warehouse from which you want to access the ADLS Gen2 containers and click .
On the Virtual Warehouses detail page, click the Data Explorer (Hue) tab and select hue-safety-valve from the drop-down menu.

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
[azure]
  [[azure_accounts]]
    [[[default]]]
      client_id=[***AZURE-ACCOUNT-CLIENT-ID***]
      client_secret=[***AZURE-ACCOUNT-CLIENT-SECRET***]
      tenant_id=[***AZURE-ACCOUNT-TENANT-ID***]

    [[abfs_clusters]]
      [[[default]]]   
		fs_defaultfs=abfs://[***CONTAINER-NAME***]@[***AZURE-STORAGE-ACCOUNT-NAME***]>.dfs.core.windows.net
              webhdfs_url=https://[***AZURE-STORAGE-ACCOUNT-NAME***].dfs.core.windows.net/

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
[azure]
  [[azure_accounts]]
    [[[default]]]
      client_id=[***AZURE-ACCOUNT-CLIENT-ID***]
      client_secret=[***AZURE-ACCOUNT-CLIENT-SECRET***]
      tenant_id=[***AZURE-ACCOUNT-TENANT-ID***]

    [[abfs_clusters]]
      [[[default]]]   
		fs_defaultfs=abfs://[***CONTAINER-NAME***]@[***AZURE-STORAGE-ACCOUNT-NAME***]>.dfs.core.windows.net
              webhdfs_url=https://[***AZURE-STORAGE-ACCOUNT-NAME***].dfs.core.windows.net/

Make sure that the container name and the Azure storage account name that you specify under the abfs_clusters section is same as what you specified under Data Access > Storage Location Base while activating the Azure environment, so that Hive or Impala has permission to access the uploaded files.

Click APPLY.
The ABFS File Browser icon appears on the left Assist panel on the Data Explorer web interface after the Virtual Warehouse restarts.