1> Google OAuth
* 사용자 인증 정보에서 웹 애플리케이션의 클라이언트 생성
- 승인된 리디렉션 URI를 '{도메인}/oauth/google_callback’ 로 추가
2> Redash 의 Settings - General 설정
- Password Login 체크 해제
- Google Login 허용 도메인 등록 ( 이메일 도메인으로 지정하여 도메인을 검수 )
3> Redash 의 env 파일 수정
REDASH_GOOGLE_CLIENT_ID, REDASH_GOOGLE_CLIENT_SECRET 추가
https://redash.io/help/open-source/setup#docker
Setting up a Redash Instance
Create an Instance For basic deployments we recommend a minimum of 2GB of RAM and reasonable amount of CPU allocation. As usage grows you might need additional RAM and CPU power to support increased number of background workers and API processes. To create
redash.io
https://github.com/getredash/setup/tree/master/data
getredash/setup
Setup scripts for Redash Cloud Images. Contribute to getredash/setup development by creating an account on GitHub.
github.com
Ubuntu에서 ReDash 세팅 및 사용방법
Data Visualization Tool ReDash 에 대하여 세팅 및 사용방법을 스터디한다.
medium.com
https://open-but-closed.com/remake-redash-docker-images/
Redash Docker로 이미지 생성
결국 Redash는 docker버전으로 관리하기로 했다. 또 내부망 서버에는 인터넷이 제한적인 환경이라 docker로 관리하는 부분이 더 맞을듯. 외부에서 모든 셋업을 마치고 docker image를 만들어서 내부의 docker에 설치해보려고 하다.
open-but-closed.com
* docker-compose.yml
version: "2"
x-redash-service: &redash-service
image: redash/redash:8.0.0.b32245
depends_on:
- postgres
- redis
env_file: /Users/a202001035/Store/Workspace/dp/redash/env
restart: always
services:
server:
<<: *redash-service
command: server
ports:
- "5000:5000"
environment:
REDASH_WEB_WORKERS: 4
scheduler:
<<: *redash-service
command: scheduler
environment:
QUEUES: "celery"
WORKERS_COUNT: 1
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:5.0-alpine
restart: always
postgres:
image: postgres:9.6-alpine
env_file: /Users/a202001035/Store/Workspace/dp/redash/env
volumes:
- /Users/a202001035/Store/Workspace/dp/redash/postgres-data:/var/lib/postgresql/data
restart: always
nginx:
image: redash/nginx:latest
ports:
- "80:80"
depends_on:
- server
links:
- server:redash
restart: always
* env
PYTHONUNBUFFERED=0
REDASH_LOG_LEVEL=INFO
REDASH_REDIS_URL=redis://redis:6379/0
POSTGRES_PASSWORD=HMw81S
REDASH_COOKIE_SECRET=sCJK
REDASH_SECRET_KEY=aa0xO
REDASH_DATABASE_URL=postgresql://postgres:HMKJWk@postgres/postgres
https://redash.io/help/user-guide/querying/query-filters
Query Filters
Query Filters let you interactively reduce the amount of data shown in your visualizations, similar to Query Parameters but with a few key differences. Query Filters limit data after it has been loaded into your browser. This makes them ideal for smaller d
redash.io
https://redash.io/help/open-source/admin-guide/ldap-authentication
LDAP/AD Authentication
Starting from Redash v3, there is direct support for LDAP/AD authentication. To set it up you will need to install the ldap3 Python package (version 2.2.4, GPL licensed) and add the relevant configuration values (see below). Once you done both, you need to
redash.io
https://pypi.org/project/redash-iodide/
redash-iodide
Extensions to Redash by Mozilla
pypi.org
https://redash.io/help/data-sources/setup/json
JSON & URL APIs
Sometimes you need to visualize data not contained in an RDBMS or NOSQL data store, but available from some HTTP API. For those times, Redash provides the JSON data source (first introduced in Redash v8). Redash treats all incoming data from the JSON data
redash.io
https://redash.io/help/open-source/dev-guide/debugging
Debugging a Redash Server on Docker Using Visual Studio Code
If you’ve followed Docker Based Developer Installation Guide, your Redash server is running inside a Docker container and cannot be debugged directly. If you wish to debug server code, you will need to use remote debugging. Initial Setup Make sure you have
redash.io
* AWS ECS
https://github.com/ikazoy/redash-on-ecs
ikazoy/redash-on-ecs
This repository has setting files to host redash and redash bot on AWS. You could launch Redash ready for production within 5 minutes. - ikazoy/redash-on-ecs
github.com
https://www.ehfeng.com/redash-python-functions/
Redash Python functions
We’ve been using Redash at Sentry lately. I’d never heard of it before (Mode being the frontrunner in this category), but it’s damned good so far. And before...
www.ehfeng.com