- 04 Dec 2023
- 20 Minutes to read
- Print
- DarkLight
Changelog
- Updated on 04 Dec 2023
- 20 Minutes to read
- Print
- DarkLight
December 4, 2023
New features
- (Homepage) Viewers and Dashboard Viewers can now land on the Preset Homepage after visiting a Preset workspace.
- (Database) When deleting a workspace, databases created from file uploads in the workspace (e.g., CSV file uploads) are automatically deleted.
Enhancements and fixes
- (Database) We've updated the
version
field in the database configuration modal to be a string field instead of the previous number field. - (SQL Lab) We now display
Duration
as a separate column in the "Query History" view instead of as a tooltip on theTime
column. - (Chart Builder) We fixed an issue in which pasting a value into a filter did not retain the value, causing an error when running the chart.
- (Dashboard) We have improved the rendering performance of dashboard filters by reducing over-rendering.
- (Tags) We made UI updates to enhance the experience of using tags in the Preset Homepage, including pinning tags in the order they were selected in the "Manage Tabs" modal.
- (Tags) We've fixed an issue where the tag creation form is sticky (retains the previously created tag’s name) by clearing it by default.
- (Tags) We fixed the issue so that a user without appropriate permission cannot see the "Create Chart" button or the "Pin Tags" option in the "Manage Tabs" modal.
- (RLS) We renamed the "tables" field to "datasets."
November 15, 2023
Highlight
Instantly access a collection of charts and dashboards from the Preset Homepage using tags. You can now browse your organization’s tags or pin them as quick-access tabs on your homepage, allowing you to easily access or discover content relevant to your work.
New features
- (SQL Lab) The "Format SQL" feature is now available to help you format SQL code in the query editor. You can also access the feature through a shortcut, ctrl + shift + f.
- (Chart) We have made enhancements to the waterfall chart type, including support for a non-temporal x-axis, series color selection, currency and time formatting, and the ability to use mixed data types in the x-axis.
- (Homepage) Users with Viewer or Dashboard Viewer access now land on the Welcome Homepage upon logging into Preset, facilitating easier navigation and onboarding.
Enhancements and fixes
- (Dashboard) We’ve fixed an issue with the dashboard filter where the "Apply Filters" button remained disabled after clearing a single-value existing filter.
- (Chart) We fixed an issue with a time grain filter applied to a dataset that uses Jinja templating.
- (Chart) We fixed an issue where you couldn't save a mixed chart with a chart-level time filter when dashboard filters were in use.
- (Dataset) You can now view the full SQL query in the "Edit dataset" modal, regardless of its length, making it easier to validate the query.
- (RBAC) We fixed an issue where a user unintentionally became a chart owner when they added a chart to a dashboard they didn't want.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
November 1, 2023
Highlights
Organize and discover relevant charts and dashboards with content tags
Tags are now available to help you organize your charts, dashboards, and saved queries in Preset and facilitate easier discovery, access, and collaboration among your team. Learn how to use tags.
New features
(SQL Lab) We have added a "keyboard shortcuts" helper in SQL Lab to make it easier to look up and use shortcuts.
(Chart Builder) Database and schema names are now visible when choosing a dataset for chart creation.
(Chart) You can now customize or disable tooltips for the funnel chart type.
Enhancements and fixes
- (Dashboard) Tooltips for filters in the horizontal bar are no longer truncated.
- (SQL Lab) You can now open SQL Lab in a new browser tab when selecting "View in SQL Lab" from the charts.
- (Import) We have ensured that old data source IDs are not referenced when importing charts into your Preset workspaces.
- (Navigation Bar) We fixed an issue where the previous tab on the top navigation bar was highlighted when you landed on the "database" page.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
October 18, 2023
New features
- (Chart) We’re introducing two new chart types in Preset: Waterfall charts and Bubble charts.
Enhancements and fixes
- (Chart) We now support the ContourLayer in deck.gl charts.
- (Chart) We fixed the country borders in the India Country Map.
- (Dashboard) We fixed issues where dates were not being formatted correctly in dashboard filters.
- (Dashboard) All values in the column are displayed in the datetime (dttm) format in the dashboard filters when
python_date_format
is set for a column. - (Dashboard) Dashboard filters now render more quickly.
- (Dataset) We improved the error messages for saving datasets for easier troubleshooting.
- (SQL Lab) The “Save” button no longer flickers.
- (SQL Lab) We fixed the issue with icon alignment in the database/schema side menu bar.
- (Alerts and Reports) We removed the duplicate items that appeared in the “Alerts and Reports” modal.1
- (Row level security) In the “Add Rule” modal, we fixed the alignment issue with the “Add” and “Cancel” buttons.
1: Available on the Enterprise and Professional plans only.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
October 4, 2023
New features
- (Audit logs) The following events are now available in the audit logs1
- Downloading dashboards
- Downloading charts from dashboards and from Chart Builder
- Downloading saved queries
Enhancements and fixes
- (Dashboard) When an existing RLS is updated, the changes are now reflected in dashboard filter configurations immediately.
- (Chart) We fixed an issue with using custom SQL columns as the x-axis.
- (Chart Builder) We fixed the issue in which you could not remove a chart filter on a chart placed on a dashboard with an active dashboard time range filter.
- (SQL Lab) The command
is_select
works withUNION
. - (Alerts and reports) We fixed the issue in which scheduled alert/report email notifications were intermittently missed or sent in duplicates.
- (Reports) Reports are now correctly executed.
- (Other) You can now export charts to Excel files with columns containing date/time with time zones.
1: Available on the Enterprise plan only.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
September 20, 2023
New features
- (SQL Lab) You can now see the SQL queries in the results panel.
- (Dashboard) Viewer and Dashboard Viewer workspace roles can now generate dashboard perma links to easily share dashboards with others.
Enhancements and fixes
- (Database) When uploading CSV files, columns with international timestamps (i.e., days before months) are correctly imported.
- (Database) The placeholder values for the "Account" and "Database" fields on the Snowflake dynamic form display correctly.
- (Chart Builder) Clearing the currency format in the "Customize Tab" no longer affects the currency format displayed in the chart.
- (Chart Builder) The currency format is now applied to a table chart immediately without the need to select the number format.
- (Chart Builder) In Treemaps, number and currency formatting no longer apply to numeric chart labels.
- (Chart Builder) We fixed the issue in which all available filter options (rather than only those selected) apply to a chart when filters are set to "Dynamically Search All Filter Values."
- (Chart) Dashboard time range filters now work correctly on charts that are initially updated with dashboard time range filters but are subsequently overwritten with new chart configurations.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
September 6, 2023
New features
- (Database) You can now create a new database using the
superset://
SQLAlchemy URI, allowing you to create a custom database by joining data from multiple databases or moving data from one database to another. Reach out to the Preset team to start using the feature (which is currently behind the feature flag).
*Note: Read a few tips to avoid running expensive queries.
Enhancements and fixes
- (Database) We now support the Spectrum-enabled Amazon Redshift driver,
redshift+spectrum
. - (Datasets) We introduced a checkbox in the “Edit Dataset” modal which requires you to opt into normalizing new dataset column names (i.e., allow column names to be case insensitive format).
- (Dashboard) We fixed an issue where dashboard filter names were overflowing from the hover modals.
- (Dashboard) Custom URL parameters are now preserved when toggling between normal and full-screen sizes.
- (Dashboard) We have ensured that access to a dataset is granted within the confines of dashboard filters when a user is granted access to the dashboard via dashboard RBAC.
- (Embedded dashboards) We have ensured that embedded dashboard viewers can properly see all visualizations in the dashboard (i.e., Role-based access is granted within the confines of the embedded dashboard).
- (Embedded dashboards) Dashboards now load correctly when the URL contains a trailing “/” (slash).
- (Chart) Conditional formatting properly works on cells with a value of 0.
- (Chart) You can set the default format to the Heatmap using the Time Format control.
- (Chart) The Calendar Heatmap accounts for timezone differences and correctly displays data for the specified time/dates.
- (SQL Lab) We fixed an issue so that the cursor (the scroll position) remains fixed after running a query.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
August 23, 2023
Highlights
Troubleshoot issues and ensure regulatory compliance with audit logs1. Admins can now track the team’s activities in Preset, such as workspace access, chart and dashboard updates (create/view/edit/delete), permission changes, and data download, from the past 30 days. Learn more.
Enhancements and fixes
- (Database) You can now connect MotherDuck, a cloud version of DuckDB, through SQL Alchemy.
- (Chart) We fixed an issue in which tooltips did not disappear on the Heatmap chart.
- (Chart) We fixed a bug in which the dataset names were being displayed as links inside the tooltips of dashboard chart cards.
- (Chart) You can now add column and row subtotals in pivot tables.
- (Chart) We added 5 Central Asia countries (Kazakhstan, Kyrgyzstan, Tajikistan, Turkmenistan, and Uzbekistan) to the country map chart.
- (Chart Builder) We added currency controls in the control panels of the Chart Builder.
- (Chart Builder) We clarified the various types of "save" actions for charts in the Chart Builder.
- (SQL Lab) When writing long queries, the keyword tooltip now displays complete keyword names without collapsing them.
- (Docs) We added README for database engine specifications which describe all their features and functionality. We also added a new command to test database engine specs, SQLAlchemy dialects, and database connections.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
August 9, 2023
New features
- (Chart) Your legacy chart types are automatically updated to the new chart types when you import them into Preset from Superset (and vice versa).
Enhancements and fixes
- (Chart) In deck.gl's Path and Polygon charts, we updated the default unit of line width from meters to pixels to make the line more visible in large-scale maps.
- (Chart) In tooltips, hovered data series are no longer highlighted.
- (Dataset) You can now update the
dataset_uuid
in exported YAML files to point charts to a different dataset, and reimport the file to overwrite your chart. - (Dataset) We fixed the
schema
to be passed to a virtual dataset created from SQL Lab. - (Dataset) You can now create datasets from tables that contain slashes in their table names.
- (Dataset) We improved the performance of the dataset creation flow for database schemas containing more than 10,000 tables.
- (Dashboard) We resized the width of the modal for setting up dashboard filters.
- (Dashboard) We fixed an error that occurs when you delete dashboard filters that are in use.
- (SQL Lab) We fixed the margin style of the horizontal scroll bar for the query results.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
July 26, 2023
New features
- (SQL Lab) We introduced a new shortcut (
ctrl + shift + enter
) to automatically detect the range of the current query, select, and run it more easily.
Enhancements and fixes
- (Database) We fixed the issue where SSH tunnels could not be created through the UI modal. 1
- (Database) We fixed an issue where users were unable to edit databases that have SSH tunnels configured.1
- (Dataset) When importing datasets, the
extra
key for datasets functions even if it has an empty string (extra: ""
). - (Dashboard) Dashboard filter validation and the “Clear All” feature only apply to filters in scope.
- (Dashboard) We made improvements to avoid repeated colors in the same charts on dashboards that had shared labels across tabs.
- (Chart) The time grain filters on dashboards are now correctly applied to the pivot tables.
- (Chart) You can no longer add a chart to a dashboard not owned by the chart owner.
- (Report) We brought back the ability to edit an existing report without specifying the custom width.2
1: Available on the Enterprise plan only.
2: Available on the Enterprise and Professional plans only.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
July 12, 2023
Highlight
- Preset charts now support multiple currency formats. You can configure the currency format for saved dataset metrics and display it in selected charts1. Supported currencies include
"USD", "EUR", "GBP", "INR", "MXN", "JPY", "CNY"
, and more.
New features
- (Alerts & reports) You can now customize the screenshot width of alerts and reports.
Enhancements and fixes
- (Database) We added connection support for the DuckDB database.
- (Database) Column names have been denormalized as applicable, allowing dashboard filters to function correctly on datasets created from the Oracle database.
- (Dashboard) We resolved the issue of infinite loading errors that occurred when the horizontal dashboard filter contained the first filter value out of scope.
- (Dashboard) We fixed the issue where the dashboard time filter sometimes did not work properly on a chart newly added to a dashboard.
- (Dashboard) We’ve improved the dynamic numeric search in dashboard filters to return more accurate results.
- (Chart) We fixed an issue where a new dataset saved from SQL Lab displayed an error in Chart Builder.
- (Chart) The totals in stacked charts now calculate correctly when interacting with the legend.
- (Chart) Double-clicking a series value in stacked charts exclusively selects the series.
- (Chart) Big numbers are now rendered properly in all charts.
- (Chart) We fixed the error that occurred when searching for a dashboard in the chart list view.
- (Chart Builder) Metric names are no longer truncated in tooltips in Chart Builder.
- (SQL Lab) We have re-enabled sharing of the saved queries.
1 Current formatting is supported in the following charts today: Area Chart, Line Chart, Big Number Chart, Funnel Chart, Gauge Chart, Heatmap, Line Chart, Mixed Chart, Pie Chart, Pivot Tables, Smooth Line Chart, Stepped Line Chart, Sunburst Chart, Tables, Treemap, WorldMap.
June 28, 2023
Highlights
We have deprecated three chart types: the (old) Pivot Table, Dual-Line Chart, and the (old) Treemap. The existing charts created with the old chart types in your workspaces have been automatically migrated to the new chart types, the (new) Pivot Table, Mixed Chart, and the (new) Treemap. See here to learn more about the differences between the new and old chart types.
We migrated the following api/v1 endpoints in preparation for Superset 3.0 upgrade.
Old Path | New Path |
---|---|
/superset/slice_json/ | /api/v1/chart/int:id/data/ |
/superset/annotation_json/ | /api/v1/chart/int:id/data/ |
/superset/recent_activity/ | /api/v1/log/recent_activity/<user_id>/ |
/superset/fave_dashboards_by_username/ | /api/v1/dashboard/favorite_status/ |
/superset/fave_dashboards/ | /api/v1/dashboard/favorite_status/ |
/superset/created_dashboards/ | /api/v1/dashboard/ |
/superset/user_slices/ | /api/v1/chart |
/superset/created_slices/ | /api/v1/chart |
/superset/fave_slices/ | /api/v1/chart |
/superset/favstar/ | /api/v1/dashboard, api/v1/chart//favorites/ |
/superset/get_or_create_table/ | /api/v1/dataset/get_or_create/ |
/superset/sqllab_viz/ | /api/v1/dataset/ |
/superset/stop_query/ | /api/v1/query/stop |
/superset/queries/ | /api/v1/query/updated_since |
/superset/search_queries/ | /api/v1/query/ |
/superset/copy_dash/int:dashboard_id/ | /api/v1/dashboard/<dash_id>/copy/ |
/superset/save_dash/int:dashboard_id/ | - |
/superset/add_slices/int:dashboard_id/ | /api/v1/chart/ |
/superset/testconn | /api/v1/database/test_connection/ |
/superset/validate_sql_json/ | /api/v1/database/validate_sql/ |
/superset/schemas_access_for_file_upload | /api/v1/database/{pk}/schemas_access_for_file_upload/ |
/superset/extra_table_metadata/ | /api/v1/database/int:pk/table_extra/<table_name>/<schema_name> |
/superset/available_domains/ | /api/v1/available_domains/ |
/superset/estimate_query_cost/ | /api/v1/sqllab/estimate/ |
/superset/results/ | /api/v1/sqllab/results/ |
/superset/sql_json/ | /api/v1/sqllab/execute/ |
/superset/csv/ | /api/v1/sqllab/export/ |
/superset/tables/int:db_id/ | /api/v1/database/int:pk/tables/ |
/superset/filter/<datasource_type>/int:datasource_id/ | /api/v1/datasource/<datasource_type>/ |
/superset/datasources/ | /api/v1/dataset/ |
Enhancements and fixes
- (Chart) Table charts now support hyperlinks.
- (Chart) You can manually adjust the lower bound of the y-axis to extend the logarithmic limit beyond 10 when a set of series contains zero values.
- (Chart) In deck.gl’s scatterplot chart, the size of the circles now correctly adjusts after changing the radius values.
- (Chart) In deck.gl’s Geojson chart, you can now select the line width unit in meters or pixels to properly display the line path
- (Chart) The Time Shift feature in Chart Builder works when joining queries with different time granularity.
- (Dataset) We added a tooltip to clarify
metric_name
in the “Edit Dataset” modal. - (Database) We fixed the issue with the expansion/collapsing dropdown in the “Advanced” tab of the database modal.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
June 26, 2023
Product Announcement
Preset now integrates with dbt Cloud via its user interface1, enabling data teams to define data models (databases, datasets, and metrics) as version-controlled assets within dbt Cloud and to synchronize them with Preset Cloud. While we have been supporting integration with dbt Cloud and dbt Core through Preset CLI for some time, the new feature allows you to seamlessly sync the two tools via UI. Learn more here.
1 The feature is available for teams on Preset’s Enterprise plan.
June 1, 2023
New features
- (Dashboard) You can now control which visualizations in the dashboards are impacted by cross-filters using “Cross-filtering scoping.”
- (Chart) Deck.gl’s heatmap chart is now available in Preset.
Enhancements and fixes
- (Dashboard) You can now export individual charts on dashboards in Excel (.xlsx) file format.
- (Chart Builder) You can now see more details about the data types in a tooltip when you hover over the “#” and “abc” icons of the type column options in the “metadata” panel.
- (Chart) The same colors are no longer repeated for distinct labels if the color palette has more colors than what the chart requires.
- (Chart) When updating a chart with a new dataset and a different chart type, the filters will populate using columns from the new dataset.
- (SQL Lab) We fixed the issue where typing and using “Enter” to select the table broke the “SQL Lab” screen layout.
- (Alert) The current user will pre-populate as the default owner in the “Alert” modal during new alert initialization1.
1 This feature is available for teams on Preset's Professional and Enterprise plans.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
May 24, 2023
Product Announcement
Find more insights with Drill By!
Drill By, the latest drilling functionality in Preset, makes data analysis easier by allowing the slicing and dicing of data directly in the visualizations. Unlike the traditional "drill-down", you can filter and group by any dimension in your dataset in any order.
May 18, 2023
Enhancements and fixes
- (Database) We added a new field called "Column Data Types" to the "CSV Upload" form, allowing users to specify data types for columns in the uploaded file. This addresses the issue where text columns in the Redshift database were converted to varchar columns with character limits.
- (Dashboard) Search input in the filters is retained while you select values containing the same search input, making it easier to select multiple values.
- (Dashboard) We have fixed the issue that caused dashboard filters to stop working properly on some legacy charts (e.g., Heatmap and Bar Chart (legacy)) after we introduced the non-temporal x-axis.
- (Chart) Big Number charts support conditional formatting (coloring), allowing you to easily see how the numbers compare to goals, forecasts, or expectations in real-time.
- (Chart) You can now define the secondary y-axis bounds in Mixed Charts.
- (Chart) The Calendar Heatmap chart is available again in the visualization library.
- (Chart) Time grain now works properly for Pivot v2 charts.
- (Chart) Results from editing a Table chart used in a dashboard are now saved and loaded properly in the Chart Builder view.
- (Chart) The scrollbar no longer flashes on and off when resizing the browser size in the Chart Builder view.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
May 3, 2023
New features
- (Dashboard) You can now assign specific colors to the series values based on the color scheme index, making it possible to maintain the assigned colors while changing color schemes.
- (Chart Builder) You can now export your chart data to Excel. The feature is available for most charts excluding “legacy” charts.
- (Admin) Usage metrics are available for all teams on the Enterprise plan by default, allowing Workspace Admins to track stats such as the volumes of active users and chart and dashboard assets created1.
Enhancements and fixes
- (SQL Lab) We added a loading spinner that appears in the the "Save or Overwrite Dataset" modal when overwriting existing datasets.
- (SQL Lab) When copying results to the clipboard from the query history, the header row is now included.
- (Chart Builder) The "Custom SQL" popover for ad-hoc columns is now resizable, making it easier to write SQL expressions.
- (Chart) We fixed an issue with the context menu crashing when there were no dimensions selected in some ECharts.
- (Chart) Bar totals now sort correctly when applying multi-series sorting on the categorical x-axis. You can also sort charts by total bar height, even when charts contain multiple metrics.
1 The feature is available to Preset teams on the Enterprise plan only.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
April 20, 2023
Highlight
Dive into specific series values using the Legend Selector: The "Legend Selector" feature in Preset charts allows you to zoom into specific series values by selecting or inverting the selection of the legend items. This provides greater flexibility and is particularly useful when you want to compare a few series values among many.
New features
- (Chart) You can disable data caching on specific charts by implementing a chart "cache timeout" value of
-1
.
Enhancements and fixes
- (Dashboard) You will now see only the charts you own or have created in the dashboard editor, making it easier to add them to your dashboard. You can still access charts created by others by unclicking the “Show only my charts” checkbox.
- (Dashboard) We fixed the false error message about loading databases that appeared when charts were imported via a dashboard import.
- (Dashboard) Dashboard time range filters correctly apply to charts and are saved without deleting chart-level time filters.
- (Dashboard) Column names are human-readable and easier to read in dashboard cross-filters.
- (Chart) You can now define up to 1,000 annotations in Chart Builder, giving teams more flexibility in how they add context to a chart.
- (Chart) We improved the Table chart’s configuration panel in Chart Builder to make time filter selection more intuitive and consistent with other chart types.
- (Chart) Time range filters are applied to Preset’s legacy charts only if there are no additional time filters applied in order to prevent the application of double time filters.
- (Chart) The labels for ad-hoc columns (custom columns / metrics defined in SQL Lab) render correctly in the tooltips of the plugin heatmap charts.
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
April 13, 2023
Highlights
Use Preset with CSV files without database connection: Sometimes waiting for your data team to connect a database to Preset can get in the way of using Preset. Now, anyone can create charts and dashboards immediately upon account sign up by uploading CSV files (without connecting to a database first). Learn more here.
Customize your charts with more sorting options: Additional sorting features are now available in Chart Builder to help you visualize your data in the way you want. The new sorting configuration options include:
- The categorical x-axis can now be sorted in Bar Charts, Line Charts, Area Charts, Scatter Plots, Smooth Line Plots, and Stepped Line Charts.
- Series values can be sorted by "minimum", "maximum", "total", and "average".
- The sorting order can be switched between ascending and descending orders.
New features
- (Charts) You can now create a stream graph using Preset’s area and bar charts.
- (Charts) The Country Map chart supports a new country, Sri Lanka.
Enhancements and fixes
- (Database) The drop-down menu in the “Connect a database” modal properly shows database options when using the latest ClickHouse driver.
- (SQL Lab) You can use the
dataset()
macro in Preset, which allows for querying physical and virtual datasets in SQL Lab. The macro is useful if you have defined computed columns and metrics on your datasets and want to reuse the definition in ad-hoc SQL Lab queries. - (SQL Lab) We fixed the issue where the "schedule query" option showed up in SQL Lab even when the option was not configured.
- (SQL Lab) We fixed the error message that occurred for undefined parameters that were not used in the query.
- (Dashboard) The time and numerical dashboard filters now support cascading, allowing the filter options to be dependent on the values selected in other filters.
- (Other) When using Preset through Safari browsers, Safari will no longer autocomplete irrelevant items by searching names from your address book where the label contains the word "name".
To learn more about the features and enhancements included in this release, visit Apache Superset Pull Request.
Earlier Releases
See Preset's product announcement blog for key updates.