redash (in win)

https://redash.io/help/open-source/setup/

로컬에 redash를 설치해 보자.

개발회의에 BI 이야기가 나와서 살짝 경험을 설명해 봄.

우선, 기존에 로컬 노트북에 docker desktop은 설치된 상태이다 (win11)

1. redash docker compose yml

version: '2.2'
x-redash-service: &redash-service
  image: redash/redash:10.1.0.b50633
  depends_on:
    - postgres
    - redis
  env_file:
    - .env
  restart: always
services:
  server:
    <<: *redash-service
    command: server
    ports:
      - "5000:5000"
    environment:
      REDASH_WEB_WORKERS: 4
  scheduler:
    <<: *redash-service
    command: scheduler
  scheduled_worker:
    <<: *redash-service
    command: worker
    environment:
      QUEUES: "scheduled_queries,schemas"
      WORKERS_COUNT: 1
  adhoc_worker:
    <<: *redash-service
    command: worker
    environment:
      QUEUES: "queries"
      WORKERS_COUNT: 2
  redis:
    image: redis:7-alpine
    restart: always
  postgres:
    image: postgres:12-alpine
    env_file:
      - .env
    volumes:
      - postgres-data:/var/lib/postgresql/data
    restart: always
  nginx:
    image: redash/nginx:latest
    ports:
      - "80:80"
    depends_on:
      - server
    links:
      - server:redash
    restart: always
volumes:
  postgres-data:

2. .env 생성
   명령은 powershell 에서 실행.

@"
PYTHONUNBUFFERED=0
REDASH_LOG_LEVEL=INFO
REDASH_REDIS_URL=redis://redis:6379/0
POSTGRES_PASSWORD=redash_password
REDASH_DATABASE_URL=postgresql://postgres:redash_password@postgres/postgres
REDASH_COOKIE_SECRET=$(-join ((65..90) + (97..122) + (48..57) | Get-Random -Count 32 | ForEach-Object {[char]$_}))
REDASH_SECRET_KEY=$(-join ((65..90) + (97..122) + (48..57) | Get-Random -Count 32 | ForEach-Object {[char]$_}))
"@ | Out-File -FilePath .env -Encoding ASCII

3. docker 실행

docker-compose up -d

4. DB 생성 및 빌드

ocker-compose run --rm server create_db

5. 확인 (http://localhost)