I want to open and edit large parquet files in a spreadsheet and clean them up before importing to my data warehouse. I can’t edit parquet files in Excel or Google Sheets. Can I edit parquet files in Row Zero?
Yes, you can easily open and edit parquet files in spreadsheets with a simple file import in Row Zero. You have a few options to open your parquet file:
- Import the parquet file from your computer if you have the parquet file on your local machine
- Import from URL if your parquet file is hosted on a URL
- Import from a connected Amazon S3 bucket if your parquet file is stored in S3.
The parquet file opens automatically in spreadsheet cells. From here, you can use spreadsheet features to edit your parquet file. Here’s a video tutorial:
After you’ve edited your parquet file, you have a few options for next steps:
-
Write the edited parquet data to your data warehouse - Row Zero has built-in connectors to Snowflake, Databricks, Redshift, etc.
-
Share the parquet spreadsheet with colleagues so they can view and collaborate with the data.
-
Download the spreadsheet as a CSV. This can be an easy way to convert parquet files to CSV files.
-
Keep your parquet spreadsheet in Row Zero. You can come back and open the spreadsheet at any time. You can also update the spreadsheet with new data if your parquet file gets updated. Here’s how to update spreadsheets via with new files.
Regardless of your goals, Row Zero makes it easy to view and edit parquet files in a spreadsheet online. Simply open a new workbook to get started.