All Versions
30
Latest Version
Avg Release Cycle
80 days
Latest Release
59 days ago

Changelog History
Page 1

  • v10.0.0 Changes

    October 01, 2021

    πŸ”€ A few changes were merged during the V10 beta period.

    • πŸ†• New Data Source: CSV/Excel Files
    • πŸ›  Fix: Edit Source button disappeared for users without CanEdit permissions
    • πŸ— We pinned our docker base image to Python3.7-slim-buster to avoid build issues
    • πŸ›  Fix: dashboard list pagination didn't work
  • v10.0.0-beta Changes

    June 16, 2021

    πŸš€ Just over a year since our last release, the V10 beta is ready. Since we never made a non-beta release of V9, we expect many users will upgrade directly from V8 -> V10. This will bring a lot of exciting features. Please check out the V9 beta release notes below to learn more.

    πŸ›  This V10 beta incorporates fixes for the feedback we received on the V9 beta along with a few long-requested features (horizontal bar charts!) and other changes to improve UX and reliability.

    πŸš€ This release was made possible by contributions from 35+ people (the Github API didn't let us pull handles this time around): Alex Kovar, Alexander Rusanov, Arik Fraimovich, Ben Amor, Christopher Grant, Đặng Minh DΕ©ng, Daniel Lang, deecay, Elad Ossadon, Gabriel Dutra, iwakiriK, Jannis Leidel, Jerry, Jesse Whitehouse, Jiajie Zhong, Jim Sparkman, Jonathan Hult, Josh Bohde, Justin Talbot, koooge, Lei Ni, Levko Kravets, Lingkai Kong, max-voronov, Mike Nason, Nolan Nichols, Omer Lachish, Patrick Yang, peterlee, Rafael Wendel, Sebastian Tramp, simonschneider-db, Tim Gates, Tobias Macey, Vipul Mathur, and Vladislav Denisov

    Our special thanks to Sohail Ahmed for reporting a vulnerability in our "forgot password" page (#5425)

    ⬆️ Upgrading

    πŸš€ (This section is duplicated from the previous release - since many users will upgrade directly from V8 -> V10)

    ⬆️ Typically, if you are running your own instance of Redash and wish to upgrade, you would simply modify the Docker tag in your docker-compose.yml file. Since RQ has replaced Celery in this version, there are a couple extra modifications that need to be done in your docker-compose.yml:

    ⏱ 1. Under services/scheduler/environment, omit QUEUES and WORKERS_COUNT (and omit environment altogether if it is empty). πŸ‘· 2. Under services, add a new service for general RQ jobs:

    worker:
      <<: *redash-service
      command: worker
      environment:
        QUEUES: "periodic emails default"
        WORKERS_COUNT: 1
    

    πŸ— Following that, force a recreation of your containers with docker-compose up --force-recreate --build and you should be good to go.

    UX

    • Redash now uses a vertical navbar
    • Dashboard list now includes β€œMy Dashboards” filter
    • Dashboard parameters can now be re-ordered
    • Queries can now be executed with Shift + Enter on all platforms.
    • βž• Added New Dashboard/Query/Alert buttons to corresponding list pages
    • Dashboard text widgets now prompt to confirm before closing the text editor
    • A plus sign is now shown between tags used for search
    • 🚚 On the queries list view β€œMy Queries” has moved above β€œArchived”
    • πŸ‘Œ Improved behavior for filtering by tags in list views
    • 🌲 When a user’s session expires for inactivity, they are prompted to log-in with a pop-up so they don’t lose their place in the app
    • Numerous accessibility changes towards the a11y standard
    • Hide the β€œCreate” menu button if current user doesn’t have permission to any data sources

    Visualizations

    • πŸ”‹ Feature: Added support for horizontal box plots
    • πŸ”‹ Feature: Added support for horizontal bar charts
    • πŸ”‹ Feature: Added β€œReverse” option for Chart visualization legend
    • πŸ”‹ Feature: Added option to align Chart Y-axes at zero
    • πŸ”‹ Feature: The table visualization header is now fixed when scrolling
    • πŸ”‹ Feature: Added USA map to choropleth visualization
    • πŸ›  Fix: Selected filters were reset when switching visualizations
    • πŸ›  Fix: Stacked bar chart showed the wrong Y-axis range in some cases
    • πŸ›  Fix: Bar chart with second y axis overlapped data series
    • πŸ›  Fix: Y-axis autoscale failed when min or max was set
    • πŸ›  Fix: Custom JS visualization was broken because of a typo
    • πŸ›  Fix: Too large visualization caused filters block to collapse
    • πŸ›  Fix: Sankey visualization looked inconsistent if the data source returned VARCHAR instead of numeric types

    ⚑️ Structural Updates

    • Redash now prevents CSRF attacks
    • Migration to TypeScript
    • ⬆️ Upgrade to Antd version 4 ### Data Sources
    • πŸ†• New Data Sources: SPARQL Endpoint, Eccenca Corporate Memory, TrinoDB
    • Databricks
      • Custom Schema Browser that allows switching between databases
      • Option added to truncate large results
      • Support for multiple-statement queries
      • Schema browser can now use eventlet instead of RQ
    • MongoDB:
      • Moved Username and Password out of the connection string so that password can be stored secretly
    • Oracle:
      • Fix: Annotated queries always failed. Annotation is now disabled
    • Postgres/CockroachDB:
      • SSL certfile/keyfile fields are now handled as secret
    • Python:
      • Feature: Custom built-ins are now supported
      • Fix: Query runner was not compatible with Python 3
    • Snowflake:
      • Data source now accepts a custom host address (for use with proxies)
    • TreasureData:
      • API key field is now handled as secret
    • Yandex:
      • OAuth token field is now handled as secret

    Alerts

    • πŸ”‹ Feature: Added ability to mute alerts without deleting them
    • πŸ”„ Change: Non-email alert destination details are now obfuscated to avoid leaking sensitive information (webhook URLs, tokens etc.)
    • πŸ›  Fix: numerical comparisons failed if value from query was a string

    Parameters

    • βž• Added β€œLast 12 months” option for dynamic date ranges

    πŸ› Bug Fixes

    • πŸ›  Fix: Private addresses were not allowed even when enforcing was disabled
    • πŸ›  Fix: Python query runner wasn’t updated for Python 3
    • πŸ›  Fix: Sorting queries by schedule returned the wrong order
    • πŸ›  Fix: Counter visualization was enormous in some cases
    • πŸ›  Fix: Dashboard URL will now change when the dashboard title changes
    • πŸ›  Fix: URL parameters were removed when forking a query
    • πŸ›  Fix: Create link on data sources page was broken
    • πŸ›  Fix: Queries could be reassigned to read-only data sources
    • πŸ›  Fix: Multi-select dropdown was very slow if there were 1k+ options
    • πŸ›  Fix: Search Input couldn’t be focused or updated while editing a dashboard
    • πŸ›  Fix: The CLI command for β€œstatus” did not work
    • πŸ›  Fix: The dashboard list screen displayed too few items under certain pagination configurations

    Other

    • βž• Added an environment variable to disable public sharing links for queries and dashboards
    • Alert destinations are now encrypted at the database
    • The base query runner now has stubs to implement result truncating for other data sources
    • πŸ”§ Static SAML configuration and assertion encryption are now supported
    • βž• Adds new component for adding extra actions to the query and dashboard pages
    • Non-admins with at least view_only permission on a dashboard can now make GET requests to the data source resource
    • βž• Added a BLOCKED_DOMAINS setting to prevent sign-ups from emails at specific domains
    • βž• Added a rate limit to the β€œforgot password” page
    • πŸ‘· RQ workers will now shutdown gracefully for known error codes
    • ⏱ Scheduled execution failure counter now resets following a successful ad hoc execution
    • Redash now deletes locks for cancelled queries
    • ⬆️ Upgraded Ace Editor from v6 to v9
    • βž• Added a periodic job to remove ghost locks
    • βœ‚ Removed content width limit on all pages
    • Introduce a React component
  • v9.0.0-beta Changes

    June 11, 2020

    πŸš€ This release was long time in the making and has several major changes:

    • ⚑️ Our backend code was updated to support Python 3 and we no longer support Python 2. If you're using our Docker images, this should be a transparent change for you.
    • ⚑️ We replaced Celery with RQ for background jobs processing. This will require some setup updates -- see instructions below.
    • 🚚 The frontend code is now 100% React and we removed all the Angular dependencies.

    πŸš€ This release was made possible by contributions from over 50 people: @ari-e, @ariarijp, @arihantsurana, @arikfr, @atharvai, @cemremengu, @chulucninh09, @citrin, @daniellangnet, @DavidHernandez, @deecay, @dmudro, @erans, @erels, @ezkl, @gabrieldutra, @gstaykov, @ialeinikov, @ikenji, @Jakdaw, @jezdez, @juanvasquezreyes, @koooge, @kravets-levko, @kykrueger, @leibowitz, @leosunmo, @lihan, @loganprice, @mickeey2525, @mnoorenberghe, @monicagangwar, @NicolasLM, @p-yang, @Ralnoc, @ranbena, @randyzwitch, @rauchy, @rxin, @saravananselvamohan, @satyamkrishna, @shinsuke-nara, @stefan-mees, @stevebuckingham, @susodapop, @taminif, @thewarpaint, @tsuyoshizawa, @uncletimmy3, @wengkham.

    ⬆️ Upgrading

    ⬆️ Typically, if you are running your own instance of Redash and wish to upgrade, you would simply modify the Docker tag in your docker-compose.yml file. Since RQ has replaced Celery in this version, there are a couple extra modifications that need to be done in your docker-compose.yml:

    ⏱ 1. Under services/scheduler/environment, omit QUEUES and WORKERS_COUNT (and omit environment altogether if it is empty). πŸ‘· 2. Under services, add a new service for general RQ jobs:

    worker:
      <<: *redash-service
      command: worker
      environment:
        QUEUES: "periodic emails default"
        WORKERS_COUNT: 1
    

    πŸ— Following that, force a recreation of your containers with docker-compose up --force-recreate --build and you should be good to go.

    UX

    • Redesigned Query Results page:
      • Completely new layout is easier to read for non-technical Redash users.
      • Empty query results are clearly displayed. User is now prompted to edit or execute the query.
    • Mobile Experience Improvements:
      • UI element spacing has been redesigned for clarity
      • Admin pages now honor max-width. Tables scroll independent of the top menu.
      • Large legends no longer shrink the visualization on small screens.
      • Fix: it was sometimes impossible to scroll pages with dashboards because the visualizations captured every touch event.
      • Fix: Visualizations on small screens would not always show horizontal scroll bars.
    • Dashboards can now be un-archived using the API.
    • 🐎 Dashboard UI performance was improved.
    • List pages were changed to show a user's name instead of avatar.
    • Search-enabled tables now show a prompt for which columns will be searched.
    • In the visualization editor, the settings pane now scrolls independent of the visualization preview.
    • Tokens in the schema viewer now sort alphabetically.
    • πŸ”— Links to settings panes that require Admin privileges are now hidden from non-Admins.
    • The Admin page now remembers which tab you were viewing after a page reload.

    Visualizations

    • πŸ”‹ Feature: Allow bubble size control with either coefficient or sizemode.
    • πŸ”‹ Feature: Table visualization now treats Unix timestamps in query results as timestamps.
    • πŸ”‹ Feature: It's now possible to provide a description to each Table column, appearing in UI as a tooltip.
    • πŸ”‹ Feature: Added tooltip and popover templating to the map with markers visualization.
    • πŸ”‹ Feature: Added an organization setting to hide the Plotly mode bar on all visualizations.
    • πŸ”‹ Feature: Cohort visualization now has appearance settings.
    • πŸ”‹ Feature: Add option to explicitly set Chart legend position.
    • πŸ”„ Change: Deprecated visualizations are now hidden.
    • πŸ”„ Change: Table settings editor now extends vertically instead of horizontally.
    • πŸ”„ Change: The maximum table pagination is now 500.
    • πŸ”„ Change: Pie chart labels maintain contrast against lighter slices.
    • πŸ›  Fix: Chart series switched places when picking Y axis.
    • πŸ›  Fix: Third column was not selectable for Bubble and Heatmap charts.
    • πŸ›  Fix: On the counter visualizations, the β€œcount rows” option showed an empty string instead of 0.
    • πŸ›  Fix: Table visualization with column named "children" rendered +/- buttons.
    • πŸ›  Fix: Sankey visualization now correctly occupies all available area even with fewer stages.
    • πŸ›  Fix: Pie chart ignores series labels.

    Data Sources

    • πŸ†• New Data Sources: Amazon Cloudwatch, Amazon CloudWatch Logs Insights, Azure Kusto, Exasol.
    • Athena:
      • Added the option to specify a base cost in settings, displaying a price for each query when executed.
    • BigQuery:
      • Fix: large jobs continued running after the user clicked β€œCancel” query execution.
    • Cassandra:
      • Updated driver to 3.21.0 which dramatically reduces Docker build times.
      • SSL options are now available.
    • Clickhouse:
      • You can now choose whether to verify the SSL certificate.
    • Databricks:
      • Databricks now use an ODBC-based connector.
      • Fix: Date column was coerced to DateTime in the front-end.
    • Druid:
      • Added username and password authentication option.
    • Microsoft SQL Server
      • Added support for ODBC connections via pyodbc. There are now two MSSQL data source types. One using TDS. The other is using ODBC.
    • MongoDB:
      • Added support for running queries on secondary in replicaset mode.
      • Fix: Connection test always succeeded.
    • Oracle:
      • Fix: Connection would fail if username or password contained special characters.
      • Fix: Comparisons would fail if scale was None.
    • RDS:
      • Updated rds-combined-ca-bundle.pem to the latest CA.
    • Redshift:
      • Added the ability to use IAM Roles and Users.
      • Fix: Redshift was unable to have its schema refreshed.
    • Rockset:
      • Fix: Allow Redash to load collections in all workspaces.
    • Snowflake:
      • You can now refresh the snowflake schema without waking the cluster.
      • Added support for all of Snowflake’s datetime types. Otherwise certain timestamps would only appear as strings in the front-end.
    • TreasureData:
      • Fix: API calls would fail when setting a non-default region.

    Alerts

    • πŸ”‹ Feature: Added ability to mute alerts without deleting them.
    • πŸ›  Fix: numerical comparisons failed if value from query was a string.

    Parameters

    • βž• Added Last x Days options for date range parameters.
    • πŸ›  Fix: Parameters added in empty queries were always added as text parameters

    πŸ› Bug Fixes

    • πŸ›  Fix: Alembic migration schema was preventing v4 users from upgrading. In v5 we started encrypting data source credentials in the database.
    • πŸ›  Fix: System admin dashboard would not show correct database size if non-default name was used.
    • πŸ›  Fix: refresh_queries job would break if any query had a bad schedule object.
    • πŸ›  Fix: Orgs with LDAP enabled couldn’t disable password login.
    • πŸ›  Fix: SSL mode was sometimes sent as an empty string to the database instead of omitted entirely.
    • πŸ›  Fix: When creating new Map visualization with clustering disabled, map would crash on save.
    • πŸ›  Fix: It was possible on the New Query page to click β€œSave” multiple times, causing multiple new query records to be created.
    • πŸ›  Fix: Visualization render errors on a dashboard would crash the entire page.
    • πŸ›  Fix: A scheduled execution failure would modify the query’s β€œupdated_at” timestamp.
    • πŸ›  Fix: Parameter UI would wrap awkwardly during some drag operations.
    • πŸ›  Fix: In dashboard edit mode, users couldn’t modify widgets.
    • πŸ›  Fix: Frontend error when parsing a NaN float.

    Other

    • βž• Added TSV as a download format (in addition to CSV and Excel).
    • βž• Added maildev settings (helps with automated settings).
    • Refine permissions usage in Redash to allow for guest users
    • The query results API now explicitly handles 404 errors.
    • Forked queries now retain the tags of the original query.
    • We now allow setting custom Sentry environments.
    • πŸ‘• Started using Black linter for our Python source code
    • βž• Added CLI command to re-encrypt data source details with new secret key.
    • Favorites list is now loaded on menu click instead of on page load.
    • Administrators can now allow connections to private IP addresses.
  • v8.0.0 Changes

    October 27, 2019

    🐳 Docker Tag: redash/redash:8.0.0.b32245.

    πŸš€ See CHANGELOG for the full release notes.


    • ⬆️ Before doing an upgrade, please make sure you have a backup.
    • ⬆️ If you have any issues, please refer to the troubleshooting section in the upgrade guide.
    • ⬆️ If the upgrade guide doesn't help, you can ask for help on the forum.
  • v8.0.0-beta.2 Changes

    September 16, 2019

    πŸš€ This is an update to the previous beta release, which includes:

    • βž• Add options for users to share anonymous usage information with us (see docs for details).
    • Visualizations:
      • Allow the user to decide how to handle null values in charts.
    • ⬆️ Upgrade Sentry-SDK to latest version.
    • πŸ‘‰ Make horizontal table scroll visible in dashboard widgets without scrolling.
    • Data Sources:
      • Add support for Azure Data Explorer (Kusto).
      • MySQL: fix connections without SSL configuration failing.
      • Amazon Redshift: option to set query group for adhoc/scheduled queries.
      • Hive: make error message more friendly.
      • Qubole: add support to run Quantum queries.
    • Display data source icon in query editor.
    • πŸ›  Fix: allow users with view only acces to use the queries in Query Results
    • ⚑️ Dashboard: when updating parameters refersh only widgets that use those parameters.

    πŸš€ This release had contributions from 12 people: @arikfr, @cclauss, @gabrieldutra, @justinclift, @kravets-levko, @ranbena, @rauchy, @sandeepV2, @shinsuke-nara, @spacentropy, @sphenlee, @swfz.

  • v8.0.0-beta Changes

    August 18, 2019

    πŸš€ After months of being heads down with hard work, it's finally time to wrap up the V8 release 🀩 This release includes many long awaited improvements to parameters, UX improvements, further React migration and other changes, fixes and improvements.

    While this version is already running on the hosted platform to make sure it's stable, we're excited to put this in the hands of our Open Source users.

    πŸš€ Starting from this release we will no longer build a tarball distribution of the codebase and recommend everyone to switch over to using our Docker images. We're planning on dropping Python 2 support towards its EOL this year and switching over to the Docker image will make this transition much simpler.

    πŸš€ This release was made possible by contributions from over 40 people: @aidarbek, @AntonZarutsky, @ariarijp, @arikfr, @combineads, @deecay, @fmy, @gabrieldutra, @guwenqing, @guyco33, @ialeinikov, @Jakdaw, @jezdez, @justinclift, @k-tomoyasu, @katty0324, @koooge, @kravets-levko, @ktmud, @KumanoTanaka, @kyoshidajp, @nason, @oldPadavan, @openjck, @osule, @otsaloma, @ranbena, @rauchy, @rueian, @sekiyama58, @shinsuke-nara, @taminif, @The-Alchemist, @vv-p, @washort, @wudi-ayuan, @ygrishaev, @yoavbls, @yoshiken, @yusukegoto and the support of over 500 organizations who subscribed to our hosted version and by that sponsor the team's work.

    Parameters

    • πŸ’» Parameter UI improvements:
      • Support for multi-select in dropdown (and query dropdown) parameters.
      • Support for dynamic values in date and date-range parameters.
      • Search dropdown parameter values.
      • New UX for applying parameter changes in queries and dashboards.
    • πŸ‘ Allow using Safe Parameters in visualization embeds and public dashboards. Safe Parameters are any parameter type except for the a text parameter (dropdowns are safe).

    Data Sources

    • πŸ†• New Data Sources: Couchbase, Phoenix and Dgraph.
    • πŸ†• New JSON data source (and deprecated old URL data source).
    • ⚑️ Snowflake: update connector to latest version.
    • PostgreSQL: show only accessible tables in schema.
    • BigQuery:
      • Correctly handle NaN values.
      • Treat repeated fields as rrays.
      • [BigQuery] Fix: in some queries there is no mode field
    • DynamoDB:
      • Support for Unicode in queries.
      • Safe loading of schema.
    • πŸ‘ Rockset: better handling of query errors.
    • Google Sheets:
      • Support for Team Drive.
      • Friendlier error message in case of an API error and more reliable test connection.
    • MySQL:
      • Support for calling Stored Procedures and better handling of query cancellation.
      • Switch to using mysqlclient (a maintained fork of Python-MySQL).
    • πŸ‘ MongoDB: Support serializing Decimal128 values.
    • πŸ‘ Presto: support for passwords in connection settings.
    • Amazon Athena: allow to specify custom work group.
    • Query Results: querying a column with a dictionary or array fails
    • Clickhouse: make sure we don't show password in error messages.
    • 0️⃣ Enable Cassandra support by default.

    Visualizations

    • Charts:
      • Fix: legend overlapping chart on small screens.
      • Fix: Pie chart not rendering when series doesn't exist in options.
      • Pie Chart: add option to set direction of slices.
    • πŸ‘ WordCloud: rewritten to support new options (provide frequency in query, limits), scale when resizing, handle long words and more.
    • πŸ‘ Pivot Table: support hiding totals.
    • Counters: apply formatting to target value.
    • Maps:
      • Ability to customize marker icon and color.
      • Customization options for Choropleth maps.
    • πŸ†• New Visualization: Details View.

    UX

    • Replace blank screen with a loading indicator when the application is doing its first load.
    • πŸ‘ Multiple improvements to dashboards editing: auto-save, grid markings and better refresh indicator.
    • Admin can now edit user's groups from the user page.
    • βž• Add keyboard shortcut (Ctrl/Cmd+Shift+F) to trigger query formatting.

    API

    • Query Result API response minimized to only required fields when called with a non user API key.
    • Prefer API key over cookies in authentication.
    • πŸ‘‰ User can now regenerate Query API Key.

    Other Changes

    • πŸ”’ Sends CSP headers to prevent various kinds of security attacks via the browser. Might break unusual usages and embeds of Redash.
    • πŸ†• New Failed Scheduled Queries email report (can be enabled from organization settings screen).
    • πŸ—„ Deprecated HipChat Alert Destination.
    • βž• Add options to hide different parts of a Visualization embed UI (parameters, title, link to query).
    • πŸ‘Œ Support multi-byte search for query names and descriptions (needs to be enabled in Organization settings screen).
    • CSV query results download: correctly serialize booleans and date values.
    • Dashboard filters now collect values from all widgets with the same filter.
    • πŸ‘Œ Support for custom message and description in alert notifications (currently disabled behind a feature flag until we improve the alert UX).

    πŸ› Bug Fixes

    • πŸ›  Fix: adding widget to dashboard from a query page is broken.
    • πŸ›  Fix: default time format option was wrong.
    • πŸ›  Fix: when too many errors of a scheduled queries occur it causes an OverflowError.
    • πŸ›  Fix: when forking a query maintain the same visualizations order.
  • v7.0.0 Changes

    March 25, 2019

    πŸš€ We're trying a new format for the CHANGELOG in this release. Focusing on the bigger changes, but for whoever interested, you can see all the changes here.

    πŸ‘€ Besides all the features, bug fixes and improvements listed below we managed to convert a large portion of Redash's frontend code from Angular.js to React. You can see status in #3071.

    πŸš€ This release was made possible with the help of 34 contributors. πŸ™‡β€β™‚οΈ

    Data Sources

    • All data source options are now encrypted in the database. By default the encryption uses the REDASH_COOKIE_SECRET value (redash.settings.COOKIE_SECRET), but you can specify a different value by setting the REDASH_SECRET_KEY environment variable value. Note that you need to set this before doing the upgrade.
    • πŸ†• New Data Sources: Uptycs and Apache Drill.
    • 0️⃣ Snowplow: is now enabled by default & supports region setting.
    • πŸ‘ Elasticsearch: add support for Amazon Elasticsearch IAM authentication (with IAM profile or key/secret pair).
    • πŸ‘ PostgreSQL: add support for serializing range values.
    • 🚚 Redshift: remove duplicate column information for late-binding views.
    • Athena: load all databases (using pagination).
    • BigQuery: correctly handle temp tables with no schema field.
    • πŸ‘ Jira (JQL): support for fetching all records with pagination.
    • πŸ‘ Prometheus: fix schema loading and add support for query range.

    In-app Help

    You can now open the Knowledge Base inside the application. We also added a few "help triggers" in the app, that will open the Knowledge Base in context of what you're currently doing.

    Parameters

    • Dashboard Parameters: We improved the flow of adding queries with parameters to dashboards and now give you full control over how parameters are mapped. You no longer have to make sure all parameters have the same name or use theΒ GlobalΒ checkbox. We also added new options, like keeping the parameter local to the widget or setting a static value. Read more in our Knowledge Base β†’
    • We added server side validation of parameter values for all parameter types, except for parameters of text type. All validated parameter types are considered safe. When a query is using safe parameters (or no parameters at all), View Only users can refresh it.
    • Refreshing safe queries is done using the new results API endpoint, which takes only a query ID (and optionally parameter values) and does not need the query text.

    Query Editor Improvements

    • βœ… Run only the highlighted query text: hit Execute after highlighting a portion of your query and only the selected portion will be sent to the database. This is useful for testing sub-SELECT statements and CTE's.
    • πŸ‘Œ Improved auto complete:Β add a dot . after a table name in the query editor and auto complete will only suggest columns on that table.
    • πŸ”§ Autosave parameter configuration changes.
    • πŸ‘ YAML syntax support (for data sources like Yandex Metrica).

    πŸ‘Œ Improved Query Scheduler

    ⏱ The Query Scheduler got a face lift and some new options: you can pick a day for a weekly schedule to run on and also set an end date after which the query will no longer execute on schedule.

    Data Sources

    πŸ›  We added Apache Drill, Uptycs and a new JSON data source. Also fixed a few bugs in Athena's query runner and others.

    πŸ‘‰ User Management

    The users page got revamped with a new look and feel and few new features:

    • An indication when a user was last active.
    • πŸ‘‰ Show if an invited user hasn't finished the setup process yet (Pending Invitations section).
    • You can now generate a new API key for users, if there's a concern it was compromised.

    Admin

    • πŸ†• New Celery queues status screens, replacing the old Queries Status and better reflecting the status of running queries.
    • πŸ”§ Make the queue name for schema refresh job configurable. The default used to be hard coded schemas, which is not available on all setups. Now it's celery.
    • 0️⃣ The gevent library is installed by default, and you can now setup gunicorn to use gevent based workers.
    • πŸ†• New Docker entrypoint command to do a health check for a worker process.
    • πŸ‘ Flask-Admin is no longer setup or supported.

    Other Changes

    • πŸ†• New Alert destination: Google Hangouts Chat.
    • When downloading results from the results API it will set a user friendly filename for the downloaded file.
    • Archived Queries section added to the queries list.

    πŸ› Bug Fixes

    • πŸ›  Fixed: fork query does not fork tables but instead adds default table.
    • πŸ›  Fixed: when deleting a visualization, any widget using it was left empty on the dashboard.
    • πŸ›  Fixed: issues with Query Editor resizing on new versions of Chrome.
    • πŸ›  Fixed: issues with exporting dictionaries to Excel.
    • πŸ›  Fixed: Cohort visualization gets stuck when passing string values.
    • πŸ›  Fixed: use series name for Pie chart label.
    • πŸ‘· Make sure Flask app created in Celery's worker process (could cause some query runners to get stuck while running queries).
  • v6.0.0 Changes

    December 17, 2018

    ⬆️ Before upgrading to v6.0.0 make sure to clear out the Celery queue (unless upgrade from v6.0.0-beta).

    πŸš€ This is the final release of v6.0.0. See v6.0.0-beta for details of what's new in v6.0.0. This release includes only fixes from regressions introduces in the beta version.

    πŸš€ This release had contributions from 5 people: @rauchy, @denisov-vlad, @arikfr, @ariarijp, and @gabrieldutra. Thank you, everyone πŸ™


    • ⬆️ Before doing an upgrade, please make sure you have a backup.
    • ⬆️ If you have any issues, please refer to the troubleshooting section in the upgrade guide.
    • ⬆️ If the upgrade guide doesn't help, you can ask for help on the forum.
  • v6.0.0-beta Changes

    December 04, 2018

    πŸš€ This release was 2 months in the making and it is full with good stuff!

    • We have 5 new data sources: Databricks, IBM DB2, Kylin, Druid and Rockset. βŒ—
    • πŸ“ˆ There are fixes and improvements to 11 existing data sources (MySQL, Redshift, Postgres, MongoDB, Google BigQuery, Vertica, TreasureData, Presto, ClickHouse, Google Sheets and Google Analytics).
    • The Query Results data source can now load cached results, just use the cached_query_ prefix instead of query_.
    • ⚑️ On the visualizations front we added a Heatmap visualization and did updated the table and counter visualizations.
    • πŸ›  Alerts got some fixes and a new destination: PagerDuty.
    • πŸ‘€ If the live autocomplete in the code editor annoys you, you can disable it now (although we're working to make it better, see #3092).
    • Fast queries will now load faster. πŸƒβ€β™‚οΈ
    • We improved the layout of visualizations and content on smaller screen sizes. πŸ“±
    • For those of you who like sharing, you can now enable the ability to share ownership of queries and dashboards and let others to edit them. Check the Settings page to enable this feature.

    There were also important changes to the code and infrastructure:

    • 🚚 More components moved to React.
    • We switched to Webpack 4 with the help of @dmonego.
    • ⬆️ We upgraded to Celery 4 with the help of @emtwo, @jezdez, @mashrikt and @atharvai.
    • βœ… We started moving towards Python 3 for our backend. The first step was to make sure our code pass basic sanity tests with Flake 8, which was implemented by @cclauss.
    • βœ… We improved our testing on the frontend by adding setup for Jest tests and E2E testing using Cypress (@gabrieldutra).
    • πŸš€ Each pull request now gets a deploy preview using Netlify to easily test frontend changes.

    This is just a summary, you're welcome to review the full list below. ⬇

    πŸš€ This release had contributions from 38 people: @arikfr, @kravets-levko, @jezdez, @kyoshidajp, @kocsmy, @alison985, @gabrieldutra, @washort, @GitSumito, @emtwo, @rauchy, @alexanderlz, @denisov-vlad, @ariarijp, @yoavbls, @zhujunsan, @sjakthol, @koooge, @SakuradaJun, @dmonego, @Udomomo, @cclauss, @combineads, @zaimy, @Trigl, @ralphilius, @jodevsa, @deecay, @igorcanadi, @pashaxp, @hoangphuoc25, @toph, @burnash, @wankdanker, @Yossi-a, @Rovel, @kadrach, and @nicof38. Thank you, everyone πŸ™

    βž• Added

    • #2747, #3143 Add a new Databricks query runner. @alison985, @jezdez, @arikfr
    • #2767 Add ability to add viz to dashboard from query edit page. @alison985, @jezdez
    • #2780 Add a query autocomplete toggle. @alison985, @jezdez, @arikfr
    • #2768 Add authentication via JWT providers. @SakuradaJun
    • πŸ’» #2790 Add the ability to sort favorited queries, paginate the dashboard list and improve UI inconsistencies. @jezdez
    • πŸ’» #2681 Add ability to search table column names in schema browser. @alison985
    • #2855 Add option to query cached results. @yoavbls
    • #2740 Add ability for extensions to add periodic tasks. @emtwo
    • πŸ‘ #2924 Google Spreadsheets: Add support for opening by URL. @alexanderlz
    • #2903 Add PagerDuty as an Alert Destination. @alexanderlz
    • πŸ‘ #2824 Add support for expanding dashboard visualizations. @sjakthol
    • #2900 Add ability to specify a counter label. @ralphilius
    • #2565 Add frontend extension capabilities. @emtwo
    • πŸ“¦ #2848 Add IBM Db2 as a data source using the ibm-db Python package. @nicof38
    • #2959 Add option to auto reload widget data in shared dashboards. @arikfr
    • #2993 Add page size settings. @kyoshidajp
    • #2080 New Heatmap chart visualization with Plotly. @deecay
    • #2991 Show users in CLI group list. @GitSumito
    • #2342 New SQLPARSE_FORMAT_OPTIONS setting to configure query formatter. @ariarijp
    • βœ… #3031 Add some tests for Query Results. @ariarijp
    • #2936 Add Kylin data source. @Trigl
    • #3047 Add Druid data source. @rauchy
    • #3077 New user interface for the feature flag of the share edit permissions feature. @arikfr
    • #3007 Add permissions to the result of "manage.py groups list" command. @Udomomo
    • #3088 Add get_current_user() fuction for the Python query runner. @kyoshidajp
    • #3114 Add event tracking to autocomplete toggle. @arikfr
    • #3068 Add Rockset query runner. @igorcanadi, @arikfr
    • #3105 Display frontend version. @rauchy

    πŸ”„ Changed

    • #2636 Rewrite query editor with React. @washort, @arikfr
    • #2637 Convert edit-in-place component to React. @washort, @arikfr
    • #2766 Suitable events are now being recorded server side instead of in the frontend. @alison985, @jezdez
    • #2796 Change placement (right/bottom) of chart legend depending on chart width. @kravets-levko
    • #2833 Uses server side sort order for tag list and show count of tagged items. @jezdez
    • πŸ‘ #2318 Support authentication for the URL data source. @jezdez
    • #2884 Rename Yandex Metrika to Metrica. @jezdez
    • #2909 MySQL: hide sys tables. @arikfr
    • #2817 Consistently use simplejson for loading and dumping JSON. @jezdez
    • #2872 Use Plotly's function to clean y-values (x may be category or date/time). @kravets-levko
    • #2938 Auto focus tag input. @kyoshidajp
    • #2927 Design refinements for queries pages. @kocsmy
    • #2950 Show activity status in CLI user list. @GitSumito
    • #2968 Presto data source: setting protocol (http/https), safe loading of error messages. @arikfr
    • #2967 Show groups in CLI user list. @GitSumito
    • ⚑️ #2603 MongoDB: Update requirements to support srv. @arikfr
    • #2961 MongoDB: Skip system collections when loading schema. @arikfr
    • ⏱ #2960 Add timeout to various HTTP requests. @arikfr
    • ⚑️ #2983 Databricks: New logo, updated name and enabled by default. @arikfr
    • 0️⃣ #2982 Table visualization: change default size to 25 and add more size options. @arikfr
    • πŸ”§ #2866 Redshift: Hide tables the configured user cannot access. @sjakthol
    • #3058 Mustache: don't html-escape query parameters values. @kravets-levko
    • #3079 Always use basic autocomplete, as well as the live autocomplete. @arikfr
    • πŸ‘ #3084 Support tel://, sms://, mailto:// links in query results. @zhujunsan
    • πŸ‘ #3083 Clickhouse: Add WITH TOTALS option support. @denisov-vlad
    • #3063 Allow setting colors for bubble charts. @toph
    • 0️⃣ #3085 BigQuery: Switch to Standard SQL as the default. @kyoshidajp
    • #3094 Tags autocomplete: Show note when creating a new label. @kravets-levko
    • #2984 Autocomplete toggle improvements. @arikfr
    • #3089 Open new tab when forking a query. @kyoshidajp
    • πŸ‘ #3126 MongoDB: add support for sorting columns. @arikfr
    • #3128 Improve backoff algorithm of query results polling to speed it up. @arikfr
    • ⚑️ #3125 Vertica: update driver & add support for connection timeout. @arikfr
    • πŸ‘ #3124 Support unicode in Postgres/Redshift schema. @arikfr
    • #3138 Migrate all tags components to React. @kravets-levko
    • πŸ‘ #3139 Better manage permissions modal. @kocsmy
    • #3149 Improve tag link colors and fix group tags on Users page. @kocsmy
    • ⚑️ #3146 Update, replace and fix new alert destination logos so it fits better. @kocsmy
    • #3147 Add and improve recent db logos that didn't fit in size properly. @kocsmy
    • #3148 Fix label positioning on no found screen. @kocsmy
    • πŸ‘ #3156 json_dumps: add support for serializing buffer objects. @arikfr

    πŸ›  Fixed

    • #2849 Fix invalid reference to alert.to_dict() in webhook. @wankdanker
    • #2840 Improve counter visualization text scaling. @kravets-levko
    • #2854 Widget titles are no longer rendered wrong on public dashboards. @kravets-levko
    • 🚚 #2318 Removed redundant exception handling in data sources since that's handled in the query backend. @jezdez
    • πŸ— #2886 Fix Javascript build that broke because registerAll tried to run EditInPlace component. @arikfr
    • #2911 Don’t show β€œAdd to dashboard” in dropdown to unsaved queries. @jezdez
    • #2916 Fix export query results output file name. @gabrieldutra
    • #2917 Fix output file name not changing after rename query. @gabrieldutra
    • #2868 Address edge case when retrieving Glue schemas for Athena data source. @kadrach
    • #2929 Fix: date value in a filter is duplicated. @combineads
    • ⚑️ #2875 Unbreak charts with long legend break in horizontal mode. Update plotly.js. @kravets-levko
    • #2937 Fix event recording in admin API backend. @kyoshidajp
    • πŸ›  #2953 Minor fixes for the Clickhouse data source. @denisov-vlad
    • #2941 Bring back fix to Box plot hover. @arikfr
    • #2957 Apply missing CSS classes to EditInPlace component. @arikfr
    • #2897 Show "Add description" only after saving the query. @arikfr
    • #2922 Query page layout improvements for small screens. @kravets-levko
    • 🚚 #2956 Clickhouse: move timeout to params. @denisov-vlad
    • #2964 Fix no tags shown when having empty set. @gabrieldutra
    • #2757 Use full text search ranking when searching in list views. @jezdez
    • #2969 Query Results data source: improved errors, quoted column names. @arikfr
    • #2906 Preventing open redirection in loging process. @kyoshidajp
    • #2867 TreasureData: Deduplicate column names. @zaimy
    • #2994 Fix scheme of various URLs from http to https. @kyoshidajp
    • ⚠ #2992 Fix an invalid prop type warning in new version notifier. @kyoshidajp
    • #3022 Fix Toolbox covering part of a chart. @kravets-levko
    • πŸ“± #2998 Fix charts losing responsive features after refreshing the dashboard. @kravets-levko
    • #3034 Postgres: handle NaN/Infinity values. @kravets-levko
    • #2745 Sort columns with undefined values. @Yossi-a
    • #3041 Sort CLI output of lists. @GitSumito
    • #2803, #3006 Address various tag display issues on query list page. @kocsmy, @alison985
    • #3049 Fix edit-in-place component which ignored isEditable flag and didn't work on Groups page. @kravets-levko
    • πŸ“ˆ #2965 Google Analytics: Fix crash when no results are returned. @alexanderlz
    • #3061 Fix table visualization so that the horizontal scrollbar is not be always visible. @kravets-levko
    • #3076 Add white-space padding to separators in the footer. @burnash
    • #2919 Fix URL data source to not require a URL. @arikfr
    • ⚑️ #3098 Force AngularJS to update query editor properly. @washort
    • #3100 Delete redundant regex segment in query result frontend. @zhujunsan
    • ⚑️ #2978 Prevent the query update timestamp from changing when it is linked to new query results. @rauchy
    • #3046 Fix query page header. @kravets-levko
    • #3097 Mongo: Fix collection fields retreival bug when Views are present. @jodevsa
    • #3107 Keep query text in local state for now. @washort
    • #3111 Fix mobile padding issues on Query results. @kocsmy
    • #3122 Show menu divider only if query is archived. @jezdez
    • #3120 Fix tag counts for dashboards and queries. @jezdez
    • #3141 Fix schema refresh to work on MySQL 8. @hoangphuoc25
    • #3142 Fix: editing dashboard title results in the visualizations being replaced by the loading markers. @kravets-levko

    Other

    • 🐳 #2850 The setup scripts are now based on Ubuntu 18.04 LTS and Docker. @pashaxp, @arikfr
    • βœ… #2985 Add Jest based tests to our stack. @arikfr
    • πŸ”§ #2999 Add netlify configuration. @arikfr
    • βœ… #3000 Initial Cypress based E2E test infrastructure. @gabrieldutra
    • πŸ’… #2898 Move Ant styles into a central location. @arikfr
    • πŸ— #2910 Fix webpack build error about BigMessage. @jezdez
    • #2928 Speed up builds by skipping installing requirements_all_ds.txt in CI unit tests. @arikfr
    • πŸ— #2963 Fix tarball build failure. @emtwo
    • #2996 Fix setup.sh failures when run as root. @arikfr
    • #2989 Rearrange make targets. @koooge
    • ⚑️ #3036 Update Flask-Admin to 1.5.2. @yoavbls
    • πŸ“š #2901 Fix documentation links. @kravets-levko
    • 🚚 #3073 Remove only Redash containers in clean Make task. @ariarijp
    • 🚚 #3048 Remove pytest-watch dependency to workaround an issue with watchdog. @rauchy
    • ⚑️ #2905 Update development docker-compose.yml file to use latest Redis and Postgres servers and specify working volume explictly. @Rovel
    • βœ… #3032 Makefile: Add make targets for test. @koooge
    • #2933 Switch to Webpack 4. @dmonego
    • ⚑️ #2908 Update setup files. @arikfr
    • #2946 Update snowflake_connector_python version. @arikfr
    • ⬆️ #2773 Upgrade to Celery 4.2.1. @emtwo, @jezdez
    • βœ… #2881 CircleCI: Make flake8 tests pass on Legacy Python and Python 3. @cclauss
    • 🚚 #2907 Remove unused dependencies (honcho, wsgiref). @arikfr
    • πŸ— #3039 Build docker image on master branch. @arikfr
    • #3106 Fix registerAll failures after minification. @arikfr
  • v5.0.2 Changes

    October 18, 2018

    v5.0.2:

    • πŸ›  Fix: prevent Open Redirect vulnerability.

    • ⬆️ Before doing an upgrade, please make sure you have a backup.
    • ⬆️ If you have any issues, please refer to the troubleshooting section in the upgrade guide.
    • ⬆️ If the upgrade guide doesn't help, you can ask for help on the forum.