docker-compose.yaml

version: "3"

services: 
  etl:
    image: etl
    container_name: etl
    build:
      context: .
    volumes:
      - ./:/app
    environment:
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      POSTGRES_DB: ${POSTGRES_DB}
      POSTGRES_HOST: ${POSTGRES_HOST}
      POSTGRES_PORT: ${POSTGRES_PORT}
      TABLE_NAME: ${TABLE_NAME}
      FILE_PATH: ${FILE_PATH}

  warehouse: 
    image: postgres:13
    container_name: warehouse
    environment: 
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      POSTGRES_DB: ${POSTGRES_DB}
    volumes: 
      - postgres-volume:/var/lib/postgresql/data
      - ./sql:/docker-entrypoint-initdb.d
    restart: always
    ports: 
      - "5432:5432"

  metabase:
    image: metabase/metabase:latest
    container_name: metabase
    hostname: metabase
    volumes:
    - urandom:/dev/random:ro
    ports:
      - 3000:3000
    restart: always

volumes:
  postgres-volume:
  urandom: