Home Product SQL Python Dashboards Pricing Customers Community Company Careers Blog Sign In

Definitions Plus Plan

Reusable, SQL-based business logic your whole team can COUNT( ) on

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

Define

Like a database view, use the Definitions editor to name commonly used SQL SELECT statements.

@mention

@Mention

For ad hoc exploration or dashboard prep, reference the Definition rather than writing hundreds of lines of complex SQL.

update

Update

When your logic or schema changes, update the Definition once. Dependent metrics and reports update automatically.

A clearer view

Lightweight

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.

Transparent

See when and how often Definitions are used across the platform. Describe each Definition to quell methodology chaos and keep the building blocks organized.

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 >
Start your free trial

14-day free trial. Connect your database and build your first SQL-powered dashboard in minutes.