On a recent customer call (for Snowflake), the data architects were asking if Snowflake provided a data model diagramming tool to design and generate data warehouse tables or to view a data model of an existing Snowflake data warehouse. Or if we knew of any that would work with Snowflake.
Well, we do not provide one of our own – our service is the Snowflake Elastic Data Warehouse (#ElasticDW).
The good news is that there are data modeling tools in the broader ecosystem that you can of course use (since we are ANSI SQL compliant).
…
If you have read my previous posts on using JSON within the Snowflake, you also know that we have a new data type called VARIANT for storing semi structured data like JSON, AVRO, and XML.
In this post I will bring it together and show you the steps to customize SDDM to allow you to model and generate table DDL that contain columns that use the VARIANT data type.
Read the details of how I did it here on my Snowflake blog:
Snowflake SQL: Customizing Oracle Sql Developer Data Modeler (SDDM) to Support Snowflake VARIANT – Snowflake
Enjoy!
Kent
The Data Warrior
P.S. If you are in Austin, Texas this weekend, I will be speaking at Data Day Texas (#DDTX16). Snowflake will have a booth there too, so come on by and say howdy!
Posted in
Data Modeling,
Data Warehouse,
SnowflakeDB,
SQL Developer Data Modeler and tagged
#BetterDataModeling,
#SnowflakeDB,
#SQLDevModeler,
@SnowflakeDB,
data model design,
Data Modeling,
Data Warehouse,
data warehouse design,
data warehousing,
from the author of A Checklist for Doing Data Model Design Reviews,
Oracle SQL Developer Data Modeler |
The Data Warrior 
You must be logged in to post a comment.