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.
Table Header Styling
TruncationNew controls to truncate columns headers to two lines. Always trying to make sure styling is in full control, and defaults look great.
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.
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.
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.
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.
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.
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.
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.
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.
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.