Databricks SQL Tool Features
The Databricks SQL tool features provided by RazorSQL include a custom Databricks database browser tailored to Databricks, a Databricks SQL editor, Databricks visual tools, and Databricks database administration tools. Listed below are more details on these features.
- Displays information in a tree format for databases, schemas, tables, views, columns, etc.
- Displays Databricks table information such as column name, column type, column length, column nullability.
- Easily view table contents or database object information via the View Contents and Show Info context menu options
Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Supports over 20 programming languages including SQL, PHP, HTML, XML, Java, and more.
Databricks GUI Tools
- A Databricks create table tool that generates Databricks specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, and nullability.
- A visual edit table tool for visually editing Databricks tables in a spreadsheet format
- A Databricks Export Tool for exporting query results, single tables, or multiple tables.
- A Databricks Import tool for importing data into tables.
- A Generate DDL Tool for Databricks for generating Databricks DDL.
Below is a screen shot of the RazorSQL Databricks SQL GUI Tool using the dark mode interface.
