Mode Analytics is a collaborative business intelligence platform that unifies SQL editing, Python/R notebooks, and visual analytics in a single browser-based workspace. Acquired by ThoughtSpot in 2023, Mode is designed for data teams that need reproducible analysis alongside self-serve dashboards. The cheat sheet below covers every major surface from query authoring to embedding, performance, and administration.
What This Cheat Sheet Covers
This topic spans 17 focused tables and 124 indexed concepts, 115 flashcards. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
A jump-to index of every table row in this cheat sheet.
An interactive map of every table and concept in this topic.
SQL Editor
The Mode SQL editor (built on Ace) provides context-aware autocomplete for tables, columns, and schemas, and supports multiple simultaneous queries within a single report. Each query tab produces a named result set that downstream notebooks and visualizations can reference independently.
| Concept | Example | Description | |
|---|---|---|---|
Add a second query tab with the + button | • Each query in a report has its own editor tab • results are named Query 1, Query 2, etc., and are independently referenceable by notebooks and charts | ||
Click the database icon on the left rail | • Displays all accessible schemas, tables, and columns for the connected warehouse • refreshes automatically once per day at 10:05 AM UTC | ||
Type sel → press Tab | • Context-aware completion for SQL keywords, table names, column names, and SQL functions • triggered automatically as you type | ||
Click the Format button or use the keyboard shortcut | Reformats the entire query with consistent indentation and casing using a built-in SQL formatter. | ||
Toggle the Limit 100 switch in the run bar | • Appends LIMIT 100 to the query at run time without modifying the source SQL• useful for previewing large tables cheaply | ||
Click View History in the query menu | • Shows a timestamped log of all previously run versions of the query • allows restoring an earlier version | ||
Cmd/Ctrl + Enter to run; Cmd/Ctrl + / to comment | Common shortcuts include run query, format, comment/uncomment, and navigate between query tabs. | ||
Manual run: 12 h; hourly schedule: 1 h | • Mode enforces warehouse-side timeout limits that differ by trigger type • scheduled runs at higher frequencies receive shorter timeouts |