The reports you need.
The projects behind them.
DRE automates recurring SQL reports and their delivery. Find the job closest to yours, inspect its SQL and YAML, and see what it produces.
Recurring reports and delivery
Trustworthy AI with MCP
Reviewed report answers, local refinements and documented table exploration, with clear provenance.
Monthly finance pack
A multi-sheet Excel workbook with money formats, formulas, totals and a branded template.
A file for a bank or regulator
Fixed-width or delimited files to the exact layout the other side asks for, dropped on SFTP.
Extracts to S3, GCS or Azure Blob
Parquet or csv extracts, written where downstream systems pick them up.
One report per store or region
Sets run the same report once per client, each with its own file and recipient.
DRE as a Databricks job
Install DRE from a wheel in a serverless job and write the report to a Volume.
One workbook from three systems
DuckDB, Postgres and Databricks tabs in one Excel file, each query on its own connection.
A report built by a coding agent
From “help me with dre” to a delivered file, with an agent as the guide.
See every upcoming run
dre schedule ls lists when every schedule fires, with DST worked out, and the exact command for each run.
A headline in Slack, the workbook attached
The numbers people actually read, posted to a channel, built from the same queries as the Excel file.
Formats, templates and reporting recipes
Save to a Databricks Volume or workspace
Write the file to a Unity Catalog Volume or a workspace folder, from your laptop or inside a job.
Run by schedule name
Name a timing once and share it; your orchestrator runs dre run --schedule, and a rerun renders the same SQL.
Deliver to many destinations in one run
One workbook: local copy, SFTP, S3, GCS, Azure Blob and an email, in order, in a single run.
Fill a branded Excel template
Design the workbook in Excel; DRE fills the cells and tables and keeps your styling.
Totals, row formulas and column formulas
Real Excel formulas under and beside your data: totals for columns, a formula on every row, a formula over whole columns.
Send a message only when it matters
A when: condition over the results: the message goes out only when a region is under target.