Why you should care about VS Code Remote Development

Senior Data Engineer • Contractor / Freelancer • GCP & AWS Certified
Search for a command to run...

Senior Data Engineer • Contractor / Freelancer • GCP & AWS Certified
No comments yet. Be the first to comment.
Hands-on guides to data tooling, infrastructure, and operations — scheduling, pipelines, access control, and the engineering behind data workflows.
title: "Exploring the BigQuery Query History" seoTitle: "Understanding BigQuery Query History" seoDescription: "Discover how BigQuery's Job History helps track and retrieve past queries efficiently with filtering options and saved results for recent ...
Here's a useful Dataform concept: pre_operations and post_operations. As the name implies, these represent a set of actions that run before and after the main operation (table, view, or SQL operations

BigQuery has always been a SQL engine for tabular data. Object tables add an interesting twist to that. Instead of rows containing values, an object table gives you one row per file — pointing at da

Query your data lake with warehouse-grade security and performance — without moving a single file.

Ever run a heavy BigQuery SQL query, processed gigabytes of data — and then accidentally closed the tab or forgot to save the results? 😬 Don't re-run it. Your results are still there. BigQuery automa

You can use query parameters in BigQuery hashtag#SQL (now in the console as well!) — but how are they different from variables, and when should you use each? Both parameters and variables act as place

Maybe save a bit on that next expensive laptop upgrade?
Over the weekend, I worked on some small personal projects and decided to try out remote development using SSH and Visual Studio Code.
I have an 18 GB M3 Pro MBP, which is acceptable, but it’s not a whole lot when working with multiple containers. Luckily, I also have a pretty powerful (32 GB RAM/ Ryzen 9 5900HX) mini-PC that’s been collecting dust, so I thought I’d turn it into a Linux server—and effectively, a development box. I'm also more familiar with Ubuntu than I'm with the Mac.
I connected it directly to the router via cable for faster speeds and then set up ssh. With the remote dev pointed to the minipc in VSCode, while using my laptop it 100% felt like I was working locally, even though the heavy lifting was happening on the mini-PC.
The port forwarding makes it all pretty seamless, forwarding the ports from the server to my laptop, so you can just use your local browser.
What also I found cool was that I could still use all my VS Code extensions, like those for Docker or Python, just as I normally would.
With this setup, my laptop is essentially just the "control center"—all the processing happens on the mini-PC, so my laptop stays fast and cool.
In short, all the development happens on my laptop, but the resource consumption is offloaded to my server.
Found it useful? Subscribe to my Analytics newsletter at https://www.notjustsql.com .