Visual Studio Code

𝟏𝟒 𝐕𝐒 𝐂𝐨𝐝𝐞 𝐞𝐱𝐭𝐞𝐧𝐬𝐢𝐨𝐧𝐬 every Data engineer should swear by for maximum productivity..

𝐉𝐮𝐩𝐲𝐭𝐞𝐫 (𝟖𝟓𝐌+ ⬇) - Brings interactive notebooks into VS Code, perfect for exploring datasets, running Python scripts, and testing ETL pipelines

𝐃𝐨𝐜𝐤𝐞𝐫 (𝟑𝟗𝐌+ ⬇) - Simplifies container management, making it easy to set up and manage local and remote environments for your data workflows.

𝐏𝐚𝐫𝐪𝐮𝐞𝐭 𝐕𝐢𝐞𝐰𝐞𝐫 (𝟏𝟖𝟏𝐊+ ⬇) - Enables seamless viewing of Parquet files, often used in big data workflows, directly within VS Code.

𝐑𝐚𝐢𝐧𝐛𝐨𝐰 𝐂𝐒𝐕 (𝟏𝟎𝐌+ ⬇) - Highlights and formats CSV/TSV files for easier reading, making data cleaning and validation tasks much more efficient.

𝐘𝐚𝐦𝐥 (𝟏𝟗𝐌+ ⬇) - Essential for managing YAML files used in configuration for tools like Kubernetes and Airflow, ensuring your pipeline configs stay error-free.

𝐃𝐚𝐭𝐚 𝐖𝐫𝐚𝐧𝐠𝐥𝐞𝐫(𝟓𝟖𝟕𝐊+ ⬇): It provides a rich user interface to view and analyze your data, show insightful column statistics and visualizations, and automatically generate Pandas code as you clean and transform the data.

𝐂𝐨𝐩𝐢𝐥𝐨𝐭 (𝟐𝟐𝐌+ ⬇) - Powered by AI, it assists with code generation, automating repetitive tasks like writing SQL queries or transforming datasets.

𝐏𝐲𝐥𝐚𝐧𝐜𝐞 (𝟏𝟏𝟖𝐌+ ⬇): Pylance has the ability to supercharge your Python IntelliSense experience with rich type information, helping you write better code faster.

𝐒𝐐𝐋𝐓𝐨𝐨𝐥𝐬 (𝟒.𝟔𝐌+ ⬇): A must-have for connecting to databases, running queries, and exploring schemas. Simplifies interactions with PostgreSQL, MySQL, and others for your ETL tasks.

𝐂𝐥𝐨𝐮𝐝 𝐂𝐨𝐝𝐞 (𝟏.𝟓𝐌+ ⬇) - A productivity booster for working with GCP services, especially handy for orchestrating data pipelines in Kubernetes and cloud-based data solutions.

𝐈𝐧𝐝𝐞𝐧𝐭-𝐫𝐚𝐢𝐧𝐛𝐨𝐰 (𝟗.𝟏𝐌+ ⬇): Adds color and structure to your indentation, helping to debug and navigate complex YAML and Python files.

𝐒𝐐𝐋𝐢𝐭𝐞 𝐕𝐢𝐞𝐰𝐞𝐫 (𝟏.𝟓𝐌+ ⬇): Quickly view and query SQLite files, perfect for small-scale data processing or prototyping queries.

𝐏𝐨𝐬𝐭𝐦𝐚𝐧 (𝟏.𝟐𝐌+ ⬇): Ideal for testing APIs during data ingestion and integration workflows; send, monitor, and debug API requests right in VS Code.

𝐆𝐢𝐭𝐋𝐞𝐧𝐬 (𝟑𝟔𝐌+ ⬇): Adds powerful Git features directly in VS Code, helping you version-control your data engineering pipelines and track changes effectively.

Find matching bracket: Cmd Shift   \

Shift code block left: Shift+ Tab Shift code block left: Tab

Markdown viewer plugin

https://marketplace.visualstudio.com/items?itemName=shd101wyy.markdown-preview-enhanced

https://addons.mozilla.org/en-US/firefox/addon/markdown-viewer-chrome/

To invoke code from command line

sudo ln -s /Applications/Visual\ Studio\ Code.app/Contents/Resources/app/bin/code /usr/local/bin/code

Or add this to PATH

~/.zprofile
# Add Visual Studio Code (code)
export PATH="\$PATH:/Applications/Visual Studio Code.app/Contents/Resources/app/bin"

Git History https://marketplace.visualstudio.com/items?itemName=donjayamanne.githistory

  PATH=$PATH:"/Applications/Visual Studio Code.app/Contents/Resources/app/bin"

https://marketplace.visualstudio.com/items?itemName=formulahendry.code-runner

https://marketplace.visualstudio.com/items?itemName=shardulm94.trailing-spaces

https://habr.com/ru/company/microsoft/blog/472228/

https://habr.com/ru/company/edison/blog/479828/

https://dev.to/lampewebdev/the-guide-to-visual-studio-code-shortcuts-higher-productivity-and-30-of-my-favourite-shortcuts-you-need-to-learn-mb3

https://marketplace.visualstudio.com/items?itemName=eamodio.gitlens . GitLens

https://marketplace.visualstudio.com/items?itemName=tomaszbartoszewski.avro-tools AVRO Tools

https://code.visualstudio.com/blogs/2019/10/03/remote-ssh-tips-and-tricks SSH

https://www.jonrcorbin.com/the-best-vs-code-extension-list-for-full-stack-developers/

https://code.visualstudio.com/docs/introvideos/debugging . DEBUGGING

diff

show the diff between two files, with VSCode add to path:

PATH=$PATH:"/Applications/Visual Studio Code.app/Contents/Resources/app/bin"

code --diff file1.js file2.js

Visual Studio Code

REST extensions

VS Code + python

Visual Studio Code + JavaScript

Visual Studio Code + Scala

Visual Studio Code + Java

diff