Advanced configurations in CDW Private Cloud

You can access advanced configurations in Cloudera Data Warehouse (CDW) Private Cloud from the left navigation pane on the CDW web interface. Some of these configurations must be enabled before you activate an environment and some can be applied by refreshing the environment, Database Catalog, and Virtual Warehouses.


Configuration	Description	Enabled by default?	Condition for applying the configuration
Create databases for Virtual Warehouses (deprecated)	This option has been deprecated and no longer supported.	No	NA
Use deterministic namespace names	Makes the namespace names deterministic, that is, given the same input, a client can get to the same name every time. Enable this option if you need to create Kerberos principals and keytabs.	Yes	Enable before activating an environment in CDW.
Enable ADLS as a storage provider	Enables you to use Azure Data Lake Storage (Gen1 and Gen2) for storing tables.	Yes	Refresh
Copy configurations from base cluster to CDW	Configurations such as default file format, compression type, and transactional type are copied from the base cluster to CDW to aid cluster setup and workload migration.	Yes	Refresh^{^*}
Back up Virtual Warehouse namespaces before an upgrade	CDW backs up namespace-related data using the Data Recovery Service (DRS) before upgrading the Virtual Warehouse.	Yes	Refresh^{^*}
Store logs on HDFS	Enables you to store CDW logs to HDFS on the base cluster.	Yes	Refresh^{^*}
Enable quota management	Enables you to assign quota-managed resource pools to environments, Database Catalogs, Virtual Warehouses, and Data Visualization instances.	No	You can enable or disable quota management at any time during the lifetime of your CDW environment.
Enable S3 and S3-compatible object store providers	Enables you to use AWS S3 and other similar, compatible, on-premises object stores that support the S3 protocol for storing tables.	Yes	Refresh^{^*}
Enable warehouse-level access control for Impala	Enables you to allow access to an Impala Virtual Warehouse for selected user groups. Select the Enable warehouse-level access control for Hive and Unified Analytics option to create an Impala warehouse in the Unified Analytics mode.	Yes	Refresh^{^*}
Enable warehouse-level access control for Hive and Unified Analytics	Enables you to allow access to an Hive Virtual Warehouse for selected user groups in regular and Unified Analytics mode.	No	Refresh^{^*}
Enable workload-aware autoscaling for Impala	Enables you to create multiple executor group sets of different sizes that can scale independently based on the load. This is a preview feature. Not recommended for production deployments.	No	Refresh^{^*}
Skip cluster validation during environment activation	Skips the cluster validation^? step during environment activation. Select this option if you want to proceed with the environment activation even after seeing false positive errors in the logs.	No	Enable before activating an environment in CDW.

^* Refresh the environment, Database Catalog, and Virtual Warehouses, in this order.

^? Cluster validation includes port validation, and the Kerberos keytab configuration validation, and Root CA certificate validation.