Trim columns from a CSV file in AWS S3 and upload the result
Trim and reshape CSV exports stored in cloud object storage.
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
Delete a sheet from a Google Sheets spreadsheet
Deletes a specific sheet from a Google Sheets spreadsheet and logs the result. A minimal, on-demand example workflow.
List all sheets in a Google Sheets spreadsheet
Lists all sheets in a Google Sheets spreadsheet and logs them. A minimal, on-demand example workflow.
Build a monthly Nifty time report in Google Sheets and email it
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.
Validate CSV rows and insert them into PostgreSQL
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.
By subscribing, you agree to receive emails from ByteChef and to our Privacy Policy. You can unsubscribe at any time.