Variables

Variables are predefined values which can be used in various of places:

SQL Queries (test cases and lineage parsing)
Email send addresses
API executions

Variables are referenced with the ${variableName} syntax. Names are case-sensitive and must match an entry on this page exactly.

Sample test case SQL Query:

SELECT COUNT(*) FROM ${cust_est} WHERE reg_dt > ${last_year}

Variables in lineage imports

When SQL queries are submitted to the platform for lineage parsing - either via the Evaluate query modal or the lineage import API - every ${variableName} reference is substituted with the value defined on this page before the query is parsed. This lets you keep a single canonical query for lineage analysis while environment-specific schemas, table prefixes, or paths are injected at parse time.

Example - with a variable lineageSchema = "sports" defined:

SELECT COUNT(*) FROM ${lineageSchema}.participants_events
JOIN ${lineageSchema}.latest_revisions ON id = event_id

is parsed as if it were:

SELECT COUNT(*) FROM sports.participants_events
JOIN sports.latest_revisions ON id = event_id

If a referenced variable is not defined, the literal ${variableName} text is left in place and the query usually fails to parse - check the parser warnings if a lineage import unexpectedly skips a query.

20 May 2026