Data mart verification

Overview

Data mart verification allows you to validate the correctness of its configuration and preview the data it will return without creating a physical object in the database. This is a key step before creating a data mart view.

Where verification is available

• On the Data marts list screen — as the "Verify" action for each data mart in the list
• On the data mart configuration screen — the "Verify" button in the interface

Verification process

Verification is performed in two steps:

1. SQL script generation

   • The system generates a SELECT query based on the elements selected in the data mart:
     • Facts and dimensions — taken directly from source fields
     • Measures — translated from formulas into SQL according to the formula language rules
   • Code is generated for the DBMS selected in the configured connection. If the system cannot determine the target DBMS, code is generated for PostgreSQL
   • All DBMS supported by the product are available
   • The generated code is displayed in a readable, formatted view

2. Script execution and result preview

   • The user can execute the generated SELECT statement on the target database
   • The execution results are displayed as a table containing sample data that will be included in the data mart

Working with generated code

The following actions are available for the generated SQL code:

• Copy to clipboard
• Export to a text file

Working with execution results

• The results table can be exported to a CSV file

Error handling

• If the system cannot generate or execute the script, the user receives a notification explaining the reason (e.g., an error in a formula, a database connection issue, etc.)