Recent Innovations in the SAP HANA Database Explorer (Q3 2021)
The SAP HANA database explorer provides a web-based tool to browse and query your SAP HANA Cloud, SAP HANA database and data lake. This past quarter has seen many new features added. Features can appear in the SAP HANA database explorer as often as every two weeks which is different from SAP HANA Cloud, SAP HANA database, which introduces new features on a quarterly release cycle as described in Releases and Upgrades in SAP HANA Cloud. To see a complete list of recent new features for the SAP HANA database explorer, use the What’s New link from the SAP HANA database explorer.
- Visual Clues for Production Databases
There are now visual clues alerting you to be careful about executing statements that could impact performance when working with databases that are marked as production databases.
- View SQL Warnings
When the SAP HANA database returns a warning as part of executing a statement, the warning now appears in the SQL Console.
- Support for Google Cloud Storage in the Import and Export Wizards
As of SAP HANA Cloud, SAP HANA database version QRC 3, 2021, you can use the import and export wizards with data stored on Google Cloud Storage.
- Import Data Wizard Enhancements
When importing an Apache Parquet file, or a CSV file that has a header row, the import wizard now displays the column names found in the file during the table mapping step.
When importing from a cloud storage provider, you can now opt to create an error log file in the event that errors occur.
When importing a local file, you can now opt to trim whitespace and specify the field delimiter.
- New Options When Downloading or Copying Results from the SQL Console
When downloading or copying results from the SQL Console, you can now opt to specify the field delimiter and enclosure, and whether to include the column names as a header row.
- Ability to View Proxy and Virtual Tables (SQL on Files)
You can now view the proxy and virtual tables that are used to enable queries on files stored as part of SQL on Files.
More details on SQL on Files can be found at What is SQL on Files.
- Graph Viewer Now Supports Algorithms and Composite Keys
You can now use the shortest path algorithm to show an optimal route between vertices.
You can also use the neighborhood algorithm to show only the vertices that are connected to a specified vertex.
You can now view graph workspaces consisting of edge and vertex tables with composite keys in the graph viewer.
For step-by-step instructions demonstrating many of the features of the SAP HANA database explorer, see the tutorial group Get Started with the SAP HANA Database Explorer.
You may also be interested in viewing 2021-Q3 Key Innovations in SAP HANA Cloud Central and SAP HANA Cockpit and What’s New in SAP HANA Cloud – September 2021.