← Back to all sparks
M

Mode Analytics

ANALYTICS
Velocity0.0

Mode resurfaces after almost five quiet months with per-user Snowflake sign-in

business intelligencesnowflakeoauthdata governancespreadsheet ui
◆Current state
After the spreadsheet mode in April, this feed shows nothing until September, when Mode added OAuth and OAuth with PKCE for Snowflake. Each user now signs in with their own Snowflake credentials, including SSO, and queries run under that user's permissions. Earlier 2026 work still defines the product: spreadsheets with 70+ formulas beside SQL and Python, cross-source Data Mashup, and a refreshed SQL editor.
◆Where it's heading
Mode's 'one workspace for SQL, Python and spreadsheets' position stands, but the pace on this feed has slowed sharply. The Snowflake change is a governance move, replacing a shared service account with warehouse-level permissions per user, which continues the earlier admin work. It adds no analyst-facing capability.
◆Prediction
The single entry since April gives little to project from. OAuth for other warehouses would be the natural follow-up, but the feed does not confirm it.

◆Recent moves

  1. 1mo ago

    OAuth support for Snowflake

    Per-user OAuth for Snowflake removes the shared service account and applies each person's warehouse permissions to their queries. It is a governance upgrade rather than analyst capability, and the first entry here since April.

    View source ↗
  2. 6mo ago

    Native spreadsheet mode lands in Mode reports

    ⚡ SPARK

    Mode adds a native spreadsheet mode inside the report editor — 70+ Excel-style formulas, low-code prep tools, and switching between SQL, Python, and grid views in a single report. Removes the export-to-Excel detour that breaks every governance story.

    View source ↗
  3. 8mo ago

    White Label Embeds : Per-Visualization Data Downloads

    White-label embeds gain per-visualization data downloads, with the active filters respected. Workspace-level toggle keeps governance simple. Targeted depth for product-analytics customers whose end-users have been asking for granular CSV exports.

    View source ↗
  4. 8mo ago

    Data Mashup enables cross-source SQL joins in one report

    ⚡ SPARK

    Data Mashup ships in early-release invite-only — SQL joins across disparate data sources (different warehouses, flat files) within a single report, backed by a cached layer for performance. Removes the longstanding 'one connection per report' constraint without requiring ETL pre-work.

    View source ↗
  5. 9mo ago

    New and Improved SQL Editor

    Major SQL editor refresh: smarter autocomplete handling CTEs and case-sensitive names, a high-contrast theme, code folding via region markers, and parallelized metadata fetching to eliminate suggestion lag. The kind of tooling polish that disproportionately improves daily-driver experience for query-heavy analysts.

    View source ↗
  6. 1y ago

    Introducing Shareable Report Views

    Filtered report views can now be shared via URL with no expiration. Closes a long-standing collaboration gap where viewers had to re-apply filters every time. Small but high-leverage for teams operating from shared bookmarks.

    View source ↗