Redash v6 beta is now available! 🙌 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 CHANGELOG.

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 🙏

• Before doing an upgrade, please make sure you have a backup.
• Because of the Celery upgrade, before upgrading to this version please make sure to clear out your Celery queues.
• 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 .

Happy querying 🤓

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.

V5.0.1:

• Upgraded Celery version to 3.1.26 to make upgrade to Celery 4 easier.
• Added support for JWT authentication (for services like Cloudflare Access or Google IAP).

• 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.

Final release for V5. Most of the changes were already in the beta release of V5, but this includes several fixes along with UI improvements.

🙏 Thanks to @arikfr, @jezdez, @kravets-levko, @alison985, @kocsmy, @YOSSI-A, @tdsmith, @nasmithan, @jrbenny35, @sjakthol, @ariarijp and @combineads who contributed to this release.

• 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.

This is a security release for V4 users. You can find full details on what it fixes and its importance in the release blog post.

• 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.

This is the first beta of the V5 release (and hopefully the last one). This version includes a lot of exciting new additions along with bug fixes and other changes.

Some notable changes:

• Extensive work on parameters UI:
  • New Date Range parameter type.
  • UI for creating new parameters.
  • Support for Now/Today as default value of date/time parameter.
• Tagging and favorites ⭐️ support for queries and dashboards.
• Users list page was improved (search, additional information) and you can now disable users.
• Query editor improvements: additional keyboard shortcuts and support for searching in query text.
• Visualizations improvements: option to select colors of pie chart sectors, X Axis type auto detect and option to format values, labels and tooltips.
• Data Sources:
  • Support for Yandex Metrika and AppMetrika.
  • BigQuery: location property support and schema will load all tables now.
  • Elasticsearch: stop sending source_content_type parameter which wasn't supported in older versions.
• Started migrating the frontend codebase to React.

And much more!

🙏 Thanks to @kravets-levko, @arikfr, @ariarijp, @alison985, @kyoshidajp, @kocsmy, @denisov-vlad, @deecay, @yuua, @emtwo, @Pablohn26, @sieben, @atharvai, @matsumo, @tdawber, @innovia, @gabrieldutra, @coreyhuinker, @maxv, @sjakthol, @mtrbean and @washort who contributed to this release!

• 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.

Docker image and updated tarball will be ready soon.

Happy querying 🤓

v4.0.1 is a recommended upgrade that includes several bug fixes, small changes and improved dashboard refresh UX.

As always huge thanks to everyone who contributed to this release. 🙏

• 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.

Happy querying 🤓

V4 is finally out. 🎁 We used the feedback from RC1 and our hosted customers to fix some performance issues in the RC1 release. @kravets-levko worked hard so you will get smooth performance with the new dashboards layout editor.

This release includes 35 changes, features and bug fixes from @alon710, @arikfr, @deecay, @fmy, @idalin, @kravets-levko, @tnetennba3, @toru and @valentin2105. 🙏 🙏 🙏 This includes new Choropleth map visualization, Mattermost support and more.

• 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.

Docker image and updated tarball will be ready soon.

Happy querying 🤓

This is a follow up release to the v4.0.0-beta and hopefully the last release before the full release of v4.0.0. It includes fixes to some bugs introduced in the beta version (like public dashboards or embeds not rendering), but also new features like the funnel visualization and more (CHANGELOG).

This is a beta release, to upgrade to this release from an existing deployment run sudo bin/upgrade --channel beta. If you use a Docker based deployment you do not need to use this script, but rather update your image reference.

As always this wouldn't be possible without the help of all the people who contributed code in this release: @kravets-levko, @arikfr, @kocsmy, @jezdez, @benmanns, @ariarijp, @tonyjiangh and @jubel-han. 🙏🙏🙏

• 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.

This is a very exciting release 🤩 that was a long time in the making 👷. It includes a fully updated user interface that should provide a much nicer experience, along with many new features and improvements:

• Table visualization customization along with new column types (image, JSON & URL).
• Dashboard layout editing (full control over widget height/width).
• Updated chart visualization (mostly bug fixes) and settings for the cohort visualization.
• BigQuery and Athena queries now show the amount of data scanned, so you know how much the query costs you. On top of that we have new data sources (MapD & CockroachDB) and improvements to other data sources (MongoDB, Salesforce, Redshift, Oracle and Elasticsearch).

This is only the tip of the iceberg, see the full list of changes in the CHANGELOG.

This is a beta release, to upgrade to this release from an existing deployment run sudo bin/upgrade --channel beta. If you use a Docker based deployment the Docker tag is 4.0.0-beta.b3690.

As always this wouldn't be possible without the help of all the people who contributed code in this release: @arikfr, @kravets-levko, @kyoshidajp, @ariarijp, @sjakthol, @kocsmy, @jezdez, @deecay, @kakakakakku, @bamboo-yujiro, @tonyjiangh, @washort, @jasonsmithj, @shinji19, @arjan, @gramakri, @doddjc21, @cdessanti, @yershalom, @miketheman, @crooy, @alexdrans, @javier-sanz, @negibouze, @mayconbordin and @rgjodekerken. 🙏🙏🙏

• 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.