Reports as code: SQL and YAML in git, built into Excel, CSV, fixed-width, PDF or HTML files and delivered to email, SFTP, S3, Databricks or Slack, plus headline messages to Slack, Teams and Google Chat. The dbt-style workflow, for reporting.
https://getdre.com โ// readme
DRE
DRE, the Declarative Reporting Engine, is open-source reports as code. You keep each report
as .sql and YAML files in git; DRE runs the SQL against your databases (each tab of a workbook can
come from a different one, and tables can be declared as dbt-style sources), writes the result as
csv, delimited, fixed-width, parquet or xlsx (including multi-sheet workbooks, number formats,
formulas and totals rows, and branded Excel templates), or as html or pdf documents from an HTML
template (one per row if needed, such as a statement for every member, optionally
password-protected), and delivers the file wherever it needs to go, zipped if you like: email,
SFTP/FTP, S3, GCS, Azure Blob, Databricks Volumes or Slack. A report can also send a
headline message built from its results, to Slack or email (Microsoft Teams and
Google Chat are in preview). It runs on whatever scheduler you already have: cron, Airflow, Dagster, Databricks Jobs.
If you know dbt, you already know DRE: a project of SQL and YAML, Jinja and macros, ref(),
source(), folder config, tags, selectors, profiles and targets. dbt builds yourโฆ