Hot on the heels of Snowflake’s blockbuster IPO comes the Data Cloud Summit 2020. The event includes guidance and commentary from Snowflake’s executive team and presentations by more than 25 partners and industry experts. There is even a celebrity headliner, The Daily Show’s Trevor Noah.
This whole-day event consists of over forty sessions, broken up into eight subject areas. In case you couldn’t attend, this post will cover the highlights. We’ll see how Snowflake’s executive team plans to transform the platform using the Data Cloud. …
SqlDBM is an online, collaborative data modeling and diagramming tool. It is used by thousands of companies worldwide, providing them with clarity and efficiency in visualizing and developing their data models. While you can get an idea of how it achieves this by looking through the features and highlights on the SqlDBM website, walking through a practical use case could demonstrate its full potential.
Yew Inc. is a completely fictional yet, data-driven company. They have an on-premise enterprise database application that drives their business and a data warehouse to track their key performance metrics. Yew Inc. …
SAN DIEGO (PRWEB) JULY 09, 2020
SqlDBM, a cloud-native database modeling tool, today proudly announced expansion of its existing partnership with Snowflake, the cloud data platform. This new initiative will include a sequence of new Snowflake-related features added to SqlDBM along with a direct integration to Snowflake Partner Connect.
“It is essentially important to have a cloud-based and model-driven tool to visualize and manage data warehouse development lifecycle to make more informed and effective business decisions”
SqlDBM’s mission is to provide customers with native Snowflake support to develop a data warehouse without writing a single line of code. Now, Snowflake…
A view in Snowflake is defined as a virtual table that enables the result of a query to be accessed dynamically as if it were a table to tables. Unlike ordinary database tables in a relational database, a view does not form part of the physical schema.The query is specified in the CREATE VIEW statement
Views can provide the following benefits over tables:
Many organizations want to apply naming conventions for their database/ data warehouse models. It is especially important for among mid and large sized companies. Now SqlDBM supports this requirement. Naming conventions are in easy way to apply uniform corporate naming standards rules, and in SqlDBM include object names, abbreviations, lengths, and special characters. Learn more below to see what this feature includes:
You can define attribute names using naming rules:
SqlDBM (www.sqldbm.com), Online Database Modeling Tool, today announced that the company has successfully completed its SOC 2 Type I audit. SOC 2 engagements are based on the AICPA’s Trust Service Criteria. SOC 2 audit reports focus on a Service Organization’s non-financial reporting controls as they relate to Security, Availability, Confidentiality, Processing of a system. The audit was conducted by Dansa D’Arata Soucia LLP(www.darata.com). …
Carlsbad, CA — May 30, 2019 — SqlDBM (www.sqldbm.com), the Online Data Modeling Tool is proud to announce a strategic partnership with Snowflake, the only data warehouse built for the cloud, to design Snowflake data models and generate Snowflake based DDL scripts for tables, columns, relationships, schema properties, file format options, column constraints and more.
Data modeling is the process of documenting a complex software system design as an easily understood diagram, using text and symbols to represent the way data needs to flow. The diagram can be used as a blueprint for the construction of new software or for re-engineering a legacy application.
Data modelers often use multiple models to view the same data and ensure that all processes, entities, relationships and data flows have been identified. There are several different approaches to data modeling, including:
Conceptual Data Modeling — identifies the highest-level relationships between different entities.
Enterprise Data Modeling — similar to conceptual…
As we are entering 2020, we wanted to say thank you for being part of our community. With over 100 thousand users currently registered with SqlDBM, we’re humbled by the trust you place in us to help you build your Database & Data Warehouse projects.
Looking ahead, we’re committed to our mission of helping Database professionals succeed. With every improvement to SqlDBM, we aim to make data modeling easier so you can focus on building amazing solutions.
It’s been a productive year at SqlDBM. Let’s take a moment to reflect on some of the highlights from 2019:
⁃ Support for…
SqlDBM — Online Data Modeling Tool for Snowflake, Amazon Redshift, SQL Server, PostgreSQL & MySQL. SqlDBM offers an intuitive and smart data modeling solution.