Release notes

3.5.0

Highlights:

  • Support for Snowflake
  • Caching of results for longer running queries
  • Improved SQL query flattening

Issues resolved:

  • [D72]: Added a timeout parameter for retrieving totals (or disabling them)
  • [T415]: Cancel database queries when navigating away

3.4.2

Issues resolved:

  • [T411]: Joining with a table that has unsupported columns may not work
  • [T412]: Join conditions key columns may show invalid columns
  • [T413]: On browser reload, table columns cannot be shown again after hiding
  • Improved default arrangement of widgets

3.4.1

Highlights:

  • Joins: Scai users have now the ability to join data sets through an easy to use graphical interface. It also includes a one-click/blitz join for users that are all about saving clicks (and effort).

Issues resolved:

  • [T392]: fixed pivoting on a column that contains ; that failed with the error Cannot specify more than one query
  • [D68]: fixed issues with changing user roles and activating/de-activating users

3.4.0

Highlights:

3.3.1

Highlights:

  • New home page: Scai users are now greeted with a home page where they can find shortcuts to documentation, release notes, creating new dashboards, loading files and other features. The home page now also contains your most recent activity, e.g. data you explored or dashboards you have viewed.

3.3.0

Highlights:

Issues resolved:

  • [T394]: pivoting on columns with values that contain the underscore (_) character shows incomplete name in graph labels
  • [D67]: improved error handling for dashboard data. When Scai fails to retrieve data for some widget in a dashboard due to objective reasons (e.g. not enough values to pivot, column names changed, ec.), it will only present errors for those problematic widgets. Moreover, it will try to be resilient in retrieving the data by eliminating the faulty elements (e.g. ordering on some column that does not exist). This, in turn, allows the user to go back to the original data and fix the issues.

** 3.2.1 **

Issues resolved:

  • Fixed startup of Scai server on Amazon AWS t3 instances.

3.2.0

Highlights:

3.1.0

Highlights

  • added support for Amazon Redshift

3.0.5

Highlights:

Issues resolved:

  • [T296] - query in sql console that starts with common table expressions does not work for SQL Server
  • [T299] - add a block div when creating a new table based on existing table
  • [T287] - after deleting a record from table, the table is not refreshed in the interface
  • [T302] - adding error message MySQL 5.5 when saving views with subqueries