Contents x
    Changelog
    • 11 Apr 2025
    • 26 Minutes to read
    • Print
    • Dark
      Light
    Contents

    Changelog

    • Updated on 11 Apr 2025
    • 26 Minutes to read
    • Print
    • Dark
      Light
    Article summary

    Release notes tag.png

    Apr 10, 2025

    New Features

    • (Charts) Adding a new %d.%m.%y time format option for charts
    • (SQL Lab) Adds support for querying latest partition in BigQuery

    Enhancements and Fixes

    • (Dashboards) Fixes an issue with Chart CSV exports from dashboards
    • (Dashboards) Fixes issues when entering full screen mode on dashboards
    • (Embedded) Fixes the show_filters URL param when passed to embedded dashboards
    • Other various bug fixes and improvements

    Release notes tag.png

    Apr 07, 2025

    New Features

    • (Charts): Adds Aggregation Method for Big Number with Trendline (e.g. SUM, AVG, MIN, MAX, MEDIAN, and LAST_VALUE)
      image.png

    • (Databases) YDB Support: Introduced support for YDB as a new database engine.

    • (Databases) It’s now possible to sync permissions for a given database connection, to reflect new schemas/tables/etc in Data Access Roles (gradual rollout since March — now fully available).
      image.png

    • (Preset Manager) It’s now possible to search for users in the Team and Workspace Administration by email, and also filter by role (gradual rollout since March — now fully available).
      image.png

      Enhancements and Fixes

    • (API): UUIDs have been added to list API calls for better identification.

    • (Charts): Interactive Table now displays the verbose metric name if entered.

    • (Charts): Table chart comparison columns configuration is hidden when time_compare is empty

    • (Dashboards): Permalinks can now be passed to the cache_dashboard_screenshot endpoint.

    • (Datasets): The file uploads dialog now displays only allowed schemas.

    • (Databases): Datasets and queries are now updated automatically when database connections change.

    • (Embedded) Set a specific referrerPolicy for iframe requests to improve security.

    • (SQL Lab) Added a to_datetime Jinja filter for enhanced date-time manipulations.

    • (SQL Lab) Introduced Jinja macro current_user_roles() macro to retrieve roles of the current user.

    • Other various bug fixes and improvements

    Release notes tag.png

    Mar 21, 2025

    • (Databases) Fixes issues connecting to private Google Sheets
    • (SQL Lab) Fixes a bug where calculated columns may be duplicated when syncing columns
    • Other various bug fixes and improvements

    Release notes tag.png

    Mar 12, 2025

    • (Alerts/Reports) Fixes an issue with adding correct file extensions on attachments sent to Slack.
    • (SQL Lab) Fixes an issue with clearing schema display
    • Other various bug fixes and improvements

    Release notes tag.png

    Mar 10, 2025

    • (Alerts/Reports) Fixed an issue with Alerts and Reports where users implemented Slack with more than 20K channels in place. (See docs for information on upgrading to the latest Slack API).
    • (Datasets) Resolved an issue where calculated columns were not correctly retained correctly when updating queries underlying a virtual dataset.
    • Other various bug fixes and improvements

    Release notes tag.png

    Mar 05, 2025

    • (Databases) Improved support for Firebolt dialect
    • (Charts) Improved rendering of nested elements in Partition viz
    • (Home) Fixed pinning of tags on home/welcome page
    • (Home) Fixed issue with collapsing search input
    • Other various bug fixes and improvements

    Release notes tag.png

    Feb 20, 2025

    • (Dashboards) Fixed an issue with PDF downloads

    Release notes tag.png

    Feb 19, 2025

    • (RLS) Row level security now displays last modified date
    • (Charts) Improved stability of CSS and Handlebars editors in Handlebars plugin
    • (Datatsets) Virtual dataset columns are syncronized automatically when updating the SQL query
    • (OAuth) Improved usability the OAuth config form
    • Other various bug fixes and improvements

    Release notes tag.png

    Feb 06, 2025

    • (AI Assist) Added support for database catalogs
    • (Alerts/Reports) Now supporting a max width of 4800 pixels (doubling size)
    • (Charts) Small fixes to Pivot Table
    • (Databases) Fixes small issues with Pinot and Trino
    • Other various bug fixes and improvements

    Release notes tag.png

    Jan 22, 2025

    Enhancements and Fixes

    • (Charts) New "Interactive Table" visualization based on AG Grid
      image.png
    • (Dashboards) Fixed an issue where clicking the “Refresh dashboard” button wasn’t refreshing all charts in the dashboard
    • (SQL Lab) Fixed an issue where users were unable to update an existing query selected from the Saved Queries list
    • (SQL Lab) Cosmetic updates for the Query History pane
    • (Databases) Improved support for legacy Firebolt databases via a new sqlglot database dialect
    • (Audit Logs) Dashboard filter events are now visible in logs
    • (UI) Redesigned label component now visibile throughout the product
      image.png

    Release notes tag.png

    Dec 18, 2024

    Enhancements and Fixes

    • (Dashboards) Fixed an issue where clicking the “Refresh dashboard” button wasn’t refreshing all charts in the dashboard

    Release notes tag.png

    Dec 16, 2024

    Enhancements and Fixes

    • (Dashboards) Fixed an issue where tooltips on hovering on the filter bar in dashboards were sometimes blocking the filters from being clicked on
    • (Dashboards) Addressed an issue where clicking blank spots in the menu item to “Add and edit filters” on a dashboard wasn’t opening the modal properly
    • (Dashboards) Fixed an issue where the last modified date on dashboards was getting updated in some cases where no user action was taking on the dashboard
    • (Databases) Addressed an issue where database imports were sometimes returning an error even when the import succeeded

    Release notes tag.png

    Dec 11, 2024

    New Features

    • (Dashboards) Moved the “Add or edit filters” button into the filters settings icon
      image.png

    • (Dashboards) Moved Add Filter and Add Divider to new buttons at the bottom of the filter editing and creation modal
      image.png

    Enhancements and Fixes

    • (Charts) Added controls to hide percentages and totals from tooltips in time series charts
    • (Charts) Added new number formatting capabilities for the Handlebars chart using formatNumber and group . See here for examples.
    • (Charts) Addressed an issue where annotation layers were not getting updated when the chart changed orientation
    • (Charts) Fixed an issue where axis labels on bar charts would sometimes disappear in edit mode
    • (SQL Lab) Fixed an issue where error messages in SQL Lab were appearing duplicated
    • (Saved Queries) Added a link from the Name column of the Saved Queries page to more easily access your queries
    • (Databases) Fixed an issue where special characters in Databricks catalogs and schemas were not working properly
    • (Databases) Added support for user impersonation in the StarRocks database
    • (Embedded) Hid link icons for tabs and headers since embedded users don’t have access to use them
    • (API) Made improvements to our permissions API to reduce the occurrence of time outs

    Release notes tag.png

    Dec 4, 2024

    Enhancements and Fixes

    • (Dashboards) Fixed a visual bug with the undo and redo buttons in Dashboard edit mode
    • (Dashboards) Improved the color consistency in dashboards
    • (Datasets) Fixed an error where some reserved SQL keywords were causing datasets to error when being created
    • (Databases) When updating the database settings on an OAuth2 connection, we now clear existing tokens since they are unlikely to be invalid. Users will need to reauthenticate.
    • (Databases) Fixed an issue with Databricks where the connection was not working properly when the catalog or schema name had a special character in it

    Release notes tag.png

    Nov 26, 2024

    New Features

    Time Comparison in Big Number and Table Charts

    • Big Number with Time Period Comparison Chart Type

      This new chart type allows you to select a metric and a comparison time period (1 day ago, 1 week ago, 1 month ago, 1 year ago, the same range as the length of the original time period, or with a custom time range start date). The visualization will display the main metric, the comparison metric, the absolute change between the two, and the percent change between the periods.

      big_number_time_comp.png

    • Time Comparison Feature in Table Charts

      Tables now support the ability to compare to a previous time period with the same comparison options as above. The table chart will have a new # (previous metric), ∆ (absolute change), and % (percent change) column added for each metric in the table.

      table_time_comparison.png

    OAuth2 Support

    • (Databases) Support for OAuth2 authentication for BigQuery, Databricks, Snowflake, and Trino connections. This allows user permissions to be applied when running queries on the database.

    Updated Chart Types

    The following chart types have been updated. Existing charts will now use the version of the chart marked with the (Legacy) tag. These charts can be manually updated to the new chart types or the CLI command can be used to migrate charts to the new types.

    • New Heatmap chart. Compared to the legacy Heatmap, it has more accurate percentage calculations, server side sorting to respect row limits, and a more interactive legend control that allows selecting a subset of values
      heatmap_new.png

    • New Histogram chart with additional option to show values on the chart.
      histogram_new.png

    • New Sankey chart with clearer source and target controls in the Chart Builder.
      sankey_new.png

    • Added support to migrate Bar Chart (legacy) and Time-series bar charts (legacy) to the new Bar Chart

    Other Features

    • (Databases) Added support for the catalog heirachy for databases that support it, such as BigQuery (projects), Databricks, Presto, Snowflake, and Trino. In the “Advanced” section of a database, under “Other”, select “Allow changing catalogs” to enable this feature. Once enabled, users will see catalogs when selecting tables in SQL Lab, creating a new dataset, and when setting up Data Access Roles.
      database_catalogs.png

    • (Upload Forms) The CSV, Excel, and Columnar upload forms have been updated with new UI as well as improved error handling and better validation.
      upload_forms.png

    • (Users) Integrates with Slack to add avatars in Preset when the Slack token has been added for alerts and reports

    • (Alerts & Reports) Users can now optionally customize the subject line of email alerts and reports that get sent out

    • (Time Filters) Support for the “Current” time range that includes current calendar week, current calendar month, and current calendar year

    • (Charts) Updated tooltip formatting for Bar, Line, Big Number with Trendline and other chart types. Stacked chart types now show totals and percentages.
      tooltips_improvement.png

    • (Dashboards) A new Jinja macro{{ get_time_filter() }} has been added that returns the time filter that is applied to a specific column.

    Enhancements and Fixes

    • (Permissions) all_database_access permission now correctly grants access to all data in the workspace
    • (Dashboards) Users are now able to set a custom refresh frequency on dashboards in addition to the previously pre-defined options
    • (Dashboards) Enabled Drill By in time series charts that do not have a dimension configured
    • (Dashboards) Fixed an issue where tabs were unable to be added into columns when editing a dashboard
    • (Dashboards) Fixed an issue where filters were not showing all values when “Dynamically search all filter values” was selected in the filter configuration
    • (Charts) New color schemes have been added to charts and dashboards
    • (Charts) Added the option in the Customize panel to disable rendering of html in Table charts
    • (Charts) The Advanced Analytics controls section will now be hidden when a non-temporal column is set on the x-axis of a chart
    • (Charts) SQL comments are no longer removed when executing SQL statements
    • (Charts) Fixed an issue where the contribution % on tooltips when time offsets were calculated incorrectly
    • (Charts) Support for using mouse scroll in the Data Zoom option for charts
    • (Charts) New “Rose Type” control in Pie Charts allows for Nightingale chart support
    • (Charts) Added a label templating field to the Pie charts
    • (Charts) Pivot tables now support the “Export to Pivoted CSV” option from dashboards
    • (Charts) Export options are disabled when the user doesn’t have the correct permissions
    • (Datasets) Fixed errors that would appear with the latest[_sub]_partition Jinja macros
    • (Datasets) Added additional checks to ensure that dataset names are unique
    • (Databases) Added custom database connection form that includes the option to go to MotherDuck to copy and paste the access token and support forcustom_user_agent when connecting to MotherDuck
    • (Databases) Support for uploading data via CSV for Trino
    • (Databases) Resolved an issue that caused some Apache Spark statements to be non parseable
    • (Alerts & Reports) Adds a config to set an allowed minimum interval for alert and report schedules. Please reach out to support@preset.io if you’d like to customize your minimum report schedule interval.
    • (Alerts & Reports) Removed the ability to select duplicate notification methods
    • (Alerts & Reports) Resolved an issue where selecting a log retention of “None” was showing an error
    • (SQL Lab) Added the option to disable rendering of html in SQL Lab results table
    • (SQL Lab) Fixed an issue where some autocomplete details were cut off
    • (SQL Lab) Download and copy options are disabled from query results when the user doesn’t have the correct permissions
    • (SQL Lab) Saved queries show descriptions again in the Saved queries list
    • (SQL Lab) Fixed an issue where the Create Chart options was not enabled in SQL Lab for Pinot databases
    • (SQL Lab) Addressed an issue where SQL Lab would show an error when unable to decode a type that was returned for serialization
    • (World Map) Added Czech Republic country map
    • (World Map) Fixed an issue with the map of India
    • (World Map) Added Philippines regional map and cleaned up the Philippines provincial map
    • (World Map) Added Turkey’s regions
    • (World Map) Updated Ukraine map
    • (API) Added 403 response status codes

    Release notes tag.png

    October 16, 2024

    Enhancements and Fixes

    • (Charts) In Explore, when adding a new Metric or Dimension, the Simple tab will be opened by default
    • (Datasets) Fixed an issue where Drill By and exports weren’t working for charts that used Datasets with a Jinja {{metric()}} macro
    • (Databases) Fixed an issue where Firebolt queries were getting parsed incorrectly

    Release notes tag.png

    October 2, 2024

    New Features

    • (Databases) Support for connecting to Oracle Cloud databases

    Enhancements and Fixes

    • (Dashboards) Improved drop indicators when moving tabs around in Dashboard edit mode
    • (Dashboards) Fixed an issue where native filters appeared out of scope on example dashboards
    • (Charts) Fixed an issue where users would get an error when trying to download a pivot table to CSV
    • (Charts) Addressed an issue where chart configurations weren’t kept when switching datasets
    • (Queries) Moved the query context logs to appear under the SQL query for Snowflake queries when the feature flag for including user, workspace, dataset, chart, and dashboard info in queries is enabled 2
    • (Homepage) Fixed spacing on the Preset workspace home page

    Release notes tag.png

    September 26, 2024

    New Features

    • (Embedded) For teams using Embedded dashboards, admins are now able to see an embedded usage metrics dashboard. Visit the main Preset team page, click “Manage Team” and then “Workspace Metrics” and/or “Embedded Metrics” tabs.

    Embedded Usage Metrics.png

    Enhancements and Fixes

    • (Embedded) Fixed an issue where PDF exports were not working from embedded dashboards

    Release notes tag.png

    September 18, 2024

    Enhancements and Fixes

    • (Charts) Added a new control when Time Shift is used to allow selecting between using the original series colors or different colors for the time shifts
    • (Charts) Custom column labels in Raw Records tables now work properly for columns that do not contain aggregates
    • (Dashboards) Fixed an issue where some dashboards were not loading the filters properly
    • (Dashboards) Filters with the option “Select first filter value by default” now show an error message in the dashboard when the filters can’t be loaded properly
    • (SQL Lab) Improved performance by disabling the text editor in inactive tabs, fixing an issue with the cursor, and not re-rendering the JSON results modal
    • (SQL Lab) When opening a tab that references a deleted database, the user will see a warning message

    Release notes tag.png

    September 10, 2024

    New Features

    • (Databases) Added support for connecting to Airtable as a database

    Enhancements and Fixes

    • (Databases) Fixed an issue where Databricks connections with a blank Secure Extra configuration field were not working correctly
    • (File Uploads) Fixed an issue where some users were not able to upload files to their database successfully
    • (Performance) Improved the performance on the Home page of workspaces

    Release notes tag.png

    September 5, 2024

    Enhancements and Fixes

    • (Databases) Fixed an issue where Trino queries were not running
    • (Databases) Updated the Snowflake OAuth connection to not require a username and password
    • (Databases) Added support for Apache Doris
    • (Databases) OAuth for Databricks is supported now by adding the client info into the Extra field and enabling User Impersonation
    • (Dashboards) Updated example dashboards for new workspaces
    • (Dashboards) Fixed an issue where comments were appearing under other dashboard elements

    Release notes tag.png

    August 21, 2024

    Enhancements and Fixes

    • (Dashboards) Fixed an issue with generating dashboard thumbnails
    • (Dashboards) Addressed an issue where Viewers, Dashboard Viewers, and Embedded users were unable to download dashboards to PDF or PNG
    • (Datasets) On the Datasets list view, the Dataset field now shows the dataset name with the full schema and dataset in a tooltip

    Release notes tag.png

    August 13, 2024

    Enhancements and Fixes

    • (Queries) Fixed an issue where query comments about the user, chart, and dataset weren’t getting added to queries in some cases. This feature is currently behind a feature flag, reach out to the Preset team to start using this feature. 1

    Release notes tag.png

    August 7, 2024

    New Features

    • (Databases) Added initial support for connecting to Snowflake with OAuth
    • (Charts) Added a new control in Pivot Tables called “Render Columns in HTML Format”. This allows users to add hyperlinks in Pivot Tables.
    • (Charts) Added a new Histogram chart type. Previous histograms will be labelled as chart type “Histogram (legacy)”

    Enhancements and Fixes

    • (Alerts & Reports) Fixed an issue with the loading of Slack channel names
    • (Charts) Addressed an issue with autocomplete when using Custom SQL in the Chart Builder

    Release notes tag.png

    July 29, 2024

    New Features

    • (API) Added new endpoints for generating and downloading dashboard screenshots. Visit our API docs for more detailed information.

    Enhancements and Fixes

    • (Alerts & Reports) Fixes some issues with sending Alerts & Reports via Slack, and improved the Alert & Report creation process when setting up a Slack Alert or Report. The Slack bot still needs to be added to the proper Slack channel for Alerts & Reports to send properly.
    • (Tags) Tag filters on Dashboard, Chart, and Saved Queries pages are properly filtering out results again
    • (Dashboards) Drill to detail no longer truncates int64 values
    • (Dashboards) Addressed an issue where empty columns instead of tabs couldn’t be deleted when creating a dashboard
    • (Dashboards) The “Refresh Dashboard” button now refreshes filters in addition to charts
    • (Dashboards) Fixed a bug where generating a permalink of a tab on a dashboard would sometimes use the previous tab instead of the current one
    • (Dashboards) When switching to a new top level tab, the dashboard will scroll to the top instead of retaining the previous scroll position, so that users don’t see a tab that looks empty
    • (Charts) Fixed an issue that was adding extra space between the legend and the chart contents
    • (Charts) SQL comments will not be removed when executing chart queries
    • (Charts) Renames the Total column to Summary in Table charts
    • (Chart Builder) Fixed an issue where custom SQL filter clauses were sometimes unable to be changed and saved
    • (Chart Builder) Addressed an issue where the chart controls were sometimes incorrectly changing sizes when the browser window was resized
    • (Chart Builder) Fixed an issue where some chart controls were not properly unhidden after the user switches the chart from using a temporal x-axis to a non-temporal x-axis and back
    • (Chart Builder) The Advanced Analytics section is now hidden when the chart doesn’t use a temporal x axis
    • (Chart Builder) Changing the Y-Axis Axis Format control now updates the formatting accordingly
    • (Chart Builder) Fixed a bug where switching between Aggregate and Raw Records mode in Table charts would sometimes show an error
    • (Chart Builder) Fixed various issues with time shifts, including some calculations where the time shift granularity didn’t match the chart granularity, connecting time shifts lines when there is missing data, and fixing the patterns used when displaying multiple time shifts
    • (Chart Builder) Fixed a calculation error in tooltips when a bar or line chart was created with time shift and contribution mode enabled
    • (Chart Builder) Renamed some legacy chart types to include “Time-series” in the name
    • (SQL Lab) Addressed a rare case where switching tabs would cause a query from the previous tab to be run
    • (SQL Lab) Fixed a bug where switching tabs would sometimes show an empty state instead of having a database selected
    • (SQL Lab) Comments should be retained when executing SQL statements
    • (SQL Lab) The description column has been added back to the Saved Queries page
    • (SQL Lab) Fixed an issue where Trino and Presto schema previous were not working in SQL Lab
    • (SQL Lab) Improved the json serialization in SQL Lab to prevent hard failures
    • (Databases) The database modal will no longer close when clicking outside of the modal so that users don’t lose progress in connecting or editing a database
    • (Databases) Added support for the Apache Spark dialect so that Spark SQL statements are processed even when the dialect is not specified
    • (Datasets) Fixed an issue that was allowing some datasets with duplicate names to be created

    Release notes tag.png

    July 10, 2024

    Enhancements and Fixes

    • (Charts) The page size selector on Table charts should not be accessible to screen readers

    Release notes tag.png

    June 27, 2024

    Enhancements and Fixes

    • (Error Messages) Fixed an issue where raw html was displaying rather than a proper error message
    • (Charts Dashboards) New color schemes have been added

    Release notes tag.png

    June 26, 2024

    Enhancements and Fixes

    • (Dashboards) Improved the color consistency on dashboards. Series with shared labels across charts should share a color. Colors set in the Dashboard properties will still be respected.
    • (Chart Builder) Addressed an issue where the Color Scheme control would not show when users opened a chart from the dashboard
    • (Chart Builder) Fixed a bug where the top x results were not returning the right results in some cases

    Release notes tag.png

    June 20, 2024

    Enhancements and Fixes

    • (Permissions) Updated the “All database access” permission to give access to all datasets and databases, and thus all charts and dashboards
    • (Permissions) Fixed an issue where ****invites with different capitalization than the user’s email would not have the right account permissions
    • (Tags) Addressed an issue where some charts and dashboards were unable to be deleted if they had a tag applied to them
    • (Dashboards) Fixed some issues with dragging to resize a chart when creating or editing a dashboard
    • (Databases) Fixed some column type handling for Presto and Trino

    Release notes tag.png

    May 30, 2024

    Enhancements and Fixes

    • (Alerts & Reports) Fixed an issue where sometimes alert or report screenshots would be captured before all chart contents were loaded
    • (Tags) If a user doesn’t have the correct permissions to tag content, they will see an error message. When tagging items in bulk, the content that the user does have permission to tag will be updated correctly.

    Release notes tag.png

    May 22, 2024

    Enhancements and Fixes

    • (Dashboards) Addressed an issue where some charts would disappear until hovered over after a recent Google Chrome update

    Release notes tag.png

    May 2, 2024

    Enhancements and Fixes

    • (Databases) Updated Dremio database configurations to support certificates
    • (Databases) Added Dremio support for datetime[ms]
    • (Databases) Fixed an issue where % in queries were getting duplicated to %%

    Release notes tag.png

    April 22, 2024

    Enhancements and Fixes

    • (Chart Builder) Fixed an issue where users were unable to reorder metrics within the control panel
    • (Chart Builder) Operators such as > , < , and = were not being properly displayed in Conditional Formatting on tables

    Release notes tag.png

    April 18, 2024

    New Features

    • (Databases) Added a database level configuration to disable Drill to Detail. This can be found in the Advanced section of your database connections in Preset
    • (Charts) Added an “On dashboards” column to the Charts list, which allows users to see which dashboards a chart has been added to

    Enhancements and Fixes

    • (Dashboards) Users with the workspace role “Viewer” are able to use the Drill By feature again
    • (Dashboards) Added the ability to navigate through dashboard titles, charts, and chart controls using keyboard navigation
    • (Dashboards) Added labels for screen readers on dashboard filters and search
    • (Dashboards) Added a border to show the rows that will be changed when using the move, delete, or settings icon on the left side of dashboard edit mode
    • (Dashboard Filters) Made a fix so that screen readers can access the filter values that are used in the “Applied filters” tooltip
    • (Charts) Fixed an error where queries containing the word constructor would return an error
    • (Charts) Fixed a bug where some time shift data would not be showing when using a Time Shift in Advanced Analytics alongside a Row Limit configuration
    • (Chart Builder) When dragging a metric from the dataset panel in the Chart Builder to the control panel, the drop indicator will more clearly show the valid areas where a metric can be dropped
    • (Chart Builder) Increased timeout on chart annotation layers
    • (Chart Builder) When a chart has one remaining temporal filter, clicking the X will now clear the filter values rather than showing the user a warning message to not remove the last temporal filter
    • (Datasets) When using the latest_partition('table_name') Jinja macro, any leading or trailing whitespace will be removed from the table name
    • (SQL Lab) Comments in executed queries are no longer stripped
    • (SQL Lab) Improved the error that is displayed when there is a syntax error in a query
    • (Homepage) Users who don’t have access to charts and queries will no longer see those tabs in the Homepage

    Release notes tag.png

    April 11, 2024

    New Features

    • (Alerts & Reports) Users can now select a PDF option when creating an Alert or a Report
      Report PDF.png

    Enhancements and Fixes

    • (Chart Builder) Improved performance and rendering of the dataset columns list in the left panel
    • (Chart Builder) The row count indicator in the top right of the chart builder has been updated to reflect the number of rows from the database, before any processing is done on the data. It will turn red when the row limit set in the control panel has been reached and the chart may be showing partial data.
    • (Chart Builder) Improved feedback on the Control Panel when the user is trying to drag and drop a column into a control area that is not allowed
    • (Charts) When charts are loading, additional information has been added to the spinner to help users understand the loading process
    • (Bar Charts) Fixed an issue where using “Stacked” mode and a Time Shift would stack all time shifts in the same bar. Different times shifts will now show as their own stacked bars.
    • (Bar Charts) In horizontal bar chart mode, the chart legend no longer overlaps with the content of the bar chart
    • (Dashboards) When editing a dashboard, hovering over the menu icons on rows now shows the border of the entire row, clarifying the charts that will be affected by any changes
    • (Datasets) Added a new Jinja macro {{ metric('metric_key', dataset_id) }} to retrieve metric syntax from a dataset so that it can be re-used in charts, SQL Lab, datasets, etc.

    Release notes tag.png

    Mar 27, 2024

    New Features

    • (Dashboards) Improved drag and drop usability when creating or editing dashboards. Users will now see clearer and larger drop areas when moving dashboard content around
      dashboard-dnd-1.png

    288581393-9ac99f4f-2bf9-40fc-862b-49497d24e4a2.jpg

    • (Alerts & Reports) New modal for setting up Alerts & Reports in a linear process, with better grouping of the configuration fields. 1

    • (Permissions) Row Level Security rules no longer require setting up an empty Data Access Role and can now be associated to any Data Access Role

    • (Permissions) Data Access Roles and Row Level Security can now be set up for invited users who have not yet accepted their invites. Search for them using their email address and “Pending Invite” in the user list.

    • (dbt) Preset’s dbt integration has been upgraded to support the new metric and measure schemas introduced in newer versions of dbt, which provides a path for upgrading to dbt 1.6 and 1.7 2

    Deprecations

    • (Dashboard Filter Boxes) Old dashboard Filter Box chart types have been migrated to the filter bar. Any previous filter boxes have been updated to Markdown components in the dashboard and can be removed by a dashboard owner.
    • (Sunburst Charts) Sunburst charts have been automatically migrated to the new Sunburst chart type
    • (Datasets) Added validation on date formats. Format %Y%m%d is not currently supported and will show the user an error, please migrate these dates to a supported format such as %Y/%m/%d
    • (Redirects) Short URL links with format /r/{id} from 1.5 years ago or older will no longer redirect

    Enhancements and Fixes

    Databases

    • (SSH Tunnelling) Fixes an issue where SSH tunnels were not being removed properly from database connection configurations
    • (SSH Tunnelling) Added an error message when the port in the database configuration form was missing
    • (Clickhouse) Fixed an issue where datasets couldn’t be created if SimpleAggregateFunction was used
    • (Pinot) Addressed an issue where epoch ms timestamps and datetime conversions were incorrect
    • (Trino) Fixed an error that occurred when fetching Hudi table schemas

    Datasets

    • (Creation) Added additional data access validation during virtual dataset creation
    • (Configuration) Dataset extra configuration option {"disallow_adhoc_metrics":true} will only allow dragging and dropping saved metrics to the Chart Builder Metrics field

    Charts

    • (Data Zoom) The data zoom tool now changes orientation when the chart orientation is updated from horizontal to vertical
    • (Resample) Fixed an issue where the Resample Fill Methods were not working correctly if the time index was present
    • (Results) Fixed an issue where the Results tab in the Chart Builder would sometimes display an infinite spinning icon
    • (deck.gl Multiple Layer Chart) Added deck.gl Heatmap and deck.gl Contour Layers to the deck.gl Multiple Layer Chart
    • (Gauge Chart) Fixed the color boundaries when interval bounds and a minimum value are set
    • (Heatmap) Numeric X and Y axes are now sorted correctly
    • (Mixed Chart) Label colors specified in Dashboard properties are now applied properly
    • (Time Series Charts) The Y-axis format is correctly applied when contribution mode has a value other than ‘None’
    • (Time Series Table) Negative time lag values are now allowed, making it possible to compare to the beginning of the time range
    • (World Map) Repositioned the Overseas departments and regions of France (DROM) to be displayed in one view and improved the rendering of the map view of France

    Dashboards

    • (Dashboard Creation and Editing) Fixed an issue where table chart types were displaying larger than their chart container when dragging to move them in dashboard creation and edit modes
    • (Filters) When set to a slider, the dashboard filters now slide properly for values between 0 and 1
    • (Performance) Charts now display additional information on the loading spinner about the status of the chart load
    • (Permissions) Users will now see an error message and be redirected to the Dashboards page when trying to access a dashboard they don’t have permissions to see using a permalink

    SQL Lab

    • (Performance) Improved the initial loading time for SQL Lab
    • (Tabs) SQL Lab no longer shows invalid placeholder text when closing a tab
    • (Tabs) Added back the placeholder image for query results in a new SQL Lab tab
    • (Tabs) Fixed an issue where closing a tab that had been removed in another window would throw errors
    • (Tabs) The cursor saves its position when switching between SQL Lab tabs
    • (Left Panel) Fixed an issue where Databases weren’t appearing correctly when typing into the search bar
    • (Results) Fixed an error that caused the json modal in SQL Lab results that contain json blobs to be flaky
    • (History) Addressed an issue where SQL Lab history would display errors

    Alerts & Reports

    • (Configuration) Updates the Screenshot Width configuration option to accept only numeric values
    • (Logs) When alerts fail, the logs no longer show query and query result information for security purposes

    Other

    • (API) The owners field on datasets and charts is no longer lost if it is not included in the update payload
    • (dbt) Updated UI to allow specifying custom dbt Cloud API URLs when setting up the database sync
    • (Embedded) The Embedded SDK will no longer fire requests to refresh the guest token after the embedded iFrame is unmounted
    • (Embedded) New Macro {{url_param()}} fetches parameter values from the dashboard URL
    • (Errors) Addressed an issue where errors and messages in the bottom right of the application would be duplicated
    • (List Views) Fixed a bug where selected filters on the list view were not applied when changing the sort order
    • (List Views) When refreshing the list views, the sort order is retained
    • (List Views) User will be redirected to the first page of a list view if an invalid page is entered
    • (Imports) Added a validation to prevent users with limited permissions to import charts and dashboards that already exist
    • (Jinja) New Macro {{curent_user_email()}} is added that can support applying RLS based on the logged in user
    • (Permissions) Improves performance on page load of the Data Access Roles page
    • (Queries) A limit is no longer applied to SELECT * queries in databases that don’t support LIMIT
    • (Queries) Adds dashboard_id and renamed slice_id to chart_id in comments to queries that are run, when the feature flag to enable query logs is enabled 2
    • (Tags) Fixed an issue where dashboards with duplicated tags were sometimes not deleting properly
    • (Uploads) Corrected a data type on the CSV and Columnar upload forms

    1: Available on the Professional and Enterprise plans only.
    2: Available on the Enterprise plan only.

    Earlier Releases

    See Preset's product announcement blog for key updates.

    Was this article helpful?
    What's Next