ThoughtSpot acquires Mode to define the next generation of collaborative BI >>Learn More

Additional Resources

template

Defining Metrics: A Template 
for Working With Stakeholders

Guide

10 Things Modern Business 
Intelligence Should Enable Today

video

Watch a Product Tour of Mode

Get started with Mode

Make a Statement. Then Make Another One.

Image of author
Nick Binder, Product Marketing Manager

December 15, 2016

1 minute read

multi-statement-og

Today we're releasing the #1 most requested SQL editor feature: support for multiple SQL statements in one query. Hello, temp tables!

Combined with other brand new editor-focused features—highlight to run and query history—multiple SQL statements help analysts save even more time with Mode.

Temp table

Using multiple SQL statements, you can do much more than pull data back from the database. You can add variables and functions, manipulate data, define search paths, and even create temp tables.

For example, suppose you're writing a query that references the same aggregated dataset several times. You can use multiple statements to first create a temporary table of these aggregated values, and then run your query against that table, potentially making your query run much faster.

One more to go!

We're so excited to get this powerful feature into your hands. Be sure to keep the questions and product feedback coming—we're here to help!

Get our weekly data newsletter

Work-related distractions for data enthusiasts.

Additional Resources

template

Defining Metrics: A Template 
for Working With Stakeholders

Guide

10 Things Modern Business 
Intelligence Should Enable Today

video

Watch a Product Tour of Mode

Get started with Mode