DbSchema is a Databricks client and manager featuring interactive diagrams for designing the database schema in a team, schema deployment on multiple databases, document the database schema, edit and execute database queries, generate data, reports, data analysis, and more.
Download DbSchema Editions
After connecting to the database, DbSchema will reverse engineer the Databricks database structure in its model and visualize it graphically. You will interact with the schema using layouts (diagrams). The layouts can handle large databases with more than 10.000 tables. The graphical interaction will help to improve the database design.
The DbSchema model refers to the representation of a database schema within the DbSchema application.
DbSchema model is using its copy of schema structure, independent from the Databricks database.
This is a separation between schema design and the database, with numerous advantages:
Compare and deploy the database schema on multiple Databricks databases. Incremental changes can be applied.
Save the design model including the schema structure to model file, as XML text. The model file can be open from any computer, without Databricks connectivity.
The model file can be stored in GIT and shared in a team. Each team member can modify it and commit model changes in GIT. Database administrators can deploy the schema changes on testing or production databases.
Generate migration scripts from one version of the schema to another by comparing two different model files with two versions of the same schema.
Schema can be designed offline, without database connectivity.
In DbSchema, layouts refer to the visual arrangements and configurations of various components within the application's workspace. Layouts help users organize their work by defining the positioning and visibility of elements such as database diagrams, SQL editors, query results, and other tool windows. DbSchema offers different predefined layouts, such as Design, Query, and Reports, which can be customized and saved based on individual preferences and project requirements. These layouts allow users to switch between different views and focus on specific tasks or aspects of their database work.
Tables and columns can be edited directly in the layouts. The layouts will be saved as model file.
Comments can be added to each table or column and Databricks interactive HTML5 or PDF documentation can be generated.
Read More
An amazingly simple Databricks data explorer and editor that offers simultaneous views of data from multiple tables, and features numerous filters, data sorting mechanisms, and much more.
The editor can explore data from multiple tables simultaneously using foreign keys or virtual foreign keys between tables.
If the schema is missing foreign keys you can create virtual foreign keys that will be part of the DbSchema model.
Read more
There is no need to be an Databricks SQL pro to be able to write database queries.
Create queries is an easy task for the Visual Query Builder. The builder can use different Join types and Group By functions.
Read more
The Databricks SQL Editor features syntax highlight, text auto-completion, query and script execution, Groovy support, graphical execution plan.
Read more
For development or test purposes you may need to fill the Databricks database with randomly generated data.
A bunch of predefined reverse regular expressions as well numbers, date, JSON, and groovy script generators will help you.
Read more
DbSchema uses its own images of the schema, distinct from the Databricks database, which is saved as a model file.
The DbSchema model can be compared with any database.
For each difference, you can decide to merge in the DbSchema model, apply it in the database, or generate the SQL scripts.
Read More
All major DbSchema processes, like schema synchronization and deployment, generate documentation,
reverse engineer schema structure can be automated using Groovy or JS scripts with direct access to DbSchema API.
Read More
Foreign keys are used for data accuracy.
If the database lacks foreign keys, you can create Virtual Foreign Keys that will be created only in the DbSchema model
and will be saved to the model file.
They will help you to gain a better understanding of the database.
Read More
You don't need a separate tool to build database forms or reports.
DbSchema can create responsive web reports which you can deploy on a separate server.
You may also create small applications with input fields, buttons, and charts.
Read More
Import data from various files, including CSV, XLSX, XLS, XML, into the database.
Read More
