Working with CSV Files
Last updated
Last updated
In this guide, you'll learn how to effectively work with CSV files in Paradime using the integrated Rainbow CSV feature. This tool enhances your ability to view, edit, and analyze CSV data directly within the Paradime IDE.
Estimated completion time: 10 minutes
A .csv file to import into your dbt™ project
In this guide, you'll learn how to:
Access Rainbow CSV features
Align CSV columns
Perform multi-cursor editing
Set header lines
Customize separators
Use CSVLint for data quality checks
Automatic Color Coordination: CSV columns are color-coded for easy reading.
CSV Column Alignment: Visually align columns for better organization.
Multi-cursor Column Editing: Efficiently make bulk edits across columns.
Header Line Freezing: Keep column names visible while scrolling.
Customizable Separators: Choose how columns should be distinguished.
CSVLint: Check for consistency in quotes usage and field count.
If you don't already have a .csv file in your project, drag one into your project's repository.
Open a CSV file in the Paradime IDE.
In the status bar at the bottom of the IDE, turn on Rainbow CSV.
Open the Command Panel:
On Mac: Press ⌘ + Shift + P
On Windows: Press Ctrl + Shift + P
To access all Rainbow CSV commands:
Open the Command Panel
Type "Rainbow CSV"
You'll see a list of available commands:
Here are some key Rainbow CSV commands you can use:
Set Header Line
Designates the current line as the header
Improves column identification while scrolling
Command Panel
Align CSV Columns
Visually aligns columns without modifying the original file
Enhances readability, making it easier to analyze data
Command Panel or Status bar (UI)
Set Rainbow Separator
Allows selection of predefined separators (comma, tab, semicolon, pipe) or custom ones
Adapts to various CSV formats, improving column distinction
Command Panel
Edit Column Before/After
Enables multi-cursor column editing
Facilitates efficient bulk edits in specific columns
Command Panel
CSVLint
Automatically checks for consistency in quotes usage and field count
Helps maintain data integrity and spot formatting errors
Status Bar (UI)
Discover all Rainbow CSV features via the command panel:
Use Rainbow CSV for quick data quality checks before importing into your dbt™ models.
Leverage multi-cursor editing for rapid data cleaning tasks.
Combine Rainbow CSV with dbt™ seeds for efficient data loading and version control.
Use CSVLint regularly to catch formatting issues early in your data pipeline.
You've learned how to effectively work with CSV files in Paradime using the Rainbow CSV feature. This tool enhances your ability to view, edit, and analyze CSV data directly within the Paradime IDE, improving your data handling capabilities and workflow efficiency. Next, we'll explore how to run dbt™ in production with Bolt.
