Changelog Archive

March 22, 2023

Highlights

Non-temporal X-axis is now generally available (GA). The updated X-axis allows you to visualize trends and patterns over variables beyond temporal dimensions in Preset charts (formally known as time-series charts). This feature was in beta and is generally available (GA), with chart names and the Chart Builder interactions updated in this release. Read our blog to discover what's changed in detail.

Enhancements and fixes

• (General) The “Explore” view has been renamed as the “Chart Builder” view to better reflect its functionality.
• (Dashboard) Users without the proper dashboard editing permission (i.e., Viewers) can no longer enable or disable cross-filters on the dashboard.
• (Dashboard) You can now select text in cells of the table charts and pivot table charts without triggering cross-filters.
• (Dashboard) You can now apply cross-filters to only the charts containing compatible datasets without causing database errors on the remaining charts with incompatible datasets.
• (Dashboard) The “Search” icon in the FiltersBadge, which indicates where the cross-filter is emitted from, is clearly visible on hover.
• (Dashboard) Cross-filters apply correctly when you create a new dashboard or add a new chart to an existing dashboard.
• (Dashboard) Cross-filters applied to time-shifted series return expected behaviors.
• (Dashboard) We fixed an issue that caused the dashboard to get stuck in the loading state when it contained an out-of-scope filter with the "Select first filter value by default" enabled.
• (Dashboard) Clicking the “cross-filter search” icon in the dashboard filter bar no longer grays out the entire dashboard.
• (Chart Builder) We fixed the blank state of the "Customize" panel issue in the Chart Builder view of the Heatmap charts.
• (Chart Builder) When exploring a chart in the Chart Builder view after applying a cross-filter on an ad-hoc column, the filter now correctly translates to the SQL ad-hoc filter.
• (Trino database) The table charts correctly display timestamps with timezones in Safari browsers when you query datasets created from the Trino SQL query engine.

To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.

March 9, 2023

Highlights

Cross-filtering is available to all users by default, enabling self-serve data exploration: Users with any workspace-level role can now apply cross-filters in dashboards, making it easier to understand the nuances of data and tell their story. Cross-filtering allows users to interact with a chart or a table and apply the same filters to other visualizations in the dashboard without having to set up persistent filters in the dashboard filter bar. Previously, cross-filtering needed to be enabled by Workspace Admins and Contributors through the Chart Builder view; now users with Viewer access can set up cross-filters and self-Chart Builder their data.

Key cross-filtering updates in this release include:

• You can immediately apply cross-filters in the dashboards. The chart creator no longer has to mark a chart as usable for cross-filtering.
• You can see applied cross-filters in the vertical and horizontal filter bars.
• Graph charts and world maps are eligible for cross-filtering.
• Cross-filtering is no longer accessible through the Chart Builder view.

Enhancements and fixes

• (RBAC) The data access role, Database Access, lets you see all dashboards, charts, and datasets associated with the databases you have access permissions for in their list views¹.
• (Database) You can edit the SSH tunneling setting for existing databases connected to Preset using the dynamic form².

To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.

¹: This feature is available on the Professional and Enterprise subscriptions only.
²: This feature is available on the Enterprise subscription only.

February 28, 2023

Highlights

• UI support for SSH Tunneling¹: Setting up secure connections via SSH Tunneling is made easier in this release. In addition to the API or SQL Alchemy forms announced earlier, you can now connect your database and Preset via an SSH tunnel using a dynamic form. SSH tunneling provides an additional layer of security by directing data traffic to flow inside an encrypted SSH connection, acting as an alternative to native data encryption.

• More intuitive workflow for creating datasets: The new workflow for creating datasets allows users to have a better understanding of the hierarchy of a database, schema, and tables. Users can create a new dataset from a table that has no associated dataset, and they will be prompted to view the existing dataset if it has already been created for the table.

New features

• (Chart) Apache EChart’s Sunburst Chart is available in Preset.

Fixes and enhancements

• (Database) The allow_dml field is included when a database is exported and is used when the database is imported.
• (Database) A new configuration,  DATASET_IMPORT_ALLOWED_DATA_URLS, is available, allowing admins to define a list of regular expressions to allow URLs to import data.
• (Dataset) Expression and description are passed to duplicated datasets to preserve calculated columns.
• (Dataset) We clarified the error message for dataset import.
• (SQL Lab) We clarified database error messages for Databricks.
• (Dashboard) We updated Select to correctly handle disabled options on “Select All.”
• (Dashboard) The time range filter now loses focus after closing its modal, removing the graying-out effect on charts that are not in scope.
• (Chart Builder) You can now edit and save the title of a custom metric.
• (Chart Builder) You can save a new metric when the UX_BETA feature flag is turned on.
• (Chart Builder) We enhanced the filter logic to prevent the removal of the last temporal filter from a chart.
• (Chart) The dashboard owners are correctly removed from the chart owners after deleting the charts from the dashboard where they were inserted.
• (Chart) Tables now correctly handle emojis and accents.
• (Alerts & Reports) We updated the width of the reports to display them properly ²
• (Alerts & Reports) Reports are generated on https.
• (Other) We fixed the visual regression with the floating action button (FAB) dropdown menus.

To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.

¹: This feature is available on the Enterprise subscription only.
²: This feature is available on the Professional and Enterprise subscriptions only.

February 6, 2023

New features

• (User Permissions) The new workspace role, “Secondary Contributor,” allows users to have full workspace contributor access (e.g., dataset creation/editing) subject to data restrictions as defined by the data access role. Learn more about the workspace roles.
  

February 1, 2023

New features

• Secure database connections via SSH Tunneling¹: Set up a secure connection between your database and Preset via API or SQL Alchemy forms. SSH tunneling provides an additional layer of security by directing data traffic to flow inside an encrypted SSH connection, acting as an alternative to native data encryption.
  

Enhancements and fixes

• (Alerts & Reports) The dropdown menu in the ”Alerts & Reports” modal correctly updates when a user switches from one alert option to another².
• (Alerts & Reports) We made improvements to logging the Slack API errors³.
• (Database) We fixed the error related to the Databricks connector driver by removing whitespace in the http_path.
• (Database) You can now estimate the cost of running queries on the BigQuery database.
• (Dashboard, SQL Lab) You can now "Select All" items in the dashboard filter dropdown menus.
• (Dashboard) A loading animation (loading spinner) displays while a dashboard is being saved.
• (SQL Lab) We fixed the JSON SQL Lab displaying an incorrect value due to Javascript's max integer on 64-bit IDs.
• (Charts) The "View in SQL Lab" option in the “Chart Builder” view of the “Charts” page is only available to users with the necessary permissions to access the SQL Lab.
• (Charts) The "View in SQL Lab" and “Edit Dataset” options in the “Chart Builder” view of the “Charts” page are displayed only when a dataset is linked to a chart, and we clarified the error message.

To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.

^{1, 2, 3}: These features are available on Professional and Enterprise subscriptions only.

January 11, 2023

New features

• (Chart) We added support for user-specific chart thumbnails, limiting the risk of sensitive data leakage in an environment where user impersonation is used.

Enhancements & fixes

• (Database) You can now import Snowflake’s encrypted_extra field for authentication.
• (Database) We made enhancements to load the Google Sheets connection form.
• (SQL Lab) We display a clearer syntax error message for BigQuery databases.
• (Dashboard) You can now edit the filter selection directly from the filter cards in both vertical and horizontal filter bars through the Edit (pencil) icon.
• (Dashboard) We added a tooltip to the horizontal filter bar, allowing you to quickly see which filters are applied to the dashboard.
• (Dashboard) We made enhancements to the styling of the horizontal filter bar.
• (Dashboard) The “More Filters” dropdown in the horizontal filter bar shows additional filters in the correct order as specified by a user.
• (Dashboard) The “Owners” column on the Dashboard page shows the correct owners after editing.
• (Dashboard): We fixed the position and unintended closing of the time range filter’s popover screen in the horizontal filter bar.
• (Dashboard) We disabled button resizing in the horizontal filter bar to fixate the button position.
• (Chart) You can now save a Handlebar chart without CSS text. A tooltip containing the required HTML sanitization will also be displayed when using CSS.
• (Chart) We removed the “Dashboards added to” column on the Charts page to resolve occasional page crashing issues.
• (Chart) We fixed the overflowing of the header and footer in the table charts.
• (Other) We added an option to log errors on the server side to help debug issues.
• (Other) We removed timestamp precision for custom python datetime conversion to enable time range filters for Trino query engine.

To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.

Introducing Horizontal Filter Bar (December 20, 2022)

We’re excited to launch the horizontal filter bar, giving you more options to configure your Preset dashboards. If you're embedding Preset dashboards into a custom application, placing dashboard filters above the charts improves the usability and readability of the visualizations.

The horizontal filter bar functions just like the vertical filter bar (see Dashboard Filtering to learn more). To select the placement of the filter bar, click on the gear icon in the “Filters” column of the “Dashboard” tab.

December 14, 2022

Highlights

• Self-serve exploration with Drill to Detail: Explore the granular data that makes up specific values directly from the chart. As you filter down the dashboard for the data that meets your specific criteria, Drill to Detail will display the underlying data that corresponds to the applied filters in a tabular format. Follow Drilling to Chart Details for more details.

New features

• (Database) You can now connect your Preset instance to Databricks by providing the required credentials in a dynamic form, making it easier for non-technical users to connect to the database. Connection through SQLAlechemy URI is still supported.

Enhancements & fixes

• (Dataset) We resolved an infinite rendering loop issue that occurred occasionally on the Chart Builder page during dataset editing.
• (Database) We organized the CSV file upload form with an expandable and collapsable grouping feature, making it easier to navigate.
• (Database) An error message for database connection is properly displayed in the basic tab of the “Connect a Database” modal.
• (Database) We clarified the “con” field by renaming it to “database” in the Columnar and Excel upload forms.
• (SQL Lab) Autocomplete options are properly displayed when you write queries in a new tab.
• (Dashboard) Chart content resizes properly when you switch between tabs.
• (Charts) The “Columns” section is added back to the side menu of the Preset Chart Builder when you open it on saved datasets.
• (Charts) Tooltips stay displayed correctly when they overflow out of the chart box.
• (Charts) A pointer no longer hovers over a tooltip.
• (Chart Builder) We fixed an error that occurred when you updated a chart by changing the underlying dataset and the visualization type on the Chart Builder page.
• (Alerts & reports) We fixed text alignment in the CRON Schedule selector¹.
• (API) Permission API allows INVITEE to be added as a grantee for a Data Access Role (DAR) permission².

To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.

¹ The feature is only available for the Preset Professional and Enterprise plan users.
² The feature is only available for the Preset Enterprise plan users.

December 5, 2022

Enhancements & fixes

• (Database) We updated the form for uploading CSV files to improve user navigation.
• (Database) A schema is auto-selected when choosing a database with a single schema.
• (Database) ClickHouse's official driver, ClickHouse Connect, is supported.
• (Dashboard) Users are now prompted to confirm overwrite when updating values in the "CSS Editor" and "Configuring Filter Scopes" to prevent unintended changes.
• (Dashboard API) We added the "Chart ID" field to the result payload of the /api/v1/dashboard/<pk>/charts endpoint in accordance with the OpenAPI Specification¹.
• (Chart) Chart files with empty chart_slug can now be exported.
• (SQL Lab) We added the template parameters in KVStore to make it easier to share queries.

To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.

¹: This feature is available on the Preset Enterprise plan.

November 16, 2022

Highlights

• Enhanced experience for Preset Professional trials¹: We improved the product experience to help new teams plan their free trial of the Preset Professional plan. Features exclusive to the Professional plan (i.e., not included in the Starter plan) are marked with the "sparkle" icon, making it easier to prioritize which features to test during the 14-day trial period.
  

Enhancements and fixes

• (Database) We allow only JSON files to be selected in the file dialog for selecting credentials for BigQuery.
• (Database) We improved the BigQuery database connection error message related to the service account's roles and permissions.
• (Database) We added pre-load validation to the schema used for databases CRUD to support old payload with encrypted_extra.
• (Dataset) We improved data validation on Datasource save and sanitized the default endpoint on datasets.
• (Dataset) We fixed an issue for which the default temporal column wasn't picked up correctly.
• (Chart Builder) We improved the metadata language and tooltip placement.
• (Chart Builder) A modal for saving charts displays an error message instead of failing silently.
• (Dashboard) The background color of a chart when you "download (it) as image" matches Superset's theme color.
• (Dashboard) Auto refresh intervals are no longer hard-coded and can be properly configured.
• (Native filters) The panels stay expanded in native filters when you switch between the filters.
• (SQL Lab) We fixed the erroneous message about missing parameters that appeared when saving a dataset created from charts powered by SQL queries.
• (Alerts and reports) We bumped Gecko and Mozilla in the Dockerfile to resolve an error that users saw with alerts and reports.
• (Other) We deprecated approve and request_access endpoints.
• (Other) We added logging for SPA route navigation with React router to fix an issue with LoggerMiddleware sending malformed log payloads.
• (Other) We put in control to check that imported files are ZIP files.

To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.

¹ The feature is available for new users using Preset during the trial period.

November 4, 2022

Highlights

We built additional logic in the navigation to create and find your datasets, charts, and dashboards easier.

• Creating datasets from the menu button: You will now see the option to create a dataset upon clicking "+" menu in the navigation bar after connecting a database.
  

• Cross-referencing between charts and dashboards: You can now confidently edit charts and datasets while understanding which dashboards or charts may be impacted. You will see which charts are on which dashboards and what datasets power which charts, improving the ability to understand how changing individual objects impacts other aspects of the workspace.
  

New features

• Added layer of security with content security policy check: The new Content Security Policy (CSP) check verifies if a policy is defined or not to help detect and mitigate Cross-Site Scripting (XSS) and data injection attacks. If the policy is not defined, you will see a warning message. For deployments that manage CSP with other software, this check can be disabled using the CONTENT_SECURITY_POLICY_WARNING configuration.

Enhancements and fixes

• (SQL Lab) We updated the timer to use a monospace font so its width doesn't change.
• (SQL Lab) We fixed a bug where "Ctrl+X" would not properly stop querying in the "SQL Lab."
• (Chart Builder) We show a warning about breaking a chart with custom SQL when a user changes the database.
• (Chart Builder) Commas have been enabled in number format to make reading easier.
• (Chart Builder) We ensured that unknown URL parameters would be preserved in the URL.
• (Chart Builder) We fixed a regression in which the URL parameters were not persisted to the form data.
• (Chart Builder) We resolved the issue where the date range in "Chart Builder" resulted in runtime errors.
• (Plugin) We fixed build and runtime errors associated with the Handlebars viz plugin.
• (Other) We disabled HTML rendering in the error pop-up notification by default.
• (Other) We enhanced color consistency across charts.
• (Other) We added CRLF line separators for Windows.

To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.