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

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