Import
The Import feature allows to import data into the system by uploading CSV or Excel files.
Clicking open Import modal
Catalog import modal consists of:
Fields
Entity type
Business rules - Catalog business rules (Catalog import does not support linking test cases, can be done with API)
Objects - Catalog objects descriptions
Columns - Catalog columns descriptions
Column relations - Relations between columns
Column relations (SQL) - Relations between columns and query evaluation functionality
Column term relations - Relations between column terms
Terms - Business glossary terms
Term relations - Relations between glossary terms
File
Import can be done from both CSV and Excel files
You can get the import template with required headers (including custom fields) in your preferred format:
Separator
If you are using CSV files, you can also choose your separator:
Comma (,) - Values are separated by commas.
Semicolon (;) - Values are separated by semicolons.
File Upload
Upload File: Uploading import template will preview all entities that are available for import. Unmatched entities will be shown as count.

Evaluate query
To open query evaluate modal, choose object type "Column relations(SQL)" and press "Evaluate" button
Lineage from query
To accurately evaluate data lineage, select a database connection and insert SQL query. SelectZero is able to parse lineage from various queries containing INSERT, UPDATE, JOIN statements, parsing abstract syntax tree from SQL queries.