Support for Databricks

We’ve added support for Databricks as a datasource in Mode. To connect to Databricks, first navigate to the Databricks cluster detail page > Advanced Options > JDBC/ODBC tab. Take down the following information:

  • host name
  • port (defaults to 443)
  • database name
  • an authentication token created specifically for your Mode connection (see documentation for more info)
  • the "HTTP path" field

For help finding the settings in the Databricks cluster, check out the Databricks documentation.

In Mode, select Connect a Database in the left hand navigation. In the dropdown list, select Databricks Spark. From there, complete the fields with the above information. Once connected, you can build and share visualizations created on Databricks data.

databricks.png

Please note: users will need to use HiveQL when querying Databricks data in Mode.

If you’d like to connect Mode to a Databricks instance on your internal network, you can use a Bridge Connector.

Report Clone option in Query Editor

We've fixed a bug where previously, the clone option in the Query Editor was not appearing as expected. Now, the clone option appears in the Report menu within the Query Editor view.

HTML Editor Update functionality

We've fixed a bug where previously, the Update button in the HTML Editor would cause the editor, toolbar, and portions of the Left Navigation Panel to disappear from view. Additionally, a loading spinner would incorrectly appear in the lower part of the view.

Now, pressing the Update button no longer incorrectly impacts these components.

Min/Max controls in HTML Editor

We've fixed a bug where previously, the min/max controls in the HTML Editor were not operational. Now, they function in a manner that is identical to that within the Query Editor.

Query history

We've fixed a bug where previously, only failed runs would show in the query history within the Query Editor. Now, both failed and successful runs appear providing a complete record for the user.

Undo/Redo behavior in Query Editor

We've improved use of the undo/redo hotkey in the Query Editor. Previously, the Query Editor could only maintain a single undo/redo for all Query Editor tabs in a given report. This often limited explorable content and potentially overwrote previous query contents.

Now, each query within a report maintains its own undo/redo stack, for an improved experience.

Limit new database connections to admins

Mode Business organizations can now choose to limit database connections to organization admins only.

To limit new database connections to account admins, go to SettingsPeopleMember Authorization. Under “Who can connect data sources for this organization?” select “Only admins,” and then click “Save settings.”

Notebook markdown cells

We've fixed a bug in the Notebooks where markdown cells required modification before they could be rendered by running the cell.

Now the behavior is consistent with Notebook code cells, and can be run without requiring any modification.

Additionally, we've adjusted markdown behavior to be consistent with the Run button shortcut. Now both the "Shift-Enter" shortcut and Run button behave the same way.

Notebook toolbar persistence

We've fixed a bug where the Notebook toolbar would disappear from view after specific keystroke sequences.

Definitions preview persistence

We've fixed a bug where a user selected the preview for a Definition in the Query Editor, and previews would incorrectly persist if the user switched to a Chart or Display Table.