Reports

Configure scheduled data exports with filters, formats, and notifications.

Source Configuration

Each report needs a data source. You can configure it in two ways:

Schema + Table — Specify the source schema and table name. DataDrop generates a SELECT * query for you.

Custom SQL Query — Write a custom SQL query for full control over columns, joins, and transformations. When provided, this overrides the schema and table fields.

File Formats

ParquetRecommended

Columnar format with built-in compression. Smaller file sizes and faster reads for analytics tools. Best for large datasets.

CSV

Universal text format compatible with spreadsheets and any data tool. Choose a delimiter: comma, tab, pipe, or semicolon.

Schedules

Reports can be scheduled to run automatically:

Daily — Runs once every day at the specified time.
Weekly — Runs once a week on a chosen day at the specified time.
Monthly — Runs once a month on a chosen day at the specified time.
On Demand — No automatic schedule. Trigger manually with “Cook Now”.

All times use the timezone you select (Eastern, Pacific, UTC, etc.). DataDrop generates a cron expression internally and evaluates it in your chosen timezone.

Filters

Add row-level filters to export only matching data. Each filter consists of a column name, an operator, and a value.

Supported operators:

=!=><>=<=INLIKE

Multiple filters are combined with AND logic. For the IN operator, provide a comma-separated list of values.

Partitioning

Partition columns split the output into separate files based on column values. For example, partitioning by region creates one file per region. This is useful for large datasets where consumers only need a subset of the data.

Output Options

Export filename — Base filename for the exported file (without extension). Defaults to export.
Compress output — Wrap the export in a ZIP archive for smaller file sizes during transfer.
S3 prefix template — Override the warehouse-level prefix for this specific report. Supports {client_id}, {report_id}, and {date} variables.
Sort column — Column to sort by before export, with ascending or descending order.

Notifications

DataDrop can notify you when a delivery completes:

Email — Add email addresses to receive delivery notifications with a summary and download link. These are separate from client contacts and are typically internal team members.

Slack — Provide a Slack webhook URL to post delivery summaries to a channel. Create an incoming webhook in your Slack workspace settings.