0 / 0
Enabling strict mode in Watson Query

Enabling strict virtualization mode in Watson Query

Watson Query Managers can determine the virtualization mode of the service.

Before you begin

Required role: To complete this task, you must have the Watson Query Manager role. For more information, see Watson Query roles.

About this task

The virtualization mode determines whether to enforce use of business terms in virtual table and column names. Use the strict virtualization mode if you want virtual objects to map to existing business terms only.
In this virtualization mode, the following conditions apply:
  • Users can virtualize an asset from data sources that are supported by Watson Query. This asset must be added to the catalog as a connected asset. For more information, see Adding a data asset from a connection.
  • Users can virtualize a connected asset from a data source, which is supported by Watson Query. The asset must have business terms assigned to itself and its columns.

When you disable the strict virtualization mode, you set Watson Query to the default virtualization mode.

Procedure

To enable the strict virtualization mode:

  1. Run the following command in the SQL editor.
    CALL DVSYS.TOGGLESTRICTFLAG(TRUE);

To disable the strict virtualization mode:

  1. Run the following command in the SQL editor.
    CALL DVSYS.TOGGLESTRICTFLAG(FALSE);

To check the status of strict mode:

  1. Run the following command in the SQL editor.
    SELECT VALUE FROM DVSYS.INSTANCE_INFO WHERE KEY='STRICT_FLAG';

    The value is true if strict mode is enabled and false if it is not enabled.

What to do next

Before virtualizing data in strict virtualization mode, delete objects that you virtualized before you enabled strict virtualization mode.
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more