Nearly every month you get new benefits
Extend documentation beyond the object level with rich text full-length content, embedded images, diagrams, styling, and formatting. Pages allow teams to maintain project-level overviews of things like metrics and KPI definitions, business terms, and operational outlines... Find out more.
An all-in-one project information portal in HTML format for end-users with searchable object details, descriptions, and references. Reports offer a sleek interface for finding and navigating between related project assets... Find out more.
Native support for views (including materialized) for GBQ projects... Find out more.
SqlDBM is thrilled to announce Google BigQuery as the latest cloud data platform to be supported as a native project type. Out of the gate, SqlDBM users will be able to direct connect to their BigQuery projects and begin modeling and maintaining their database objects and metadata... Find out more.
Databricks - serverless reverse engineering using Unity Catalog API... Find out more.
Undetected object changes can have unintended consequences in downstream data pipelines. SqlDBM’s Snowflake schema monitoring periodically polls your Snowflake databases and alerts designated recipients if DDL changes are detected-giving you the opportunity to be take proactive measures. Our dedicated dashboard lets administer monitoring job runs and review the logs and changes detected on past and a visual timeline to spot change patterns... Find out more.
Large teams on SqlDBM Enterprise plans can now create and manage user groups. User groups can then be added to projects just like individual collaborators, giving access to everyone in the group. User groups make it easier than ever to collaborate across multiple teams and quickly bring (or remove) multiple users into a project in a single step... Find out more.
With the data governance suite, SqlDBM steps into the cataloging and metadata management arena. For organizations looking for a streamlined governance solution without going all-in on a dedicated cataloging tool, SqlDBM brings user-defined fields to the database documentation. Find out more.
Snowflake tags are now fully supported across all of SqlDBM, including reverse and forward engineering and alter scripts. You can now manage and apply tags to all supported project objects and validate and deploy tagged assets to your database. Find out more.
Alter scripts for changes in across Databricks projects and environments
With Enterprise Plus, customers get all the modeling and collaboration features available in SqlDBM, plus robust, enterprise-grade security. This plan offers features like customer-managed S3 hosting and encryption keys, AWS Private Link, IP management, and access logs. Find out more.
Snowflake constraints (PK, FK, AK) support RELY in reverse/forward engineering and object properties. The RELY property is a keyword included in the constraint definition and acts as a hint for the Snowflake optimizer to rely on the integrity of the constraint and perform join elimination on views and redundant queries. An article describing how RELY can improve query cost and performance is available here.
By popular demand, relationship lines are now customizable in SqlDBM diagrams. Users can bend relationship lines at any point and set their shape permanently on the diagram. This functionality provides complete control over diagram design and ensures that relationships are properly situated for clearer separation and understanding.
Our latest release adds search functionality to the project dashboard. SqlDBM users can now find the project they are looking for faster by typing all or part of the name into the search bar at the top of the page. Search results include personal and shared projects as well as branch names from those with concurrent working.
SqlDBM's visual modeling interface lets users rearrange or clone columns in or across tables by simply clicking and dragging. Now, the same functionality is also available in the single-table edit mode. Using the handles to the left of a column, users can drag to rearrange column order or ctrl+drag to clone existing columns while editing a table.
SqlDBM is excited to partner with Databricks and provide native support for Databricks projects-offering collaboration, visibility, and cataloging, all in the cloud. Databricks provides the management and performance of a data warehouse with the flexible object store of a data lake.
Oracle projects were released in open Beta last month and enhancements are already rolling out. Alter scripts for Oracle projects are now available in our latest release. Be on the lookout for additional improvements like views support and conversion to other project types, as we work diligently to bring Oracle projects out of Beta and into full support.
A secure API for programmatically accessing SqlDBM projects is finally here-opening the door to unlimited integration potential. We've also been hard at work enhancing the recently-released Oracle project feature, which now supports alter scripts.
Oracle, the world's biggest database platform by market share, is now available in SqlDBM as a supported project type. Enjoy familiar features like reverse and forward engineering, atler scripts, and revision compare with Oracle-native syntax and properties.
The entire project team can now work collaboratively and in parallel without having to lock a project. Changes made in any branch can be compared before merging to main and synchronized with any new updates that happen meanwhile. It's everything you've come to appreciate with git, built right into SqlDBM.
AlloyDB is a PostgreSQL-compatible database service for demanding enterprise database workloads that combines the best of Google Cloud Platform with one of the most popular open-source database engines. AlloyDB is more than 4X faster than standard PostgreSQL for transactional workloads and 100X faster for analytical queries.