git clone https://github.com/apache/superset.git
cd superset

docker-compose up -d

# 访问 http://localhost:8088

docker-compose exec superset superset db upgrade
docker-compose exec superset superset fab create-admin \
  --username admin --firstname Admin --lastname User --email admin@example.com \
  --password admin
docker-compose exec superset superset init
docker-compose restart superset

docker pull apache/superset:latest

docker run -d -p 8088:8088 \
  -e "SUPERSET_SECRET_KEY=your-secret-key" \
  --name superset \
  apache/superset

python3 -m venv superset-env
source superset-env/bin/activate

pip install apache-superset

superset db upgrade

export FLASK_APP=superset
superset fab create-admin
superset init          # 初始化自带角色与默认权限

# 可选：加载示例数据，方便看效果
superset load_examples

superset run -p 8088 --with-threads --reload --debugger

SELECT
    d.department,
    DATE_TRUNC('month', o.order_date) AS month,
    COUNT(DISTINCT c.customer_id) AS customers,
    SUM(o.amount) AS revenue,
    AVG(o.amount) AS avg_order_value
FROM orders o
JOIN customers c ON o.customer_id = c.id
JOIN departments d ON c.dept_id = d.id
WHERE o.order_date >= '2025-01-01'
GROUP BY d.department, DATE_TRUNC('month', o.order_date)
ORDER BY month DESC

# superset_config.py
from superset.security.manager import SupersetSecurityManager

class CustomSecurityManager(SupersetSecurityManager):
    def get_schemas_accessible_by_user(self, user, database):
        # 返回该用户可访问的 schema 列表
        return ['public', 'analytics']

{
  "encoding": {
    "x": {
      "field": "order_date",
      "type": "temporal",
      "axis": { "format": "%Y-%m" }
    },
    "y": {
      "field": "revenue",
      "type": "quantitative",
      "aggregate": "sum"
    }
  },
  "mark": { "type": "line", "color": "#1DA1F2", "strokeWidth": 2 }
}

CACHE_CONFIG = {
    'CACHE_TYPE': 'redis',
    'CACHE_REDIS_HOST': 'localhost',
    'CACHE_REDIS_PORT': 6379,
    'CACHE_DEFAULT_TIMEOUT': 300,   # 5 分钟
    'CACHE_KEY_PREFIX': 'superset_',
}

VIZ_CACHE_TIMEOUT = 300   # 图表缓存
SQL_CACHE_TIMEOUT = 300   # 查询缓存

pip install psycopg2-binary
# Database: postgresql://username:password@host:5432/dbname

pip install pybigquery
export GOOGLE_APPLICATION_CREDENTIALS="/path/to/key.json"
# SQLAlchemy URI: bigquery://project-id/dataset

SELECT
    u.id AS user_id,
    u.name AS user_name,
    COUNT(o.id) AS order_count,
    SUM(o.amount) AS total_spent
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE o.created_at >= '2025-01-01'
GROUP BY u.id, u.name

from flask_appbuilder.security.manager import AUTH_OAUTH

AUTH_TYPE = AUTH_OAUTH

OAUTH_PROVIDERS = [
    {
        'name': 'google',
        'icon': 'fa-google',
        'token_key': 'access_token',
        'remote_app': {
            'client_id': 'YOUR_CLIENT_ID',
            'client_secret': 'YOUR_CLIENT_SECRET',
            'server_metadata_url': 'https://accounts.google.com/.well-known/openid-configuration',
            'client_kwargs': {'scope': ['openid', 'email', 'profile']},
        },
    }
]

services:
  superset:
    image: apache/superset:latest
    ports:
      - "8088:8088"
    environment:
      SUPERSET_SECRET_KEY: ${SECRET_KEY}
      DATABASE_URL: postgresql://user:pass@db:5432/superset
    depends_on:
      - db
      - redis
  db:
    image: postgres:14
    environment:
      POSTGRES_DB: superset
      POSTGRES_USER: user
      POSTGRES_PASSWORD: pass
  redis:
    image: redis:7-alpine

helm repo add superset https://apache.github.io/superset
helm install superset superset/superset \
  --set secretKey=${SECRET_KEY} \
  --set databaseUrl=${DATABASE_URL}

# superset_config.py
CELERY_CONFIG = {
    'broker_url': 'redis://redis:6379/0',
    'result_backend': 'redis://redis:6379/1',
}

SUPERSET_WORKERS = 4

SQLLAB_ASYNC_TIME_LIMIT_SEC = 300   # SQL Lab 异步查询超时
VIZ_CACHE_MAXAGE = 3600             # 图表缓存上限，1 小时

// src/plugin/index.ts
import { ChartPlugin } from '@superset-ui/core';
import ControlPanel from './controlPanel';
import transformProps from './transformProps';

export default class CustomVizPlugin extends ChartPlugin {
  constructor() {
    super({
      loadChart: () => import('./CustomChart'),
      controlPanel: ControlPanel,
      transformProps,
      metadata: {
        name: 'Custom Chart',
        description: 'A custom visualization',
        credits: ['My Company'],
      },
    });
  }
}

// superset-frontend/src/preamble.ts
import { configure } from '@superset-ui/core';
import CustomVizPlugin from './src/plugins/CustomViz';

configure([new CustomVizPlugin().configure()]);

SELECT *
FROM orders
WHERE region IN (SELECT region FROM user_region WHERE user_id = {{ current_user_id() }})

import { SupersetEmbedding } from '@superset-ui/embedded-sdk';

SupersetEmbedding({
  id: 'your-chart-id',
  supersetUrl: 'https://superset.example.com',
  guestToken: 'your-guest-token',
  mountPoint: document.getElementById('chart'),
});

pg_dump -U user -h host superset > superset_backup.sql
cp superset_config.py /path/to/backup/