Write SQL once, use it everywhere
Write a SELECT statement, save it as a Definition, and reference it quickly in other queries throughout the platform.
Learn more about the Mode data platform >
How Definitions work
Define
Like a database view, use the Definitions editor to name commonly used SQL SELECT statements.
@Mention
For ad hoc exploration or dashboard prep, reference the Definition rather than writing hundreds of lines of complex SQL.
Update
When your logic or schema changes, update the Definition once. All dependent metrics and reporting will update automatically.
A clearer view
Define business logic as you analyze, rather than pausing work to set up a view elsewhere. Definitions put simple data engineering tasks in the hands of the analysts.
See when and how often Definitions are used across the platform. Describe each Definition to quell methodology chaos and keep the building blocks organized.
Start your free 14-day trial
Simplify SQL for Everyone
Often, the hardest part of getting started with SQL is learning the schema. Definitions abstract away complex joins and deep database knowledge. Analysts can set the logic once, and give business partners the confidence to pull the right data with simpler SELECT queries. It's a better way to write SQL and get charts.
See how Mode helps teams >
