Guides

·

5 min read

How to ask a question that gets good SQL

How to ask a question that gets good SQL

How to ask a question that gets good SQL

Name the metric, the time range and the breakdown. Three habits that make answers right the first time.

Name the metric, the time range and the breakdown. Three habits that make answers right the first time.

Lena Park

Solutions Engineer

Tessel turns plain English into SQL, and like any colleague it does better with a clear question. After reviewing thousands of questions from customers, three habits stand out.

Name the metric

“How are we doing in Europe” could mean anything. “Net revenue in EMEA” maps to a defined metric and a known dimension. Use the names on your metric pages and the query writes itself.

Say the time range and the grain

“Weekly net revenue since June” is three decisions made for you: the metric, the grain and the window. Leave them out and Tessel picks sensible defaults, which may not be yours.

Then read the SQL. It sits next to every chart for a reason, and checking it takes less time than explaining a wrong number later.

Ask your first question today.

Connect a warehouse in ten minutes. Free for up to three seats.

Ask your first question today.

Connect a warehouse in ten minutes. Free for up to three seats.

Ask your first question today.

Connect a warehouse in ten minutes. Free for up to three seats.

Create a free website with Framer, the website builder loved by startups, designers and agencies.