VS Code Extensions for Data Engineering - Part 1
Tags: dataengineering, datascience, database, vscode
Published: 2024-01-17 22:16:40

This is my opinionated list for Visual Studio Code Extension that helped me during data wrangling, cleaning, processing, checks, and other utilization.

## [Rainbow CSV](https://marketplace.visualstudio.com/items?itemName=mechatroner.rainbow-csv)

CSV probably the most used format for storing datasets and it can read in plain text. When you reading csv file, do you face problem to distinguish each columns value? Rainbow CSV will help you to solve it.

![preview from the extension page](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/gb70mtljbdq37317m3lp.png)

## [Parquet-Viewer](https://marketplace.visualstudio.com/items?itemName=dvirtz.parquet-viewer)
Parquet is column-oriented data format for storage and data retrieval efficiency. You may find this format often in datalake storage system. You can view and read it using an interactive query tools, but not readable by text editor. Parquet-Viewer will provide you the view for the data.

![preview from the extension page](https://raw.githubusercontent.com/dvirtz/vscode-parquet-viewer/712b7722446ebf643276a2c3694e0146eae9b499/images/automatic.gif)

Since parquet mostly store a huge amount of data, opening it will depend on your machine capability.

## [SQLite Viewer](https://marketplace.visualstudio.com/items?itemName=qwtel.sqlite-viewer)

Someone gave you a sqlite database. You probably started to think to install a program like [sqlitebrowser](https://sqlitebrowser.org/), but only to view and read the data. Don't bother, you can use this extension instead.

![preview from the extension page](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/69gkiebm1jxodm808zvf.png)

## [Text Transformer for VSCode](https://marketplace.visualstudio.com/items?itemName=jackytsu.text-transformer)
VSCode only come with _UPPERCASE_ and _lowercase_ text transformation in the default installation. You may need the other text cases like _snake_case_ , _camelCase_ , _PascalCase_ . This extension will enable them.

![preview](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pghik79tq3gv3k2mienz.gif)

## [Increment Selection](https://marketplace.visualstudio.com/items?itemName=albymor.increment-selection)

We can duplicate lines of number in VSCode, but not incrementaly. This problem happened when we want to label each lines with sequential number. **Increment Selection** will increment our blocked lines automatically and you can start the sequence from any number you want.

![preview from the extension page](https://raw.githubusercontent.com/albymor/Increment-Selection/master/images/demo.gif)

## [Jump and Select](https://marketplace.visualstudio.com/items?itemName=ArturoDent.jump-and-select)

This extension is very useful to me when I'm dealing with CSV and processing multiply rows. The problem was traversing between commas to get you to the designated column.

![preview for jumpselect](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/770pjr43pzha29gcqmuh.gif)

This extension may come in handy for different case.

__________

Hope the list helps you to process the data faster.