Skip to content

Release notes

DataSquares ships continuously: features reach your workspace as they’re ready, with no upgrade to schedule and no maintenance window to sit through. This page is the human-readable trail of that — the changes you would actually notice, newest first, each one linked to the page that documents it. Small internal work and routine hardening aren’t listed.

A large period. The headline is that measures stay exact across a fan-out join — a class of silently wrong number that most BI tools either get wrong or refuse outright.

  • Exact aggregates across fan-out joins. When a join multiplies rows — one order joined to many order lines — a plain COUNT DISTINCT, MEDIAN or SUM over the “one” side used to be computed over the multiplied rows. Those measures are now evaluated at their own grain and joined back, so the number matches what the source would give you. Chains several hops deep are handled the same way. Where a shape genuinely can’t be answered exactly, the refusal now names the blocking table and the fix instead of failing generically. Data models & relationships
  • Dashboard version history. Semantic models take version snapshots you can review and restore — so an edit that breaks twenty cards is a rollback rather than an archaeology project. Data models & relationships
  • Two people editing one dashboard no longer overwrite each other. Editor saves now carry a version token; the second save is rejected with a clear conflict instead of silently winning. Canvas basics
  • Data-quality checks can hold publication. Mark a check critical and a failing result blocks the asset from being published — on every surface that publishes, not just the one you were looking at. Data quality
  • MFA recovery codes. Ten single-use codes, issued once and stored hashed, so a lost authenticator isn’t a support ticket. Using one is audited. SSO & MFA
  • HTML report export is genuinely self-contained. The exported file now carries everything it needs and opens correctly offline. Exports
  • Metric-bound KPI tiles reach paper. Tiles driven by a governed metric were skipped in server-side exports; they now render in all five formats, with the metric’s own name as the label. Exports · Governed metrics
  • Embedded analytics gets white-label branding and usage rollups — see how much each embed is actually used, and strip DataSquares chrome from it. Sharing & embeds · React embed SDK
  • The audit log became tamper-evident, and can be exported. Every row is chained to the one before it, edits and deletes are refused by the database itself, and there is an endpoint that verifies the chain. Export as CSV for a reviewer, or as a cursored NDJSON feed for a SIEM. Log Explore
  • Catalog ownership. Assets carry an owner and a domain, with facets and an “unowned” view for finding the gaps. Catalog
  • Log Explore returns up to 5,000 rows (was 500), with a row-limit control. Log Explore
  • Fixed: week-grain year-over-year compared against the same calendar date a year earlier rather than the same week — it now aligns 52 weeks back, which is what a weekly comparison means. Charts & formatting
  • Fixed: large file uploads are streamed to disk instead of held in memory, so big imports stop competing with everything else for RAM. Connector catalog
  • Each workspace now gets its own warehouse credential, granted access to only its own database — cross-tenant reads are refused by the database engine rather than by application code. Nothing to configure. Warehouse
  • Compute controls. For self-managed fleets: a placement policy for where runs land, drain/resume/stop on individual workers, and a scale timeline with a time-to-start SLO. Pipelines refuse to place on a worker too old to validate their definition, rather than failing every run. Pipelines
  • The React embed SDK shipped to npm. @digisquares/datasquares-embed-react — a <DataSquaresEmbed> component instead of hand-rolled iframe plumbing. React embed SDK
  • Per-user dashboard access. Share with named people at a chosen level, above whatever their workspace role allows. Sharing & embeds
  • Dashboard delivery schedules. Send a dashboard on a schedule, rendered server-side, with the filter state you chose. Reports
  • The table card became a real grid — per-column filter and search, paging, frozen columns and draggable widths. Table
  • AI got a lot more useful. An insights feed, a SquareX copilot in the measure editor, Ask AI inside embeds, dashboard-from-a-prompt, scheduled anomaly sweeps over certified metrics, an AI data-quality scan with ranked findings, and a keyless seasonal forecast. AI chat · AI dashboard generator
  • Search that finds things by meaning, over your glossary and asset names. Semantic search
  • Exports honor a table card’s column configuration in every format. Exports
  • Map overhaul. Location matching now ignores case, accents and punctuation, resolves the common aliases (USA, UK, Viet Nam, Korea, South, Türkiye), and reads rows that name several countries at once (United States, India). The underlying world map is finer, too: around 60 smaller countries — Singapore, Hong Kong, Malta, Bahrain and the rest — now have a shape to shade instead of quietly falling off the map. See Map.
  • A Map section in the Format panel. Pin the location level (world countries or US states) instead of relying on auto-detection, lock or allow pan and zoom, and control the color scale and its min/max range. Values that still don’t match anything are collected in a notice on the card — click it open to see exactly which ones didn’t bind. Maps also gained a Tooltip well, so you can put extra context under the region name on hover. Map · Charts & formatting
  • Per-category chart colors. Pick a color per slice, step or bar straight from your data’s own values — with a hex box and one-click reset — instead of taking whatever the palette hands you. Charts & formatting
  • Field search that finds fields you can’t see. Search in the dashboard builder now reaches inside tables you haven’t expanded, and matches model, table, column and measure names. Canvas basics
  • Fixed: switching to the phone viewport could leave a dashboard’s desktop layout compressed until you refreshed the page. Layout & productivity

Pipelines — currently in Early Access — landed a release of its own this period.

  • A full transform engine. Reshape data mid-flight with 15 visual operations, drop to raw SQL where it’s faster to say it in SQL, run a sandboxed Python step for the things SQL can’t express, and route rows down different branches on a condition. Building a pipeline
  • Triggers, not just schedules. Alongside scheduled runs, a pipeline can now start on file arrival (a new file lands in a watched location), on another pipeline finishing, or on an inbound webhook from whatever system you want to be the clock. Runs, backfill & monitoring
  • Change data capture from Postgres. Move only what changed — inserts, updates and deletes — rather than reloading the table each run.
  • Write-back destinations. Land results in your own databases, warehouses and object stores, so a pipeline can feed the systems downstream of DataSquares as well as DataSquares itself.
  • Five new chart types. 100% Stacked Bar and 100% Stacked Area for share-of-total questions, Combo (Stacked + Line) for a total split by category with a trend across the top, Pareto for “which few things account for most of this?” (ranked bars plus a cumulative % line), and Lollipop for ranked comparisons with far less ink than bars. All visual types
  • A Format panel that tells the truth. The panel now shows exactly the controls the selected chart honors — no more options that sit there and quietly do nothing. Charts & formatting
  • SquareX: 12 new functions, bringing the language to 39. Quarter- and month-to-date (QTD, MTD); Fixed(… IgnoreFilters) for a value that stands outside the user’s filters; Percentile for p50/p90-style distribution work; the iterator family (SumX, AvgX, MinX, MaxX) for row-by-row math before the aggregate, plus CountRows; view-relative Include and Exclude; and the semi-additive LastNonEmpty and PeriodEndSnapshot for balances and stock levels that must never be summed across time. Nested Calculate and Fixed × Calculate compose, and both editor autocomplete and the measure-builder templates cover the new surface. All SquareX functions · Recipes
  • Visual query builder. Build a query as a chain of steps — source, filter, group, join, and so on — with a live preview at every step and the generated SQL visible underneath, so you can start clicking and finish in SQL. Visual query builder
  • MCP server. Point Claude — or any MCP client — at your workspace over a read-only, governed tool surface: it sees exactly the data your permissions allow, and nothing it does can change anything. MCP server
  • Warehouse. Import a table or a saved query into DataSquares’ managed storage and chart it like any other source. Refresh on demand or on a schedule; the swap is atomic, so a query never sees a half-loaded table. Warehouse · Refreshing
  • Themes v2. Detailed design tokens, four new themes, per-token overrides, a contrast guard that stops you shipping unreadable text, a brand generator that builds a theme from your colors, and Power BI theme import. Themes
  • Metrics hub. Define a KPI once — with certification badges and owner and domain stewardship — then bind KPI cards to it, so “revenue” means the same thing on every dashboard. Governed metrics
  • Business glossary. Org-wide definitions with synonyms, surfaced where people actually need them: in AI answers and in field tooltips. Catalog: certification & glossary
  • Card insights. Explain this change on any card, Analyze for anomalies, key influencers and forecasts, and AI card summaries that travel with the card into shares and embeds. Card insights
  • Viewer exploration. Viewers can personalize a visual, spotlight a card, zoom a chart, comment with @mentions, keep favorites and a recently-viewed list, set a personal default bookmark, and subscribe themselves to a report — without editor rights and without touching your dashboard. Exploring dashboards
  • PowerPoint export for dashboards, multi-page PDF, and copy-a-card-as-image for when you just need it in the deck. Exports
  • Menu Builder. Content-as-navigation: build the sidebar your org actually reads, let people personalize it, and define custom roles with per-menu permissions. Users, roles & invites
  • Mobile apps. An Android companion app — SSO and biometric sign-in, dashboard viewer, metrics hub with sparklines, alerts and an offline cache — with an iOS parity port alongside it. Early access
  • Studio. A free desktop designer with an embedded engine: pull from local files and databases, use the full canvas offline, and publish to (or pull from) your workspace when you’re ready. Early access
  • Conditional formatting gained text color and bold, not just background fills. Charts & formatting
  • AI authoring moved onto the new agent for charts, dashboards and reports — and Save to dashboard now produces a fully re-queryable card rather than a snapshot. AI dashboard generator
  • World map, drill-through and drill-down. A world map chart, cross-dashboard drill-through (click a value, land on the detail dashboard filtered to it), hierarchy drill-down inside a chart, and Show Me chart suggestions for when you know the question but not the shape. Filters & interactivity · Charts & formatting
  • Report parameters. Prompt for filter values at export time, so one report serves every region — plus PowerPoint report export with native, editable charts. Reports
  • Filters, rebuilt. On-canvas slicers, a dockable Filters panel, an always-visible active-filter bar, and cross-filter chips a human can read. Filters & interactivity
  • Saved views (bookmarks), dashboard auto-refresh, and per-card freshness badges so nobody presents a stale number. Exploring dashboards
  • Dashboard parameters with URL state — the link you send reproduces exactly what you were looking at. Filters & interactivity
  • Calculated fields got a real formula editor. Calculated fields
  • Data quality. Define tests, scan tables against them, and track freshness, so a broken source announces itself before a dashboard does. Data quality
  • Metric alerts. Threshold conditions, scheduled evaluation, and notifications when they fire. Metric alerts
  • Chart formatting. Axis titles, per-series colors, number formats, field aliases, Top N, and a date-bucket selector. Charts & formatting
  • Paginated (operational) reports — multi-page tabular PDF for the reports that are meant to be read row by row. Reports

Connectors ship continuously rather than in waves, so they get their own section. The catalog now stands at 141 connectors, 66 of them generally available — that count is read from the same registry that drives the product’s connection wizard, so it cannot drift from what you see in the app.

August 2026 — object stores went generally available. Amazon S3 (and any S3-compatible store: MinIO, Cloudflare R2), Azure Blob Storage, ADLS Gen2 and Google Cloud Storage now have real connection forms in the wizard — each with its own credential shape. Connect one and you can browse the bucket and import Parquet, JSON/NDJSON or CSV objects as staged datasets; pipelines can still read and write them in bulk. See Amazon S3.

Added earlier:

Alongside the new entries, dozens of value-correctness fixes went in across ClickHouse, BigQuery, Trino, Databricks, Oracle, Elasticsearch, Druid, Pinot, Dremio, Drill, Athena, Db2 and HANA — the unglamorous work of making sure a number in DataSquares is the number the source would have given you.

Browse the connector catalog or check the connector support matrix for the full, always-current list.