May 6th - Snowflake connector (beta)

This version mostly brings Snowflake integration, as well as a few improvements and bug fixes.

Snowflake Logo

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

Snowflake connector (beta)

Any Snowflake data source can now be added to your workspace and used in Notebooks: sync data source; browse Data Tree; see table Preview; write (with appropriate autocomplete), run and cancel queries.

This connector currently supports the SNOWFLAKE authenticator only i.e., you will need to provide a username and password.

Want to test it? Just ask us to join the beta!

Note: column statistics in the Documentation are missing in this beta version.

Other improvements

  • View the Result of a local table from the Documentation panel, to ease articulating several queries within a single Notebook:

Documentation panel - Overview of local table result
  • Update unfurl image to match the one of our website

  • Update connector logos

Bug fixes

  • Fix local tables opened in the Documentation panel not being remembered

  • Fix syntax coloring of local tables not being updated when selecting another data catalog

  • Fix some cases where notebook elements overlap each other when printing

  • Fix "Copy link" always copying the public URL, and leading to an error screen for private notebooks


April 29th - "Big Value" chart, column statistics, public sharing, and more.

This version brings many new features and improvements to ease your experience with notebooks, more specifically around charts, the SQL editor, and the "Documentation" panel.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

"Big Value" chart

Thanks to the new "Big Value" chart type, make what matters most stand out in your Notebooks within a nice and large visualization.

For instance, highlight specific metrics and their variations:

Big Value numbers example : 1,3M€ revenue // 53488 visitors

Column statistics

In the Documentation panel, get an overview of the data stored in any given column of your data warehouse. This includes basic statistics and, depending on its type, the Top values and Distribution.

No longer wonder if a given "string" column should be considered as an "enum" with only a few values!

Documentation panel - Overview of column in data warehouse

Share to web

The next step after writing a great analysis is to share it with your coworkers and business users. While signing up to Husprey is already quick and simple (especially if you have added your domain name in the Settings), you can now also allow anyone with the link to access a read-only version of a given Notebook, without creating any account:

Share the notebook with others

ClickHouse connector

Our ClickHouse connector is now out of the beta phase. Any ClickHouse database can hence be added to your workspace, with a full-featured Husprey experience, including:

  • Explore the data source (databases, tables, columns) in the "Data Explorer" panel;

  • Easily get a preview of any table from the "Documentation" panel;

  • Get autocomplete hints when typing a query

Integrations logo - Clickhouse logo highlighted

Redesigned autocomplete menu

The autocomplete menu has been redesigned, now showing icons and data types of the suggested columns:

Autocomplete menu : id, createdate, name, plan, props_hstore

Other improvements

  • View the SQL code of a local table from the Documentation panel, to ease articulating several queries within a single Notebook:

Documentation panel - Local table SQL code
  • Add a new "Notation" customizable property for numbers in tables and charts

Number notation customisable - Standard or compact
  • Highlight the location of a SQL error if we know it for postgres

SQL error highlighted in red
  • In the SQL editor, hit "Alt+Up" or "Alt+Down" to move the selected lines up or down

  • Improve experience for multiple personal data sources

  • Add logout suggestion and user menu when user cannot register

  • Allow editors to remove or edit an existing schedule config on a published notebook

  • Improve performance at application load by better caching assets

Bug fixes

  • Fix sync for Redshift late binding views

  • Fix number formatting for the y-axis ticks

  • Fix unhandled error when invalid refresh token

  • Fix zIndex of result actions and autocomplete menu

  • Fix infinite loader in some cases when printing a notebook

  • Fix result pagination for BigQuery in some cases

  • Fix never-executed local tables missing the corresponding hint in Data Explorer and Documentation panels

  • Fix Execution status not being properly selectable


April 15th - Span gaps option for charts, more keyboard shortcuts, and SSL certificates for postgres data sources

This version brings improvements in several key moments of the Husprey experience (connecting a data source, writing a query, drawing a chart), as well as a few bug fixes.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

Charts: Specify span gaps behavior

Optionally draw lines between points with no or "null" data (a.k.a. "Span gaps"), using a solid or dash line:

Graph with lines alternating from solid and dash

This option is available for line and area visualizations, in each series menu:

In series menu : Span gaps highlighted

SQL editor: Comment/uncomment from keyboard shortcut

When writing a SQL query, simply hit Cmd+/ or Ctrl+/ to toggle comment for the selected lines.

Add a comment to an SQL query specific line

PostgreSQL data sources: Optionally provide SSL certificates

When adding a PostgreSQL data source, you can now provide an SSL root certificate, along with client certificate and key. These are available in the "Advanced SSL options":

When SSL toggle on, possibility to add : Advanced SSL option, Server root certificate, Client certificate, Client key

Read more about SSL certificates for PostgreSQL in general (https://www.postgresql.org/docs/current/ssl-tcp.html), and how they can be setup and used with Google Cloud SQL (https://cloud.google.com/sql/docs/postgres/configure-ssl-instance).

Bug fixes

  • Fix autocomplete not being triggered in some cases

  • Properly handle pagination when listing many BigQuery projects/datasets

  • Properly handle BigQuery datasets which names start with a number

  • Better handle unexpected errors when saving a notebook

  • Fix label of the "Color" selector for chart series


April 8th - Full Husprey experience for ClickHouse data sources (beta)

This version brings the experience for ClickHouse data sources up to the level of all other connectors, as well as other improvements.

Clickhouse Logo

ClickHouse connector (beta)

Any ClickHouse database can be added to your workspace. In addition to sync this data source and run queries, this version brings the full-featured Husprey experience, including:

  • Explore the data source (databases, tables, columns) in the "Data Explorer" panel

  • Easily get a preview of any table from the "Documentation" panel

  • Get autocomplete hints when typing a query

  • Cancel a query from the 3-dots menu

Other improvements

  • To avoid any confusion or misinterpretation, display a warning on the chart if there are exactly 100 rows in the result set and rows limit is enabled:

Warning on a chart : Results are limited to 100. Help description to modify it
  • The in-app tutorial has been improved for an easier onboarding

Onboarding steps - Already done ones are crossed out


April 1st - Multi data sources, and conditional formatting

You can now connect several data sources to your workspace!

This version also brings conditional formatting in result table, as well as some other improvements, and fixes a few bugs.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

Multi data sources

You can now connect as many data sources as you want! There are numerous use cases when this proves to be useful: compare some staging and production environments; monitor and check a database / data warehouse migration; write queries on data not (yet) integrated into your main data warehouse; etc.

To add a new data source, go to the Settings > Data Sources page, and follow the instructions on screen.

In Settings - Connect multiple data sources

Then, when writing a query in a notebook, pick the right data source that it should run onto from the dedicated select:

In Query : mention on far right to chose data source

Conditional formatting in result tables

Apply conditional formatting to result tables, with progress bars or color scales, and get a better view of your data in the blink of an eye!

New option in the table column menu:

Column menu - Conditional format possibilities : none, progress bar, color scale

Progress bars and color scale:

Chart example of Progress bar and Color scale

ClickHouse connector (beta)

Any ClickHouse data source can now be added to your workspace. Some elements are missing for now, but you can already sync your data source, and run queries.

Want to test it? Just ask us to join the beta!

Data source integrations logos - Clickhouse logo highlighted

Other improvements

  • Customize line thickness in line charts:

In Chart menu : select line thickness wanted
  • Editors can decide to not show SQL in a notebook when it is published

In notebook menu : Select to Show SQL when published

Bug fixes

  • Move the result action buttons down so that it does not overlap with the table or chart anymore

  • Fix infinite save loop of a notebook in some cases

  • Fix sticky query header being hidden or hiding other elements in some cases


March 8th - Charts and autocomplete improvements

This version brings several charts, autocomplete, and performance improvements, and fixes a few bugs.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

Charts: Full-screen mode, Download as image, 100% stacked

The previous release brought resizable charts for higher customization and better readability. Now, users can display any result in full-screen mode from the new action bar:

Action bar : Display a chart and table in Full Screen

This new action bar also allows users to download any chart as a PNG image:

Action bar : Download image highlighted

Last but not least, a new "100% Stacking" chart option has been added for easier data manipulation directly within Husprey:

In Chart display menu - Stacking possibilities : No stacking, Stacking, 100% stacking

Autocomplete

Several fixes and improvements have been made, including:

  • Provide autocomplete hints when working with aliases

  • Fix context being lost in some cases for BigQuery

  • Better handle mixed-case identifiers

Other improvements

  • Move elements of a notebook up & down from simple keyboard shortcuts: Alt-Shift-Up, and Alt-Shift-Down

  • For a smoother experience, do not fetch all results of a notebook at page load, a.k.a. lazy loading

  • Locally define a display name to any result field, further used in table and chart:

Change display name on result column in table and chart
Change display name on result column in chart editor

  • Better handle very long queries. In particular, make their header stick to the top of screen, and set a max height to the SQL editor

Notebook with query header sticking

  • Sometimes it's easier to start over from scratch: analysts can now reset the whole chart configuration (type, series, colors, etc.) from a single button in the editor:

In chart editor on bottom left corner : Reset button
  • In query results, fetch up to 100k rows from the data source, instead of 10k (onprem only)

Bug fixes

  • Fix table preview unavailable in some cases

  • Do no run only the selection when a query is collapsed

  • Fix label formatting using the wrong format for "Split by" / "Stack by" series

  • Fix crash in result table in some cases

  • Silently ignore unsupported notifications for better retro-compatibility

  • Fix clickable notebook footer not being stretched to the end

  • Fix right panel not being remembered to be closed

  • Fix very long queries not being properly received by some components

  • Fix BigQuery connection parameters to be able to query GSheet-based tables


February 21st - New roles, chart resizing and color pickers

This version brings the support of a new User role and chart improvements. Some performance improvements and bugfixes are part of the release as always.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

New role - User

A new role has been introduced: User. Users can browse and read published notebooks. They cannot create or edit content. They cannot access raw data - only see query results (charts and tables) that are part of published notebooks. Very often, this role particularly fits Business Users.

Tip: Users can still leave comments on your notebooks!

You can choose the role of a user directly when inviting a user (or you can change it later from the Settings menu)

Inviting new teammates - role available 'User'

You'll find all details about roles and exact permissions here.

Chart Improvements - resize and colors

Resizing a chart according to your liking

Sometimes charts need some space. We give them the space you want them to have with a simple resize. Top asked feature over the past month!

And you can pick any color for any series! Our picker also remembers last used colors so your notebook is easy to style.

Color picker for series : already used ones and new ones

Analysts can also pick the horizontal axis type between: Time series, linear or category.

Queries improvements

  • Analysts can cancel an execution from query menu

  • New status icon in query footer to ease readability

  • Analysts can run a selected sub-part of a query to ease debugging

  • Analysts can easily duplicate or move up and down a query

  • Line numbers are displayed in queries

  • Errors are highlighted (Big Query only)

Fixes and performances improvements

  • Search-specific database indexes for faster autocomplete in SQL editor

  • Handle dbt artifacts up to version v4

  • Improved SQL parsing for local tables

  • Improved error messages and actual database errors when it was not the case

  • Do not fail a scheduled job when a query has been deleted

February 4th - Multiple BigQuery projects, and more.

This version brings the support of multiple BigQuery projects, major performance improvements πŸš€, and fixes a few bugsπŸ›.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

Support multiple BigQuery projects

Teams with a multi-projects data warehouse in BigQuery now get the full Husprey experience!

All BigQuery projects available to the service account used to connect Husprey to your data source are now synced with Husprey, and made available in the Data Explorer and autocomplete.

Big Query data explorer - Lists of projects

New user notification πŸ’¬

For easier administration and monitoring, admins receive a dedicated notification when a new user joins their workspace:

Admin notification that a new user has joined the workspace : name and email

Any user can add tags 🏷️

We've heard your feedback about tags! Now any user in the organization can access the Tags management page in the Settings

In Settings - Manage workspace tags

Performance improvements πŸš€

Several elements about performances have been improved in this release. This includes:

  • Revamp autocomplete suggestions for faster rendering

  • Speed up publish / unpublish operations

Other improvements

  • Directly get a view on the Schedule config and last execution from the About panel, for faster check and better discoverability:

About Panel - Scheduled execution date and last executed date
  • Full-width preference is now made an attribute of the Notebook, hence saved and shared (not anymore a local toggle)

In Notebook menu, toggle on Full width

Bug fixes

  • Fix hint "Ctrl + Enter to run your query" only being displayed for a brief moment

  • Fix dbt description not being cropped on Safari 15

  • Fix crash on Safari for iOS < 13.4

  • Fix pattern "2022w01" in notebook title not being auto-incremented to "2022w02" when duplicating

  • Fix data source sync for BigQuery datasets which name starts with some special characters

  • Fix extraneous save operations on notebooks in some cases


January 18th - Notebook scheduling, chart improvements, and more.

This version brings important new features: notebook scheduling for automatic updates ⏰ , "Queries" panel from which you can run all of them in one click ⏩, and new chart capabilities πŸ“Š. It also improves performances πŸš€ , and fixes a few bugs πŸ› .

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

Notebook scheduling

Schedule automatic executions of a notebook from the dedicated panel, and use it for e.g:

  • Feature Launch - you launched a new feature and want to follow impact while taking notes. Data is refreshed daily and after about a month you can finish up and freeze both the data and your conclusions.

  • Weekly insights - you can prepare weekly sales, marketing, or product reports with scheduled data execution. All that is left for you is understanding the results, maybe deep-diving in a specific area, and sharing decisions.

In schedule panel, time your wanted automatic executions

The history of all scheduled executions will then be available in the right panel:

In schedule panel, view automatic execution history

"Queries" panel

That same right panel now includes a new "Queries" section, from which you can get an overview of all queries in the current notebook with their execution status and duration, updated in real time.

In Queries panel, view execution status and time

With the "Run all" button, refresh the results of a whole notebook in one click, and better focus on what matters: rationale, results, and comments.

In Queries panel, 'run all' button

Stack by / Split by option for charts

Break your current metric out by an additional dimension by choosing it as "Stack by" or "Split by" option. It comes in handy for SQL queries with "double group by" (e.g. on both time and a category).

Chart editor - Stack by

This feature comes with default rules for a smoother experience:

In chart editor - Stacking possibilities : No stacking or Stacking

Note that you cannot then pick multiple series / metric to be displayed.

Dark mode

Turn Husprey to dark mode from your personal settings. Choose one option manually, or pick the "Auto" one to make Husprey follow your system preferences.

In Settings, Profile subcategory - Control Dark Mode

Other improvements

  • Improve rendering performance of the whole notebook page, with a focus on Safari πŸš€

  • Display labels on data points for any chart type.

In Chart editor, toggle on Data labels
  • Get notified when a new version is available

Notification when a new version is available. Click on Reload button to enjoy
  • Improve invalid query handle error location for better discoverability and clarity

Invalid query in Red

Bug fixes

  • Fix memory leak due to local cache not being cleaned up

  • Fix SQL parsing errors in some cases


December 10th - Mostly bug fixes, and new real time sync for comments and data results.

This version mostly fixes bugs πŸ›, and brings real-time sync for comments and data results πŸ”ƒ.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

Real-time sync for comments and data results

Comments and notifications are synced in real time. Actual conversation can now happen! πŸ’¬

Also, if a SQL query takes a long time to run, the application now receives its result in real time as it comes out of the database. While this bring little visible improvement for now, it is part of the foundations of our next big feature 🌟

For the tech savvy readers, we are now using websockets!

Other improvements

  • Properly set the theme-color meta tag for nicer surrounding user interface ✨

  • Display the string representation of a postgres interval in the result table ⏳

  • Allow (back again) series to be hidden/displayed directly from the chart legend πŸ“ˆ

  • Improve the authentication refresh process for a smoother experience πŸš€

  • Improve rendering performance of data query elements 🎨

Bug fixes

  • Fix table columns not being displayed in the Documentation panel with some versions of Safari

  • Fix SQL parsing for some cases, including elements about the lag function, the on clause, and the cast operator.


November 26th - New design for data queries, view notebook in full width, and more

This version brings a new design for data queries ✨, a "full-width" option for notebooks ↔️, and fixes some bugs πŸ›.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

New design for data queries

The data query component has been fully redesigned to improve its usability and readability.

New design of data query

Also, you can now customize 2 particular elements:

  • the query handle: the name of the corresponding local table that you can use as a reference in subsequent queries (organizations_by_plan in the example above), and

  • the result title: meant to be written in plain natural language, as a table or chart legend, for your final readers ("Distribution of organizations by plan"')

New full-width option

Want to make the most of your large monitor? Need space to write / read long and complex SQL queries?

We've got your back with the new full-width option available from the top-right notebook menu!

In Notebook menu - Full-width toggle

Other improvements

The right panel has been slightly redesigned to prepare great upcoming features πŸ˜„

Right Panel - New design : include Contributors, Tags, Last edited, Created, Definitions

Bug fixes

  • Fix some columns being duplicated in the autocomplete suggestions

  • Fix SQL parsing for some cases


November 22nd - Combo charts, source tables of dbt models, and more

This version brings combo charts πŸ“ˆ, and extends (further) the dbt integration.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

Combo charts

We have heard your feedback and feature requests: combo charts are here!

Two series on a chart

They come with several new customization options:

  • Associate each series to a specific vertical axis

In Chart editor - Select color of specific series
  • Customize the visualization of each individual series

In Chart editor - Select visualization of specific series : Bar chart, Line chart, Area chart
  • Smart rules automatically distribute series over the 2 vertical axes.

  • The top-level "Combo chart" option comes with a handful of default values to smooth your experience.

In Chart editor - Chose chart of choice : Bar chart, Line chart, Area chart, Combo chart, Pie chart, Donut chart

Underlying source tables of dbt models

We believe in "build once and query anywhere". Right now it means helping Analytics teams leverage the Transform part of their workflow.

With this release, we deepen our dbt integration to bring Transform metadata where you write queries and reports.

Now, in addition to models and source tables being identified and enriched with information from your dbt project (description, tests, etc.), we make use of the dependency graph to display the underlying source tables a model depends on.

This comes handy when wondering on what specific data service/provider a given model is built upon (embedded analytics? CRM? application database?)

Note: source tables will be displayed after the next upload of dbt artifacts.

In documentation panel - Source tables available

If these source tables have freshness information, it is furthermore used to compute a model-level aggregated status, very much useful to assess the reliability of a given model.

In documentation panel source tables - info in Freshness : OK or Warning

Also, this integration is now available to everyone!

Other improvements

  • Better home page for new users that still haven't provided their database credentials.


November 8th - Extended dbt integration, improved UX for data panel, and more

This version extends the dbt integration, improves the data panel UX, brings several polished UI elements 🌟, and fixes some bugs πŸ›.

Do not hesitate to share some feedback using the dedicated bottom-left menu item.

Extended dbt integration

We believe in "build once and query anywhere". Right now it means helping Analytics teams leverage the Transform part of their workflow.

We are shipping the second part of our dbt integration to bring Transform metadata where you write queries and reports.

Now, in addition to descriptions and SQL being displayed for dbt models, new elements are available from the Documentation panel:

  • description and freshness information (if available) for source tables

In Documentation Panel general info - Freshness : OK or Warning
  • tests on columns for models and source tables:

In Documentation panel - Tests results of columns

Also, any admin can activate this integration from the Settings > Workspace page:

In Settings subcategory Workspace - Toggle on Beta integrations

Current limitations: For now, it's only available for dbtCore (not dbtCloud)

Improved data panel

For a better navigation, details of a table now open in tabs within the "Documentation" panel. Both "Data Explorer" and "Documentation" panels can be collapsed.

View both Data explorer and Documentation panel

Polished UI

Several elements have been polished to make them easier on the eye, starting with a new font, and new navigation items:

New font and Navigation

Other improvements

  • Smart naming rules when duplicating a notebook are now implemented for additional title patterns (week number, month, quarter, year):

Automatically smart-generated name of duplicate notebook

Bug fixes

  • Fix crash when searching in the data tree or in the list of columns

  • Fix SQL parsing for some cases

  • Fix websocket connection status being tracked at a too high level of the app, leading to extraneous renders

  • Properly handle errors that can occur in specific cases during data source sync

  • Reload the app if code chunk is not found during lazy loading


October 15th - Metadata panel revamped and initial dbt integration available on demand

New data panel πŸ‘¨β€πŸŽ¨

We wanted to help our users to make the most of the data tree. It's now a Metadata panel with information you need to write your SQL queries.

Once again do not hesitate to share feedback about this redesign. It would mean the world to us. You can use the bottom-left menu item for that.

New data panel design

You can navigate your schemas and tables as before. But now a table panel opens when needed so you can list and search columns from a table (even when hundreds of them). A preview of your table is available with sample rows.

These changes drastically improve your knowledge about what can be done.

dbt integration

We believe in "build once and query anywhere". Right now it means helping Analytics teams leverage the Transform part of their workflow.

We are shipping the first parts of our dbt integration to bring Transform metadata where you write queries and reports. If you want to try it out, please contact us.

Description (text and markdown) are displayed but also dbt models SQL so you can better understand how a table was built.

Current limitations: For now, it's only available for one project per workspace and for dbt Core (not Cloud). We have more to come on this in the coming weeks.

Other improvements and fixes

  • Add Husprey as application_name in our data base connections to ease monitoring

  • Local tables use a snake-cased version of query title as local table identifier

  • Fix edge cases where SQL generation failed when using local tables

  • Fix search not expanding all nodes when using personal credentials

  • Fix a crash when selecting a text format in the Editor toolbar on Safari


September 30th - Local tables, improvements on comments, and bug fixes

This version brings a fundamental piece of our vision πŸ”­ : our notebooks are the heart of our SQL workspace for Data Analysts and they get a lot more powerful with local tables πŸš€ ! Read on for more details πŸ‘‡

Do not hesitate to share your thoughts using the dedicated "Feedback" button right from the app!

Local tables

In Data explorer - View local tables

You can now directly run:

SELECT *
FROM my_awesome_previous_query

All previous queries now generate a local table that can be referenced in a notebook. You can then quickly see how intermediate results look like while writing something that is closer to your actual workflow.

If you are using CTEs ("with my_favorite_cte as"), then it might sound familiar to you. Actually, behind the hood we use CTEs but we drastically improved the analysts' experience.

This feature is still currently considered in beta. Any admin can activate it from the Workspace settings.

In Settings, subcategory Workspace - Toggle on Local tables

When activated globally, you can still disable this feature for a given notebook if needed

In Data explorer, toggle on or off Local tables

Comments and notifications

πŸ”— Easily get a direct link to any thread from the new top-right menu

In Comments menu - Copy the link of specific comments thread

(Cloud only feature) βœ‰οΈ Receive unread notifications by email, and do not miss anything in your Workspace.

Receive notification of comments - Include : Name, Preview of comment, Open button

You can deactivate these email notifications from the settings page:

In Settings, subcategory Notifications, toggle on or off Email notifications

Other improvements

Here are some additional improvements coming into this release:

  • Split the application code bundle in several chunks for a faster initial load

Bug fixes

  • Fix crash on mobile due to Notification API

  • Fix button to expand the right sidebar in Notebooks

  • Fix Notebook action menu that could fly around in some cases


September 20th - Various improvements, and a surprise 🎁

This new version improves the experience around comments and notifications πŸ’¬, drastically improves performances of the text and SQL editors πŸš€, and more. Read on for more details πŸ‘‡

Do not hesitate to share your thoughts using the dedicated "Feedback" button right from the app!

Comments and notifications

πŸ” Unseen comments of interest are now highlighted to more easily follow conversations.

In Comment thread, get aware of new unread comments

βš™οΈ Desktop notifications can be activated / deactivated from...

... the notification center

Browser notification pop-up - either Skip or Turn on

... and the Settings page

In Settings, subcategory Notifications - Toggle on and off Browser notifications

🎁 Reply to a comment with an emoji (who can live without emojis, huh? 🀷)

Add emojis to your comment

Reminder: Comments are available for new notebooks only. If you work on one that does not support the new feature, you'll be advised to duplicate it or create a new one.

Notification on notebook that comments aren't available and possibility to Duplicate or Create new one

Note: This "Comments" feature uses websockets to get real-time updates. Please check that your setup supports them.

Text and SQL editors

  • Improve performances when typing text in a notebook body, and when typing SQL in a query.

  • Improve auto-scroll behavior when going directly to a given query

Other improvements

Here are some additional improvements coming into this release:

  • Redesign the left panel to prepare upcoming great features 😊

Data explorer new design
  • Autocomplete can be disabled from the Settings page

In Settings, subcategory Profile - Toggle on and off Autocomplete


September 10th - Comments, notification center, and more

This new version brings real-time notebook comments πŸ’¬, a global notification center 🏠 , and more. Read on for more details πŸ‘‡

Do not hesitate to share your thoughts using the dedicated "Feedback" button right from the app!

Comment on a notebook

Collaborate with your coworkers with real-time notebook comments πŸ’¬

You can post global comments from the header:

Comment directly on a notebook in general

Or comment on specific elements:

Comment on specific parts of the notebook

Working on another notebook? No worries, notifications are here to keep you up-to-date.

Notifications of new comment in other notebooks

Note: Comments are available for new notebooks only. If you work on one that does not support the new feature, you'll be advised to duplicate it or create a new one.

Notification on notebook that comments aren't available and possibility to Duplicate or Create new one

Notification center

Stay on top of the latest events in your workspace with the notification center available from the home page 🏠

Notification Center - history of events : Comments...

Improvements

Here a some additional improvements coming into this release:

  • After signup, new users get redirected to the page they tried to first visit (handy when sharing notebooks!)

  • New pre-login screen to give a warmer welcome to our users πŸ€—

Welcome to Husprey page : Possibility to Sign in or Create an account

Bug fixes

  • Fix notebook duplication and CSV export with large result sets

  • Fix crash on pie charts in some cases

  • Display BigQuery objects in result table


August 16th - Export CSV, duplicate notebooks, and more

πŸ“£ Much requested features ahead! πŸ˜ƒ

With this version, you can export query results in CSV, duplicate an existing notebook, and more. Read on for more details πŸ‘‡

Do not hesitate to share your thoughts using the dedicated "Feedback" button right from the app!

Export query results in CSV

Easily export specific query results for further sharing and use in external tools (did someone say spreadsheets?).

To do so, use the new button available in the header of a query when in table view:

Duplicate an existing notebook

Reproduce a previous analysis or update a report by duplicating an existing notebook, right from the top-right 3-dots menu:

Duplicate a notebook - Toggle on or on Copy query results

Improvements

Here a some additional improvements coming into this feature:

  • Copy direct link to a given query. No more manual scrolling to the right section!

Query menu - Copy query link
  • Run a collapsed query directly from its header:

Run a query directly from the header - Play button
  • Admins can invite several new users at once.

Invite teammates - Refer email adress
  • Mobile users are gently informed that the mobile experience is mostly read-only.

Mobile popup to view notebook on Mobile
  • Tooltips, modals and welcome screens have been polished for better readability.

Bug fixes

The page number of notebook list is reset when filters have changed.


July 21st - Charts and UI improvements

This version improves the chart experience πŸ“ˆ, brings a few more polished UI elements 🌟, and fixes some bugs πŸ›.

Do not hesitate to share your thoughts using the dedicated "Feedback" button right from the app!

Charts

Customize the x-axis ticks rotation via the dedicated drop-down menu in the chart editor.

In Chart editor - Display axis : Auto, Horizontal, Vertical

More vivid colors for nicer charts:

In Chart editor - Chose series color

Improvements

The tutorial has a nice surprise in store for users who complete it (will you find it? πŸ” ).

Onboarding screens, buttons and dialogs have been polished.

Bug fixes

No more clutter with poppers and SQL code lines.

Copying a JSON value from a result table... actually copies that JSON.


July 9th - Tutorial, date formats, and more

This version gives a warm welcome to new users πŸ‘Ά with a step-by-step tutorial, and charms data aficionados πŸ€“ with date formats!

We've also polished a few elements of the UI to make them easier on the eye 🌟

Tutorial

New users are now welcomed in Husprey with a dedicated tutorial and revamped home screen.

Welcome Pop up - Steps to follow
Welcome popup bottom right - Steps to follow

Date formatting

As you always wanted to, you can now nicely format dates in tables and charts.

Some default rules are applied to smooth your data experience!

In Chart editor - Format date according to liking

Autocomplete for BigQuery

Autocomplete is now also available for BigQuery data sources.

Autocomplete on Big Query


June 21 - Pie charts, filters, and more

We've heard your various feedbacks (thanks a lot for sharing them πŸ™ - do not hesitate to send new ones using the dedicated "Feedback" button right from the app), and here are 3 new features and improvements in this release!

Pie & donut charts

Use a pie or donut chart to display a single metric split into a (small) number of groups (i.e. the result of a GROUP BY aggregation).

The options let you choose which field to use as your "Series", and which one to use for the "View By" dimension (i.e. the pie slices). You can also customize the chart’s legend, and whether or not to show the total in the middle of the donut.

In Chart editor - Select wanted Display : Pie chart or Donut chart

Filter Notebooks by tags

Filter the list of all Notebooks by tags, and more easily browse your company's data knowledge.

Search bar - Filter by tag

As a shortcut, simply click on any tag displayed in that list to add it to the filters.

Search bar - Click on tag of notebooks previewed to filter the search

Autocomplete for joins

Getting tired of manually writing these tedious join conditions? 😫

Autocomplete is now supercharged with elements from your data model, and directly suggests appropriate joins, just as you type.

In Query - Autocomplete on JOIN


May 27 - Autocomplete

No more silly typos and headaches trying to remember these 🀯 column names, autocomplete is here! πŸ˜… πŸŽ‰

  • Automatic. As you type a SQL query, the suggestion menu will pop up if there are possible completions.

Autocomplete SQL queries
  • Convenient. If you continue typing characters, the list of members is filtered to only include members containing your typed characters. Pressing Tab or Enter will insert the selected member.

Autocomplete according to characters typed
  • Bound to your data model. Go through schemas, tables and columns within a few key strokes.

Autocomplete query according to data model
  • Handy. You can trigger autocomplete in any editor by typing Ctrl+Space.

    The editor also supports "tab completion" which inserts the first matching completion when pressing Tab. This works regardless of the suggest widget showing or not.


May 21 - Default 100-rows limit that can be extended to 10k rows

  • You are not limited to 50 rows anymore. You can query up to 10k rows and chart up to 1k rows.

  • All new queries have a 100-row limit by default. You can edit that from a query menu or hovering the query execution line!

    100-row limit in Query toggle on or off


April 27th, 2021 - Use your write rights (Personal data source only)

  • When using personal credentials, you can now write into your database. It's limited to current user's rights.

Example:

In Query - write into database
  • Also, you can refresh your data model when you need to see your latest changes. After you created a table for example.

    In Data explorer, refresh data


April 19th, 2021 - Personal credentials

  • Share a data source but not your credentials. When setting up a data source, you can now make sure each teammate use their own credentials to make requests.

Data Source Settings - Possibility to Share credentials or not
  • More space to write. Notebook metadata are now displayed in a collapsable right panel.

  • Never lose work. A Notebook is locked if concurrent updates happen. You can force save if needed or restore a previous version

  • (SaaS only - contact us to activate on an on-premise instance). Online viewers of a Notebook are displayed in the metadata right panel.

In Right Panel - Viewers diplayed
Did this answer your question?