Quick Import catalog

Data Explorer enables enriching your data with metadata referred to as the catalog. The catalog can be imported into the dataset in the following ways.

1. Connect to an SQL-based catalog store like MYSQL, SQL Server, PostGreSQL and Amazon Athena without copying any catalog into Data Explorer. Please check External-catalog for more details.
2. Import catalog by uploading a CSV file or a COCO formatted JSON file.

Importing a COCO formatted annotation file

The video below provides a walkthrough of importing a COCO formatted file.

Importing a CSV annotation file

The section below describes the steps to import a catalog into a freshly created catalog table with data types automatically inferred.
For advanced use cases, creating a table with specific data types and importing catalog as a follow-on operation or incrementally importing new catalog records into an existing table is possible. Please refer to Import catalog for details on advanced operations.

1. Navigate to 'Data -> Repo -> Datasets' on the left navigation panel and click the Catalog button on the dataset card.
   
2. Click the hamburger button as shown below and select 'Import catalog'. 
3. Enter catalog name and select the type of the file being imported.
   
4. Select the file to import. For CSV file, the first line is expected to be a header and the catalog columns will be created with the same name as in the header. You can select more than one file also.
   
5. Preview the contents and Upload.
   
6. Once the upload is complete, click 'Import'.
   
7. The status of import is presented in the below screen. Click on 'Refresh' button to update the status.
   
8. Once the status transitions to 'SUCCESS', close the popup. The imported table is listed under the 'Dataset tables' shown below.