Use case
A lightweight local ETL tool for file cleanup.
Sometimes you do not need Airflow, dbt, a warehouse or a cloud ETL platform. You just need to turn a bad file into a good file, locally and repeatably.
Typical cases
- Small ETL jobs that do not justify infrastructure
- Consulting work with customer exports
- Repeated monthly cleanup tasks
Example SQL
with clean as (
select
trim(customer_name) as customer_name,
try_cast(order_date as date) as order_date,
try_cast(amount as decimal(18,2)) as amount
from imported_file
)
select * from clean where amount is not null;
How Bendit helps
- Import the file directly into the local workbench.
- Inspect columns, types and preview rows.
- Transform with DuckDB SQL.
- Export a clean CSV or Parquet result.