Browse Generate SQL

Generate SQL

Ask Questions in Plain English

Describe the result you need in natural language while referencing exact schema fields where useful.

Steps

1

State the result grain

Describe what one row should represent.

2

Name measures and groupings

Include totals, counts, averages, dimensions, and date periods.

3

Describe filters precisely

Specify status values, boundaries, inclusions, and exclusions when known.

4

Select schema fields

Use Find schema fields while writing prompts to resolve ambiguous business terms.

Open the relevant SQL Mocker tool

Continue with this workflow in SQL Mocker when you are ready.

Related documentation