Working with CSV Files
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
Prerequisites
A .csv file to import into your dbt™ project
What You'll Learn
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
Tutorial
Key Features
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.
How to Use
1. Launch Rainbow CSV (H3)
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+POn Windows: Press
Ctrl+Shift+P
2. Access the Commands Panel
To access all Rainbow CSV commands:
Open the Command Panel
Type "Rainbow CSV"
You'll see a list of available commands:
3. Utilize Rainbow CSV Commands
Here are some key Rainbow CSV commands you can use:
| Command | Description | Use case | Where to Find it |
|---|---|---|---|
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:
Pro Tips
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.
Related Documentation
Summary
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.
Last updated
