Application Configuration Settings

Application Configuration Settings allows admin users to toggle various platform controls on and off. Admins can also add custom application configuration settings from this page.

Out-of-the-box application configuration settings

Setting Description Value
AI_PLATFORM_PATH

When set to TRUE, SQL Assistant for Data Quality uses the Collibra Platform path and utilizes the Gemini AI model. This is the default and recommended setting.

When set to FALSE, SQL Assistant for Data Quality uses the path in preview with an encryption key provided by Collibra and utilizes the text-bison-002 AI model.

TRUE/FALSE

Default: TRUE
AI_TENANT Enables SQL Assistant for Data Quality when set to TRUE. TRUE/FALSE

Default: FALSE
BULK_CATALOG_ON When set to TRUE, allows/disallows using the catalog feature from the Wizard in the UI.

TRUE/FALSE

Default: TRUE
HOST_NAME

Hostname of your URL.

Note When you enable Include Links on the Alerts Configuration page of the Admin Console, you must also enter your host address in the HOST_NAME input field.
For more information, go to Configuring alert emails.

 Enter the hostname in the input field.
JOB_LOG_RETENTION_HR The number of hours that Collibra DQ retains DQ Job logs. Enter the number of hours for Collibra DQ to retain DQ Job logs.
MANDATORY_PRIMARY_RULE_COLUMN When set to TRUE, users are required to select a primary column when creating a rule. This requirement is enforced when a user creates a new rule or saves an existing rule for the first time after the setting is enabled. Existing rules are not affected automatically.  
MASK_P_FLAG When set to TRUE, sets/unsets -p/-srcp masking in the UI.

TRUE/FALSE

Default: TRUE
PLATFORM_LOG_RETENTION_HR The number of hours platform logging is retained.

Enter the number of hours for Collibra DQ to retain platform logs.
RULE_FILTER

When set to TRUE, you can use filter queries when creating a rule on the Rule Workbench.

  
REACT_MUI

When set to TRUE, enables React MUI.

Note This option is not applicable in Data Quality & Observability Classic versions 2024.07 and newer.

TRUE/FALSE

Default: TRUE
UX_REACT_ON

When set to TRUE, turns React MUI on. When FALSE, the Collibra DQ web application displays the legacy UI.

Note This option is not applicable in Data Quality & Observability Classic versions 2024.07 and newer.

 TRUE/FALSE

Default: FALSE

Optional application configuration settings

Setting Description Value
STRICT_SQL_QUERY_PARSING

You can control the strictness of SQL query validation in the Dataset Overview and the SQL View step in Explorer. Use the VALIDATE_QUERIES and STRICT_SQL_QUERY_PARSING settings in the Application Configuration Settings page of the Admin Console to configure this behavior.

The combination of these settings determines whether query validation is enabled and how strict or simple the validation is:

  • Simple validation checks if the query contains any keywords other than SELECT, but it does not perform a full syntax validation.
  • Strict validation performs a full syntax check of the query, ensuring it is a valid SELECT statement and that no non-SELECT keywords are present.
 TRUE/FALSE

Default: FALSE
VALIDATE_QUERIES

The VALIDATE_QUERIES setting works in tandem with STRICT_SQL_QUERY_PARSING. The following table explains how these settings interact:

VALIDATE_QUERIES STRICT_SQL_QUERY_PARSING Validation behavior
TRUE TRUE Strict SQL validation is enabled
TRUE FALSE Simple SQL validation is enabled
FALSE TRUE or FALSE SQL query validation is disabled
TRUE/FALSE

Default: FALSE