sqldbm.com Open in urlscan Pro
52.27.255.6  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Products
Products
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
Transformational modeling
Relational modeling and transformational automation working in harmony in a
single project
Learn more
Data Governance
Create and manage business metadata using a dedicated project role
Learn more
Snowflake Schema Monitoring
Track and get notified of schema changes in live database environments
Learn more
Integrations
See all
Why SqlDBM?
Security Integrations SqlDBM+dbt SqlDBM+Confluence SqlDBM+Jira Enterprise Plus
Have questions?
Request a demo for more information
Book a demo

Solutions
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.
Snowflake
Table options for transient and data retention and support for functions and
procedures are among the many integrations you can learn about here.
Databricks
Discover serverless direct connection through unity catalog API and support for
the latest unity features like constraints and metadata management using table
properties here.
BigQuery
See how we display nested struct columns and learn about extended object support
for views (standard and materialized) here.
Azure Synapse
Modernizing relational modeling for Azure Synapse with direct connect and native
object support
Amazon Redshift
Cloud native data modeling for Amazon Redshift.
Try modeling now
Get started

Resources
Resources
Customer stories Multimedia Changelog Blog Data Modeling academy REST API Help
center The book "Data Modeling with Snowflake" Events
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

Partners Pricing Enterprise Plus
Sign in Sign up
Sign in Sign up
Products
Products
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
Transformational modeling
Relational modeling and transformational automation working in harmony in a
single project
Learn more
Data Governance
Create and manage business metadata using a dedicated project role
Learn more
Snowflake Schema Monitoring
Track and get notified of schema changes in live database environments
Learn more
Integrations
See all
Why SqlDBM?
Security Integrations SqlDBM+dbt SqlDBM+Confluence SqlDBM+Jira Enterprise Plus
Have questions?
Request a demo for more information
Book a demo
Solutions
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.
Snowflake
Table options for transient and data retention and support for functions and
procedures are among the many integrations you can learn about here.
Databricks
Discover serverless direct connection through unity catalog API and support for
the latest unity features like constraints and metadata management using table
properties here.
BigQuery
See how we display nested struct columns and learn about extended object support
for views (standard and materialized) here.
Azure Synapse
Modernizing relational modeling for Azure Synapse with direct connect and native
object support
Amazon Redshift
Cloud native data modeling for Amazon Redshift.
Try modeling now
Get started
Resources
Customer stories Changelog Data Modeling academy Help center Events Multimedia
Blog REST API Strategic advisors The book "Data Modeling with Snowflake"
Partners Pricing Enterprise Plus
Sign in Sign up
Sign in Sign up
New Global Modeling


ENTERPRISE READY DATA MODELING


CLOUD-BASED AND COLLABORATIVE

Try modeling Book a demo




POWERING MODERN FRAMEWORKS
AND METHODOLOGIES

Data warehouse & data lake

Data mesh framework

Data vault methodology

Latest Snowflake features
Support for the latest features like Snowflake’s VARIANT datatype for
semistructured data, views, and column lineage allows users to go beyond pure
relational modeling.
Model and present
SqlDBM diagrams are living interactive documents that allow users to present
their designs in real-time at any level of detail - from conceptual to physical
- and generate the DDL, alters and YAML.
Views, functions and procedures
In our diagrams, objects such as views and procedures can live alongside
physical tables to provide insight into data pipelines and transformations at
the heart of a data warehouse.
Subject areas
Distributed teams can happily share the same database platform and organize
themselves across projects using subject areas - keeping their diagrams separate
while having global enterprise visibility. Comments and metadata is picked up
automatically during the reverse engineering process and can be maintained via
Excel by anyone in the organization.
Multiple projects and database platforms
Zhamak Dehghani first introduced the concept of a data mesh to overcome the
ungovernability of data lakes and the bottlenecks of monolithic data warehouses.
But distributed data teams can still take advantage of SqlDBM’s one-stop
documentation and search across multiple projects and database platforms.
A sponsor of the WWDVC
SqlDBM is a strong supporter of the data vault community, a sponsor of the WWDVC
conference two years running, and the modeling tool of choice during official
data vault courses.
Hubs, links, satellites
SqlDBM’s templates, naming conventions, and logical to physical translations are
built to ensure consistency and time savings in repeatable operations such as
the creation of hubs, links, satellites, and bridge tables.
Colors and view modes
Colors and view mode options make it easy for users to find their way around
expansive DV architectures and work with them at any level of detail. Automated
DV templates and an object creation wizard are currently in the works and will
be available soon, along with other exciting enhancements.

PREMIER PARTNER

FIND US ON THE SNOWFLAKE PARTNER CONNECT

In 2019, SqlDBM became the first online modeling tool to support Snowflake
projects and has continued to add support for Snowflake's latest objects, such
as views, functions, and procedures. The ability to natively modify, track,
reverse/forward engineer Snowflake objects, and display them on a diagram is why
over 300 Snowflake clients use SqlDBM.


CONNECT YOUR FAVORITE TOOLS

Integration with web apps, git repositories, and databases through secure native
connectors.

Get started Learn more


STRATEGIC ADVISORS

Meet the experts and industry thought-leaders helping shape the future of SqlDBM
Kent Graziano
The Data Warrior, Strategic Advisor, Data Vault Master, Author, Speaker, and Tae
Kwon Do Grandmaster
See details
Gordon Wong
Leading organizations through analytics transformations, preference for social
missions, healthcare, energy, education, and civic engagement
See details


THE BOOK “DATA MODELING WITH SNOWFLAKE”

by Serge Gershkovich  (Author), Kent Graziano  (Foreword)

Find book on Amazon

This book will help you get familiar with simple and practical data modeling
frameworks that accelerate agile design and evolve with the project from concept
to code.These universal principles have helped guide database design for
decades, and this book pairs them with unique Snowflake-native objects and
examples like never before — giving you a two-for-one crash course in theory
as well as direct application... Find out more


EVERYTHING YOU NEED AT YOUR FINGERTIPS

Database Modeling Direct connection Lineage analysis Documentation and
governance Compare Collaboration Git and DataOps
By bringing your existing DB/DW to SqlDBM, you can automatically create a
database model that will provide powerful and effective visualization. Make
changes and generate new SQL scripts including alter scripts.
Securely connect to cloud databases such as Snowflake and Azure Synapse directly
from SqlDBM to browse schemas and retrieve DDL automatically.
Visualize sources, joins, transformations, and outputs in real-time at column
level to understand complex views and DML logic quickly. Syntax to column
highlighting in the editor and diagram allows users to track any field as it
flows from the sources to final output.
Comments are read from DDL and available on a single screen where users can find
and edit objects across the entire project. Flags help identify sensitive fields
and can be used for tracking and filtering at the object or column level.
With unlimited revision history for every project, users can compare changes
between any two save points and open and recover a project from a previous
state. Users can instantly find any revision using labels, icons, and related
filters.
Work concurrently and comment on any object tagging and alerting specific team
members. View modes allow users of any technical level to view, explore, or
develop a DB schema without converting the project.
Compare project revisions to live DB environments and generate ad-hoc alter
scripts between them. Pair your project with any online git repository to
automatically push alters or individual objects to new branches and pair with
CICD tools like Schemachange or Flyway for fully automated deployments.
Get started


DATA MANAGEMENT PARTNER

FIND US ON THE AZURE MARKETPLACE

SqlDBM supports Azure Synapse modeling with extended support for views,
functions, procedures, and more. Using SqlDBM's virtual suggested relationships
feature, Synapse customers can relationally link and explore their entire
landscape without using foreign keys.


DEVELOPED FOR IT TEAMS

BI architects & consultants DB developers Project managers
SqlDBM helps develop or transition to leading cloud data warehouses, including
Snowflake, Synapse, and Redshift. Whether migrating an existing enterprise data
warehouse, data lake, or building one from scratch, SqlDBM's functionality is
designed to meet the needs of BI professionals by providing users with
cutting-edge capabilities.
An intuitive web-based interface lowers the technical barrier and lets all team
members take advantage of data discovery and explore the data landscape.

From exploring business entities in a simplified conceptual view to flagging
sensitive or critical fields and objects, all roles get to take advantage or
contribute to project metadata without using SQL.
Like modeling in SqlDBM, change tracking and revision comparison is a simple,
visual process that requires no prior knowledge of git. With Jira integration,
project managers can tie model changes to Jira tasks for full audit history and
synchronized comment thread.
Get started Learn more
Get started Learn more
Get started Learn more


ENTERPRISE PLAN

SqlDBM's Enterprise plan allows users to go beyond modeling by offering
integrations like Confluence for sharing and Jira for task management.
Enterprise also unlocks team communication, alerts, and governance as well as
time-saving features like view-column lineage and suggested relationships.
Natively connect SqlDBM to web service apps and database providers through
secure single sign-on protocols.
Contact sales

MULTIMEDIA

Learn more

SECURITY

Learn more Security documentation

GOOGLE CLOUD PARTNER

FIND US ON THE PARTNER DIRECTORY

SqlDBM lets you diagram your entire database without writing a single line of
code. SqlDBM supports modeling and design for AlloyDB database. Native SQL
integration through direct connect or file upload can reverse engineer database
landscapes in seconds, so you can begin to design, communicate, and collaborate
with your team.




CUSTOMER STORIES

Hundreds of organizations worldwide use SqlDBM for enterprise modeling because
it saves time, ensures consistent, error-free deployments, and integrates easily
with the rest of the modern BI stack. Read about where our customers are finding
success with SqlDBM and how they've come to depend on it for modeling, DevOps,
and data discovery.
All stories

“I worked with a variety of modeling tools over my career and there's a whole
gamut of features that have their audiences in certain communities, but I think
what SqlDBM has is a very practical collection of features and functionality.”
David Sipos,
Director of Data Infrastructure, Higginbotham

“Pandata Group has assisted many customers in their pursuit of digital
transformation through effective data management. Our evolution towards pure
cloud solutions such as Snowflake and Thoughtspot reflects the growth of the
SaaS approach to data and analytics platforms. We have increased time-to-value
by deploying zero-management solutions that support cloud DW and analytics (e.g.
Matillion ETL).”
Joseph Caparula,
Senior Consultant, Pandata Group

“There’s ambiguity in any organization. Exposing the data model, the data
dictionary, and definitions from a single place to business analysts and the
rest of the organization helps everyone stay aligned.”
Justin Lane,
Data Modeler, Data Governance Manager, Safety Culture


TRUSTED
AROUND THE WORLD

300,000+ users and still growing


TRY MODELING NOW

Get started


Copyright @SqlDBM

INFO

Pricing Enterprise Plus Partners Changelog Status page Terms and conditions
Privacy policy Trust center

WHY SQLDBM?

BI architects & consultants DB developers Project managers Security Integrations
SqlDBM+Snowflake SqlDBM+dbt SqlDBM+Confluence SqlDBM+Jira SqlDBM+Databricks
SqlDBM+BigQuery SqlDBM+Azure Synapse SqlDBM+Amazon Redshift Snowflake Schema
Monitoring Data Governance Global Modeling Logical Modeling Transformational
Modeling REST API

RESOURCES

Customer stories Multimedia Strategic advisors Accessibility Support Contact us
Blog Help center Data Modeling academy Events The book "Data Modeling
with Snowflake"




Cookies help personalize and improve the site experience. By using this website,
you agree to our use of cookies.
Learn more Accept all cookies


COOKIES POLICY

Our site uses cookies to support its functionality and personalize the user
experience. The following types of cookies are used:
Allow all
Strictly necessary
These cookies are required for the site to function correctly. Strictly
necessary cookies store temporary session information, which only includes the
minimum required information to support site features.
Functional
Functional cookies store information to enhance the user experience on a website
by personalizing it to the user's locale or language. These cookies are
anonymous and do not store any information about browsing activity on other
websites.
Marketing
These persistent cookies track user web activity to promote targeted
advertisements through trusted third-party providers. They are used to inform
marketing efforts for ourselves and our partners.
Confirm my choices Terms of service