DbSchema is a Snowflake ER diagram database designer and query tool. Using DbSchema, you can design and document Snowflake databases while connected to the database server or without a connection.
Next, you can share the design with the team using Git. The design model loaded in DbSchema can be compared with the database, synchronization scripts can be generated, and the schema can be deployed to any database server.
Watch the step-by-step video tutorial below:
For written documentation, please continue reading...
Open DbSchema, then click "Connect to Database" on the Main Screen and choose your database system. DbSchema will automatically download the required JDBC driver.
In DbSchema's connection dialog, you can choose "Standard" for a simplified setup, or "Edit Manually" to customize the JDBC URL.
To connect DbSchema to your Snowflake database, begin by obtaining your account URL from the Snowflake Console , as shown below
If you choose the "Standard" connection option:
jdbc:snowflake:// your_account_URL ?client_metadata_request_use_connection_ctx=true
If you need more detailed connection information, read the Connection Dialog
If you experience connection problems, check your firewall and antivirus settings, as they might be blocking the connection. More information on enabling Firewall Connections is available if needed.
If you encounter connection errors, enable logging for diagnostics by following the instructions here.