Set up an air-gapped environment (no HTTP proxy available)

Normally, Datalore can't operate without downloading the JDBC drivers from some outside source. However, you can build your own SQL runtime image with pre-downloaded images.

Set up a fully air-gapped environment (no HTTP proxy available)

For JDBC drivers, apply one of the options available here.
Use the following syntax formats: {artifact name} or {artifact name}:{version}.
PostgreSQL and Redshift driver versions are listed under <artifact id="PostgreSQL 2" name="PostgreSQL 2"> and <artifact id="Redshift 2" name="Redshift 2"/> respectively.
Make sure you specify the actual version ID (for example, "42.3.3"), not the section name ("PostgreSQL 2).
Specify the custom image in the datalore.values.yaml file as shown in the example below.
The DATABASES_COMMAND_IMAGE environment variable is overridden after the above-mentioned image is built.

Examples

Dockerfile

FROM jetbrains/datalore-database-command:2023.6
RUN ["/opt/datalore/download_artifacts.sh", "'MySQL Connector/J 8'"]
RUN ["/opt/datalore/download_artifacts.sh", "'Redshift:2.0.0.7'"]
RUN ["/opt/datalore/download_artifacts.sh", "'PostgreSQL:42.3.3'"]

Datalore config files

docker-compose.yaml

services:
 datalore:
   image: jetbrains/datalore-server:2023.6
   ports:
     - "8080:8080"
   expose: [ "8081", "5050", "4060" ]
   networks:
     - datalore-agents-network
     - datalore-backend-network
   volumes:
     - "datalore-storage:/opt/data"
     - "/var/run/docker.sock:/var/run/docker.sock"
   environment:
     #DATALORE_PUBLIC_URL: "https://datalore.example.com"
     DB_PASSWORD: "changeme"
     DATABASES_DOCKER_NETWORK: "datalore-agents-network"
     , , 
     DATABASES_COMMAND_IMAGE: "datalore-db-command-custom:latest"

datalore.values.yaml

dataloreEnv:
  DATABASES_COMMAND_IMAGE: "datalore-db-command-custom:latest"

agentsConfig:
	....

databaseSecret:
  password: "password"

Known limitations

If the clients’ browser is also running in a fully air-gapped environment, the Visualization tab in a rendered DataFrame will not work due to this functionality reliance on the public CDN availability, which is not possible in an air-gapped environment.

Last modified: 08 January 2024