superset_report_create
Create scheduled reports delivering dashboard or chart screenshots via email, or set up SQL-based alerts that trigger notifications when conditions are met.
Instructions
Create a report (periodic delivery) or alert (SQL-condition based).
For Report: specify dashboard or chart — Superset will send a screenshot on schedule. For Alert: specify database and sql — Superset checks the condition and notifies on trigger.
Args: name: Report/alert name. crontab: Cron schedule. Examples: - "0 9 * * *" — every day at 9:00 - "0 9 * * 1" — every Monday at 9:00 - "0 */6 * * *" — every 6 hours report_type: Type: "Report" (periodic delivery, default) or "Alert" (condition-based). dashboard: Dashboard ID for screenshot (for Report). chart: Chart ID for screenshot (for Report). database: Database connection ID (for Alert — SQL condition). sql: SQL query for condition check (for Alert). The alert triggers when the query returns a non-empty result. recipients: JSON string with recipient list. Format: [{"type": "Email", "recipient_config_json": {"target": "user@example.com"}}] active: Whether active (default True).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | ||
| name | Yes | ||
| chart | No | ||
| active | No | ||
| crontab | Yes | ||
| database | No | ||
| dashboard | No | ||
| recipients | No | ||
| report_type | No | Report |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |