Demos

Dashboard themes, dashboard vanity URLs, XLOOKUP portability, in_query, single-use views in topics and much more!

August 2, 2024

Lots of new goodies across the product:

  • Views in topics - now one-off view tweaks can be customize at the single-topic level for powerful, elegant tuning of the data model

  • Now dashboard styling (CSS, fonts, colors, backgrounds) can be stored into themes that can be used on any dashboard

  • New settings for vanity dashboard URLs, making navigation simple and contextual

  • Easily move XLOOKUPs and dependent queries across workbooks

  • In_query for super dynamic SQL

  • Period-over-period with timeseries

  • Dynamic DB connection swapping

  • Early work on SQL with table calculations

  • Snowflake key-pair authentication

  • Table header truncations stylings

  • Filter improvements

Dashboard Filter Improvements

A bit more work to improve performance when filters are left empty.

Dashboards, Filters

Table Header Styling

Truncation

New controls to truncate columns headers to two lines. Always trying to make sure styling is in full control, and defaults look great.

Workbook, Tables

Dashboard Themes / Styling Manager

Now dashboard styling (CSS, fonts, colors, backgrounds) can be stored into themes that can be used on any dashboard. This new UX allows styling directly in the app, and easy management for consistent, custom styles with minimum effort.

Dashboards, Embed

Dashboard Vanity URLs

New settings for vanity dashboard URLs, making navigation simple and contextual - now it's as easy as dashboard/CorporateDash instead of dashboard/1 or dashboard/lkjdfs (unless you want that!). This also means that you can more easily make updates to an embedded dashboard without requiring an engineer to point from one identifier to another, by instead pointing to a fixed, immutable URL.

Dashboards

XLOOKUP and Filter-by-Query Portability

Moving queries across workbooks is usually simple, but not when your queries reference other queries - until now. Now you can move queries with XLOOKUPs or queries with filters from other queries to any workbook, and the dependencies come with - no more thinking, all just works.

Wrokbooks, Calcs

SQL with Sorts, Column Labels, and Calcs

A first look at our effort to bring all of the Omni goodness to SQL queries as well. Instead of forcing users to wedge calculations or column relabels or sorts into the SQL block, now it's just simple actions on top of the result table. Little bit more work to do here, but coming soon.

Workbook, Sql

in_query Model Parameters

More flexibility for your data models - in_query allows for dynamic SQL generation based upon the structure of your query. This opens up all sorts of new use cases for flexible SQL based upon the filters or columns selected.

Modeling, Workbook

Period-Over-Period with Time Columns

The finishing touches on our period-over-period implementation now offer dynamic time offsets even with other time fields selected. An easy way to pull up time offsets without impacting the structure of your baseline query.

Calcs, Workbook

Dynamic Database Connections

New functionality that allows for dynamically swapping the database connection from a branch. Easily switch between prod or staging schemas (not just dbt) in the UI - great for testing data models across mirrored databases during migration or other more complex deployment use cases.

Modeling, Administration

Snowflake Key-Pair Authentication

Some fresh code for using key-pair authentication with Snowflake - providing an extra layer of security to basic authentication (ie. username and password) when accessing your Snowflake. Wrapping up code review and tests on it, we expect it to be live next week.

Administration

Views in Topics

Sometimes you need to customize a view for the purpose of a single topic - new labels, new fields, maybe even different field definitions. Now you can. This work opens up a views: argument inside topics, that allow for ad hoc view declaration, extension, or overrides, without impacting the core view files. Enormous flexibility with this feature to customize topics to any use case - now everything is fair game inside the topic specifically.

Modeling