Run redash docker

Redash, superset, and metabase are both good data analysis tools that support multiple data sources and facilitate report generation.
Basically, the customized report interface and notification (timing) are supported. metabase is a bit of a product and is used on superset.
Incubated in Apache

Run the test using docker compose

Environment preparation

• Docker compose File

version: ‘2‘services:  server:    image: redash/redash:latest    command: server    depends_on:      - postgres      - redis    ports:      - "5000:5000"    environment:      PYTHONUNBUFFERED: 0      REDASH_LOG_LEVEL: "INFO"      REDASH_REDIS_URL: "redis://redis:6379/0"      REDASH_DATABASE_URL: "postgresql://[email protected]/postgres"      REDASH_COOKIE_SECRET: veryverysecret      REDASH_WEB_WORKERS: 4  worker:    image: redash/redash:latest    command: scheduler    environment:      PYTHONUNBUFFERED: 0      REDASH_LOG_LEVEL: "INFO"      REDASH_REDIS_URL: "redis://redis:6379/0"      REDASH_DATABASE_URL: "postgresql://[email protected]/postgres"      QUEUES: "queries,scheduled_queries,celery"      WORKERS_COUNT: 2  redis:    image: redis:3.0-alpine  mongodb:    image: mongo:3.2    ports:    - "27017:27017"  click:     image: yandex/clickhouse-server     ports:     - "8123:8123"     - "9000:9000"     - "9009:9009"     ulimits:      nproc: 65535      nofile:       soft: 262144       hard: 262144  postgres:    image: postgres:9.5.6-alpine    ports:    - "5432:5432"    # volumes:    # - /opt/postgres-data:/var/lib/postgresql/data  nginx:    image: redash/nginx:latest    ports:      - "80:80"    depends_on:      - server    links:      - server:redash

• Start

docker-compose up -d

• Initialize system data (PG database)

docker-compose run --rm server create_db

• Effect
  
  

Configuration

• System Configuration
  Relatively simple. Just follow the prompts.
• Add Data Source
  
  I configured the PostgreSQL database used by the system.
  
• Create Query
  
  
• Add chart
  
  
• Add dashboard
  
  
• Add notification Template
  It is very convenient to support emails, webhook, and some common communication tools.
  

Description

Redash is easy to use, supports a large number of charts, and supports a large number of data models. The official documents are okay and clear.

References

Https://github.com/getredash/redash
Https://github.com/rongfengliang/redash-docker-compose

Run redash docker