Platform

Data Modeling

Develop data models collaboratively in the cloud and share them with your organization in various modeling styles and formats with no coding or conversion required

See pricing

Model Governance

Create and manage business metadata using a dedicated project role

Load more

Snowflake Schema Monitoring

Track and get notified of schema changes in live database environments

Load more

Integrations

See all

Why SqlDBM?

Have questions?

Request a demo for more information

Book a demo

Resources

Strategic advisors

Kent Graziano

The Data Warrior, Strategic Advisor, Data Vault Master, Author, Speaker, and Tae Kwon Do Grandmaster

Gordon Wong

Leading organizations through analytics transformations, preference for social missions, healthcare, energy, education, and civic engagement

See details

For cloud data platforms

SqlDBM offers secure native connectors to leading data platforms like Snowflake, Databricks, and BigQuery so you can reverse engineer and begin modeling in seconds.

Try modeling now

Try now

Greenlight’s modern data approach in biotech

  • Massachusetts, United States

#Cloud Migration

#500+ tables

About the company

Greenlight Biosciences is a biotechnology company headquartered in Medford, Massachusetts that specializes in RNA research. The data analytics management team recently decided to push full steam ahead into the cloud – replacing a legacy SQL Server data warehouse with Snowflake and adding a Synapse data lake.

To help speed up the migration and documentation process, Greenlight looked to replace their previous modeling tool – Erwin Data Modeler. It was an installable solution that didn’t afford the flexibility and convenience of the cloud. They needed a tool that would allow them to quickly iterate database designs and share them with the relevant stakeholders. That’s where SqlDBM comes in – Greenlight split the work across three teams – the architects, the data engineers, and the BI engineers – one of which designed the models, the other implemented the models, and the other referenced the models. 

How did SqlDBM help?

  • Accelerate a cloud migration from SQL Server to Snowflake
  • Establish a modeling framework from design to implementation
  • Save time by eliminating repetitive tasks and meetings through features like impact analysis and concurrent collaboration and communication.
  • Provide visibility throughout the database landscape - from source systems all the way to the datawarehouse(s)

Features used

Direct Snowflake connection

Deployments

Documentation

Lineage

DB Conversion

Suggested relationships

Automating a lift-and-shift migration

When GreenLight Biosciences decided to modernize its data landscape by migrating to the Snowflake Data Cloud, its first step was to look for a modeling tool that was intuitive and web-based, but still robust. SqlDBM ticked all those boxes by offering native support for both their SQL Server and Snowflake databases, allowing automated DDL conversion between the two.

SqlDBM’s project conversion feature saved GreenLight’s engineers weeks of labor by automatically converting their existing SQL Server model into Snowflake and achieving a 99% conversion success rate. Not only did SqlDBM accelerate the migration to Snowflake, it gave GreenLight’s team an all-in-one resource to scale future designs via an integrated data dictionary, version control, and a model deployment workflow. 

There was no modeling before SqlDBM. It kicked off our cloud modeling journey. In no time, we had a documented model to help our data / BI engineers.

Karthikeyan Shanthakumar, 
Senior Data Warehouse Architect

Establishing a new workflow

Following a successful migration, GreenLight’s data team continues to rely on SqlDBM to evolve their data model and leverage Snowflake’s cloud-native architecture to add value to the business. Through a visual design interface, the data team ensures accurate and consistent designs are generated every time. Automating repeatable and time-consuming tasks keeps the GreenLight’s team lean and focused on high-value work. They noted how Erwin’s many-step workflow prevented them from maximizing efficiency. “Everything took too long, and there were frequently errors. This kept us off the platform, and we instead iterated on our model in Excel until it was production-ready, before putting it in Erwin. With SqlDBM, the brainstorming and design is much, much faster.

Request Enterprise Trial

Request access

Maintain visibility and data discovery

Snowflake’s scalable architecture affords GreenLight’s data team the ability to keep tabs on all their data assets. But with that level of scale, comes a need for deliberate organization. Teams need to know what their database landscape consists of – that’s where SqlDBM comes in. Analysts and business users can now contribute to the same model – some use it to migrate databases, some use it to define and expand the business data model, some use it to troubleshoot a downstream data issue, and other use it to onboard new employees.

Request Enterprise Trial

Request access

Related content

Metcash Limited, one of Australia’s largest distribution and wholesale companies, sits at the center of a sprawling supply chain that spans food, liquor, and hardware. As the backbone behind thousands of retail stores and independent business partners…

Learn More

At Pie Insurance, growth isn’t just about policies – it’s about data. In the world of insurtech, data is the product. Every decision, from underwriting to claims management to new business expansion, depends on accurate, trusted, and accessible data everywhere…

Learn More

John Holland Group, one of the largest infrastructure construction firms in Australia with operations across New Zealand and Singapore, manages over 70 years of historical data. By 2023, the organization faced growing demand for advanced analytics, governance…

Learn More

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Resources

Strategic advisors

Kent Graziano

The Data Warrior, Strategic Advisor, Data Vault Master, Author, Speaker, and Tae Kwon Do Grandmaster

Gordon Wong

Leading organizations through analytics transformations, preference for social missions, healthcare, energy, education, and civic engagement

See details

For cloud data platforms

SqlDBM offers secure native connectors to leading data platforms like Snowflake, Databricks, and BigQuery so you can reverse engineer and begin modeling in seconds.

Try modeling now

Get Started

Platform

Data Modeling

Develop data models collaboratively in the cloud and share them with your organization in various modeling styles and formats with no coding or conversion required

See Pricing

Model Governance

Create and manage business metadata using a dedicated project role

Load More

Snowflake Schema Monitoring

Track and get notified of schema changes in live database environments

Load More

Integration

See all

Why SqlDBM?

Have questions?

Request a demo for more information

Book a demo