Redash
Connect to any data source, write queries with a powerful SQL editor, and build dashboards. Visualize your data and share insights easily with your team.
Connect to a wide variety of data sources to answer complex questions. This tool provides a collaborative, cloud-based service with the power of a traditional SQL client, allowing you to make sense of your data and foster a data-driven culture within your company.
Write queries effectively using a powerful online SQL editor. You can easily browse your database schema, click to insert elements, and reuse common queries by creating snippets. This combines the comfort of a familiar client with the collaborative advantages of a cloud service.
Create compelling visualizations and assemble them into dashboards. With a drag-and-drop interface, you can arrange and resize any chart or graph to present a clear, easy-to-digest picture for better decision-making. Dashboards can be scheduled to automatically refresh from your data sources and shared with your team or publicly.
Key features include:
- Connect to SQL, NoSQL, Big Data, and API data sources.
- An online SQL editor with schema browser and snippets.
- Drag-and-drop dashboard creation.
- Scheduled data refreshes and sharing options.
- Alerts to notify you of data changes.
- Comprehensive user management.
Directory Structure
docker-compose.yml
services:
server:
image: redash/redash:10.1.0.b50633
command: server
ports:
- "5000:5000"
environment:
PYTHONUNBUFFERED: 0
REDASH_LOG_LEVEL: "INFO"
REDASH_REDIS_URL: "redis://redis:6379/0"
REDASH_DATABASE_URL: "postgresql://postgres:${POSTGRES_PASSWORD}@postgres/postgres"
REDASH_COOKIE_SECRET: "${REDASH_COOKIE_SECRET}"
REDASH_SECRET_KEY: "${REDASH_SECRET_KEY}"
REDASH_WEB_WORKERS: 4
depends_on:
- postgres
- redis
restart: always
scheduler:
image: redash/redash:10.1.0.b50633
command: scheduler
environment:
PYTHONUNBUFFERED: 0
REDASH_LOG_LEVEL: "INFO"
REDASH_REDIS_URL: "redis://redis:6379/0"
REDASH_DATABASE_URL: "postgresql://postgres:${POSTGRES_PASSWORD}@postgres/postgres"
REDASH_COOKIE_SECRET: "${REDASH_COOKIE_SECRET}"
REDASH_SECRET_KEY: "${REDASH_SECRET_KEY}"
depends_on:
- server
restart: always
scheduled_worker:
image: redash/redash:10.1.0.b50633
command: worker
environment:
PYTHONUNBUFFERED: 0
REDASH_LOG_LEVEL: "INFO"
REDASH_REDIS_URL: "redis://redis:6379/0"
REDASH_DATABASE_URL: "postgresql://postgres:${POSTGRES_PASSWORD}@postgres/postgres"
REDASH_COOKIE_SECRET: "${REDASH_COOKIE_SECRET}"
REDASH_SECRET_KEY: "${REDASH_SECRET_KEY}"
QUEUES: "scheduled_queries,schemas"
WORKERS_COUNT: 1
depends_on:
- server
restart: always
adhoc_worker:
image: redash/redash:10.1.0.b50633
command: worker
environment:
PYTHONUNBUFFERED: 0
REDASH_LOG_LEVEL: "INFO"
REDASH_REDIS_URL: "redis://redis:6379/0"
REDASH_DATABASE_URL: "postgresql://postgres:${POSTGRES_PASSWORD}@postgres/postgres"
REDASH_COOKIE_SECRET: "${REDASH_COOKIE_SECRET}"
REDASH_SECRET_KEY: "${REDASH_SECRET_KEY}"
QUEUES: "queries"
WORKERS_COUNT: 2
depends_on:
- server
restart: always
redis:
image: redis:5.0-alpine
restart: always
postgres:
image: postgres:9.6-alpine
environment:
POSTGRES_PASSWORD: "${POSTGRES_PASSWORD}"
volumes:
- ./postgres-data:/var/lib/postgresql/data
restart: always.env
REDASH_COOKIE_SECRET=replace_with_a_secure_random_string
REDASH_SECRET_KEY=replace_with_another_secure_random_string
POSTGRES_PASSWORD=secure_postgres_passwordTags:
Similar to Redash