Metabase 기반 고객 대시보드

Created
2025/04/12 06:32
Tags
Date

로컬 PoC 환경 구성

어플리케이션 및 DB 준비

version: '3.8' services: metabase: image: metabase/metabase:latest container_name: metabase ports: - "3000:3000" environment: - MB_DB_TYPE=postgres - MB_DB_DBNAME=metabase - MB_DB_PORT=5432 - MB_DB_USER=metabase - MB_DB_PASS=metabase123 - MB_DB_HOST=db depends_on: db: condition: service_healthy restart: unless-stopped db: image: postgres:14 container_name: metabase_db ports: - "5432:5432" environment: POSTGRES_DB: metabase POSTGRES_USER: metabase POSTGRES_PASSWORD: metabase123 volumes: - db_data:/var/lib/postgresql/data healthcheck: test: ["CMD-SHELL", "pg_isready -U metabase"] interval: 10s timeout: 5s retries: 5 restart: unless-stopped geojson_server: image: nginx:alpine container_name: geojson_server volumes: - ./maps:/usr/share/nginx/html:ro - ./nginx.conf:/etc/nginx/conf.d/default.conf:ro ports: - "8080:80" volumes: db_data:
Bash
복사

PoC 용 데이터베이스 준비

-- 1. 데모용 유저 생성 CREATE USER demo_user WITH PASSWORD 'demo123'; -- 2. 데모용 DB 생성 CREATE DATABASE demo_db OWNER demo_user; -- 3. 권한 부여 GRANT ALL PRIVILEGES ON DATABASE demo_db TO demo_user;
SQL
복사