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. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
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. |