Oracle SQL Developer Data Modeler (SDDM) - Working With Snowflake DW, Settings to remember - Part 1
In this video, I'm trying to put all the settings as I remember based on my experience in modeling the DW on Snowflake DW. While 80% of the DDLs should be supported by Snowflake DW, for many you may face errors like when the SDDM creates the CREATE TABLE statement it creates a LOGGING clause to the end of the CREATE TABLE DDL. This creates an error while deploying the script to SnowFlake. These settings also aid you in performing two-way modeling i.e. Forward and Reverse engineering your data models.