Skip to content

Data mart verification

Verification generates the SELECT query for the current configuration of a data mart and, optionally, runs it against the connected database. It lets you check that the configuration is correct and preview the data the data mart will return, without creating any object in the database.

Starting verification

Verification is started with the Verify data mart button on the data mart constructor page.

  • The button is unavailable while the data mart has critical errors (deleted or unavailable RMD elements) or an invalid configuration. The tooltip on the button names the reason
  • The button is also unavailable while the data mart contains a measure with the Error health status: "The data mart contains measures with Error health status" (see the Measure health cards page)
  • Verification is available to all roles that can open the data mart, including Viewer. Executing the generated query is available to the Super administrator, Administrator, Developer and Analyst roles

The button opens a dialog for the Result limit:

Value Behaviour
No limit All records are returned, paginated in the result table
10 rows The first 10 records. Default value
50 rows The first 50 records
200 rows The first 200 records
500 rows The first 500 records

Confirm with the Verify button.

The generated SQL

The generated query is shown first, with syntax highlighting for the dialect of the target database.

  • Facts and dimensions are read from their connected sources; measures are translated from their formulas into SQL
  • The query is generated for the database of the connection the data mart resolves to. If the target database cannot be determined, the query is generated for PostgreSQL
  • Every database supported by the product is supported here

Two actions are available for the code:

  • Copy — copies the query to the clipboard
  • Export code to text file — downloads the query as a text file

The database view control is available next to these buttons, so a view can be created or refreshed directly from the verification panel.

Executing the query

The Execute SQL script button runs the generated query against the target database. The button is unavailable when the connection the data mart uses is not active.

The rows are displayed under the query in the Script result table:

  • When a row limit was selected, the table shows the returned rows as one page. Without a limit, the result is paginated
  • Save the current page to a file exports the rows of the current page as a CSV file
  • When the query returns nothing, the table shows "Script execution results not found"

Errors

If the query cannot be generated or executed, a notification explains the reason. Typical causes:

  • Deleted or unavailable RMD elements used by the data mart
  • Elements resolving to several database connections, or a missing connection
  • Errors reported by the database, for example a table or column that no longer exists in the source
  • A configuration that is not allowed, for example a filter that uses a formula with an aggregate function