How to connect to Snowflake using Oracle SQL developer Data Modeler ?

- Go to preferences in Data modeler and Click Data Modeler
- Click on Third party jdbc tools and add snowflake_jdbc.jar file
- Go to file -> import -> Data dictionary
- Now add data base connection
- Give connection name, your snowflake user name and password
- Click JDBC tab – > provide jdbcurl and driver class
- Click Test button and save the connection
- Go to connection and click next
- Select tables/objects and click next
- Import is completed and click Finish
- You see the ER diagram in the designer now and you can reverse engineer the new tables when required.