Databricks 平臺中的模型和設計

ER/Studio Data Architect is a software suite designed for data modeling and database design. It allows users to create visual representations of data structures, translating complex information into clear business models. ER/Studio offers features for both conceptual and physical data modeling, supporting a variety of databases. This comprehensive approach helps organizations improve data quality, manage database changes, and ensure data remains consistent and accessible across the enterprise.

The ER/Studio Data Architect 20.2 update adds native integration and support for Databricks, streamlining data modeling workflows for Databricks users. This new integration enables software developers to perform reverse engineering directly from the Unity Catalog, facilitating the creation of accurate data models from existing Databricks databases. ER/Studio Data Architect 20.2 also allows for forward engineering through DDL scripts and direct database connections, providing a cohesive environment for designing, documenting, and deploying data models within the Databricks ecosystem. By offering native integration and support for Databricks Unity Data Catalog and its latest features, ER/Studio ensures that users can effectively work with Delta Lake tables across all cloud platforms.

To see a full list of what's new in 20.2, see our release notes.

ER/Studio Data Architect is licensed per user and is available as a Workstation User License, Network Named License, or Concurrent User License. The Workstation option is perfect for individual users; while the network-based named and concurrent licensing options provide a flexible, cost-effective solution for organizations with a larger number of users, who want the ability to share and manage a pool of licenses. See our ER/Studio Data Architect licensing page for full details.

Learn more on our ER/Studio Data Architect product page.