ER/Studio Data Architect 20.2 delivers hotly anticipated support for Databricks. This allows customers building data warehouses and lakehouses in Databricks to take a structured approach to the design process and incorporate standardization and governance practices.
Updates to ER/Studio Data Architect 20.2 with Databricks
- Databricks Support
- Core Platform support, including
- Reverse Engineer from Unity Data Catalog
- DDL Code Generation
- DDL Code Import
- ALTER script generation
- Support for Delta Lake features provided by Unity Data Catalog, including
- Primary Key, Foreign Key, and Check Constraints
- Materialized Views
- Managed & Unmanaged Tables
- Clustering and Partitioning
- Bloom Filter Indexes
- Functions and Mask Functions in Tables
- Views
- Advanced handling of denormalization with nested structures
