Validate Statements

Validate statements check the correctness and consistency of concepts or datasources in the current environment.

Syntax

validate_statement: ("validate" "all") | ("validate" SCOPE (IDENTIFIER ("," IDENTIFIER)*)?)

Where SCOPE is one of: concepts, concept, datasources, datasource

Validate All

Check all concepts and datasources:

validate all;

Validate Concepts

Validate all concepts or specific ones:

# Validate all concepts
validate concepts;
# Validate specific concepts
validate concept customer.id, customer.name;

Validate Datasources

Validate all datasources or specific ones:

# Validate all datasources
validate datasources;
# Validate a specific datasource
validate datasource customers;

What Validation Checks

• Concept definitions are complete and consistent
• Datasource columns map to valid concepts
• Grain definitions are correct
• No circular dependencies
• Type consistency

Example

import customer as customer;
import order as order;
# Ensure model is consistent before running queries
validate all;
select
    customer.id,
    customer.name
;