Data Observability platform Help

Import

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

Clicking import.png open Import modal

Catalog import modal consists of:

import_modal.png

Fields

Entity type

  • Business rules - Catalog business rules (CSV 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

CSV file

The format for the CSV file depends on the selected entity type.
Example - import Objects, the CSV should be structured as follows:

  • connection, schema, object, description

  • Ensure that your CSV uses the correct headers and follows this sequence.

Separator

  • Comma (,) - Use if CSV values are separated by commas.

  • Semicolon (;) - Use if CSV values are separated by semicolons.

File Upload

Select Entity Type: Choose the entity type to import from the dropdown menu. Each entity type corresponds to different data structures and requires specific CSV formats.

Upload CSV File: Click on the Upload button to select and upload the CSV file that matches the selected entity type. Ensure that file matches required format.

import_example.png

Evaluate query

To open query evaluate modal press "Evaluate" button

evaluate

Lineage from query

To accurately evaluate data lineage, select a database connection and insert SQL query. This process helps establish entity associations, such as foreign key constraints, JOIN conditions, and INSERT target mappings, ensuring precise lineage tracking.

queryEvaluate

Last modified: 03 February 2025