Enable authorization of StorageHandler-based tables in CDW

You need to know how to enable authorization of StorageHandler-based tables. You follow steps to add a custom property.

In CDW, you add hive.security.authorization.tables.on.storagehandlers property as a custom property to enable authorization of StorageHandler-based tables.
  1. Click CDW Overview > Database Catalogs, and select a Database Catalog
  2. Click Configurations > Metastore.
  3. From the dropdown, select hive-site.
  4. Click +.
  5. In Add Custom Configurations, add the property and value hive.security.authorization.tables.on.storagehandlers=true (no single or double quotation marks).
  6. Click ADD.
  7. Click Apply.
    The Virtual Warehouse automatically updates and restarts.