Guide

Add SQL variables to reusable queries

Q: What are SQL variables in DataPilot?

SQL variables are typed inputs you define once and reuse across Run Now and scheduled exports for consistent parameters.

Q: How do I reference a variable in SQL?

Reference a variable using double curly braces, for example {{ start_date }}.

Q: Are variables available on all plans?

Variables and shared defaults are available on Pro and Enterprise.

Define typed inputs with safe defaults so every Run Now and scheduled export uses the intended parameters. Variables keep queries reusable without copying SQL for each environment, date range, or customer.

Start free No credit card required. See the query workspace

Variables are available on Pro and Enterprise.

Define variables in the variables panel

Open the variables drawer from any query tab, click Add variable, and set a name, type, and default value. Prefer typed inputs (Select, Text, Number, Date) so teammates do not need to guess formatting.

Use variables inside SQL

Reference variables with double curly braces, for example: {{ start_date }}. DataPilot reuses the same definitions and defaults for both Run Now and scheduled exports.

Tip

Keep names stable (for example start_date, end_date, customer_id) so schedules stay reusable as queries evolve.

Team consistency and plan gating

Variables and shared defaults support consistent reruns, repeatable schedules, and predictable exports. Pair variables with scheduling so teammates always download files generated with intended inputs.

Scheduling and exports Run history guide

Return to the workspace