Introduction

This feature is not available in the local mode.

A view is a virtual table created by joining an internal table with one or more imported tables or tables in the external catalog registered on the External catalog page. Let us consider an example where ground truth and prediction values for each image file are imported into Data Explorer by uploading a file(Quick Import catalog). On execution of pipelines, the primary table will be populated with file path as shown below.

Suppose the imported catalog contents have the ground truth and prediction information as below.

A view is specified to join the above two tables, after which all operations, like filtering the catalog output, can utilize the information in the external table. A view requires the following:

1. Two or more tables that are to be joined.
2. Alias name for each table that gets prefixed to each column name to ensure that column names in the view are unique.
3. A join column that is a common key column between both tables.

With 'int' and 'imp' used as alias names for internal and imported tables, respectively, and file_name used as the join column, the view will look below.