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+P - On 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:\
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.