Tried to reverse engineer a snowflake database and noticed that all the Varchar fields were identified as "Text" Fields after the reverse Engineer step completed.
See below for a sample -
---- ER/Studio Data Architect SQL Code Generation-- Project : DATA MODEL---- Date Created : Monday, May 24, 2021 14:42:35-- Target DBMS : Snowflake--
CREATE TABLE PUBLIC.BILL_STMT_LOAN_PPR( FDR_LOAD_DT DATE NOT NULL, BILL_SUM_BORR_CIN TEXT(10) NOT NULL, BILL_SUM_FDR_ACCT_NBR TEXT(16) NOT NULL,
Should be -
Powered by IDERA