Accessing the embedded H2 Database

When using the embedded H2 database (e.g. as part of a Snowflake/Snowpark deployment) it is possible to enable TCP and web access to the database.

Connecting via TCP

To Connect via TCP, the H2 TCP server needs to be enabled:

DMC_ENABLE_H2_SERVER=true

This will make the embedded database accept local TCP connections on port 9092 of the DMC application server.

To connect via TCP, the database path is required in addition to the hostname & port (localhost:9092).
This can be derived from the DMC_DB_JDBC_URL:

DMC_DB_JDBC_URL=jdbc:h2:file:./test/h2-db;INIT=CREATE SCHEMA IF NOT EXISTS dmc
# => ./test/h2-db
DMC_DB_JDBC_URL=jdbc:h2:mem:dmc;INIT=CREATE SCHEMA IF NOT EXISTS dmc
# => mem:dmc

Use the URL jdbc:h2:tcp://localhost:9092/<Database path> and the credentials configured for DMC (DMC_DB_USER / DMC_DB_PASSWORD) to connect to the H2 database via TCP.

Connecting via H2 Web Console

In addition to TCP access it is also possible to enable the H2 web console for DMC administrators.

DMC_ENABLE_H2_CONSOLE=true

The DMC web console is then accessible at https://your.dmc.com/h2-console