Virtualizing data with business terms in Watson Query in strict virtualization mode
If you have data assets in your catalogs that are connected directly to your data sources
and that have business terms assigned, in strict virtualization mode in Watson Query,
virtual objects must use business terms for table and column names.
Before you begin
These instructions assume that you completed the
following prerequisites.
- Added the data source connection from which you want to virtualize to a governed catalog. For more information, see Adding a connection asset to a catalog.
- Added data from your data source connection to a governed catalog. For more information, see Adding a data asset from a connection to a catalog.
- Added the same data source connection that is used in the catalog to Watson Query. For more information, see Adding data sources.
- Authored and assigned business terms to data assets that you want to virtualize in a catalog.
- Enabled the strict virtualization mode in Watson Query. For more information, see Enabling strict virtualization mode in Watson Query.
About this task
If you enabled the strict virtualization mode, you can create virtual tables only from existing catalog data assets that have term assignments. Assigned terms are used to rename table and column names automatically.
In this virtualization mode, users can virtualize only assets that have been added to a catalog
by using a data source connection and that have a business term assigned at the asset level and to
at least one column. The same connection must be added as a data source to Watson Query. Use
one of the following options to catalog data source assets and assign business terms:
- Add data assets from the data source and assign business terms manually.
- Import and enrich data assets with information and business terms that help users to understand the meaning of the data, assess its quality, and decide how to work with it. For more information about metadata import, see Importing metadata from a project (Watson Knowledge Catalog). For more information about metadata enrichment, see Managing metadata enrichment (Watson Knowledge Catalog).
In this virtualization mode, users can virtualize only assets that are added to the catalog that the user who is virtualizing the assets has access to and that has business terms that are assigned to the table and its columns.
Important: These instructions apply only if the service is set to the strict
virtualization mode. To use business terms to govern your virtual data in the default
virtualization mode, see Virtualizing data with
business terms.
Procedure
Results
On the Virtualized data page, you can publish your virtual object to the catalog. For more information, see Publishing virtual data to the catalog in Watson Query.
Limitation: In the strict virtualization
mode (where you can see tables only if they have at least one column with business term assignment),
when you navigate to the Virtualize page, the console appears to be loading the
table list for a while without showing any tables. The loading can be much slower compared to the
default virtualization mode while the console evaluates the list of eligible tables that can be
virtualized, depending on term assignments to data source table and column names.