Retrieves an offices.csv object from AWS S3, reads it into rows, and loops over each row keeping only four selected columns. The reduced rows are collected into a list, written to a new CSV file, and uploaded back to S3 as offices_reduced.csv. The workflow runs on demand.
- AWS S3 object download and upload
- CSV parsing with a header row
- Per-row column projection to a reduced column set
- In-execution list accumulation of transformed rows
- CSV regeneration from the accumulated list
- AWS S3 connection with access to the source bucket
- An offices.csv object stored at key files/offices.csv
Data teams that need to slim down or reshape CSV exports stored in cloud object storage.
- Retrieve offices.csv from AWS S3.
- Parse the CSV into rows using the header row.
- Loop over each row, building an object with only the four selected columns and appending it to a list.
- Read the accumulated list back out.
- Convert the list into a new CSV file.
- Upload the reduced CSV to AWS S3 as offices_reduced.csv.
MoreDocument OpsTemplates
Deletes a specific sheet from a Google Sheets spreadsheet and logs the result. A minimal, on-demand example workflow.
Lists all sheets in a Google Sheets spreadsheet and logs them. A minimal, on-demand example workflow.
On the first day of every month at 09:00, computes the previous month, creates a new Google Sheet tab for it, and fetches the tracked-time report from Nifty. It loops over each tracked task to retrieve details and compute its duration in hours, writes a row per task, adds a total-hours row, and emails a notification with a link to the spreadsheet.
Reads a local cities.csv file, parses it, and loops over each row. Rows with both a City and a State value are logged and inserted into the PostgreSQL CITY table; rows missing either value are logged as warnings. After the loop, it queries the row count of the CITY table and logs the total.
How ByteChef works?
Focus on what matters,
automate the rest.
