JDBC

Overview

The JDBC analytics connection is read-only and intended for analytics applications and is not low latency. It should not be considered a substitute for the client api for programmatic access to Datomic.

Presto JDBC Driver

To use analytics support from JDBC, add the Presto JDBC Driver to your classpath. For applications, add this dependency to your maven XML:

<dependency>
    <groupId>io.prestosql</groupId>
    <artifactId>presto-jdbc</artifactId>
    <version>316</version>
</dependency>

If you are using a tool such as DBeaver, speciy version 316 of the driver.

Connecting

You can connect to a running analytics service via JDBC using the URI format:

jdbc:presto://<host>:<port>/<catalog>/<schema>?user=<user>

Replacing <host>, <port>, <catalog>, <schema>, and <user> as appropriate for your analytics system:

  • host and port are the host and port of your access gateway
  • catalog is the name of your catalog
  • schema is the name of your Datomic database
  • user it not currently used, but some tools may require that you specify it

For catalog and schema, keep in mind the naming conventions.