Data Observability platform Help

Import

The Import feature allows to import data into the system by uploading CSV or Excel files.

Clicking import.png open Import modal

Catalog import modal consists of:

import_modal.png

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:

Import 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.

import_example.png

Evaluate query

To open query evaluate modal, choose object type "Column relations(SQL)" and press "Evaluate" button

evaluate

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.

queryEvaluate

Last modified: 03 March 2025