The latest articles on DEV Community by Sourav Katkar (@sourav_katkar_5ffec958ab4). https://dev.to/sourav_katkar_5ffec958ab4 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3988293%2Fcb7d1849-4545-4c30-8c98-5d5ceb739ecd.png https://dev.to/sourav_katkar_5ffec958ab4 en Sourav Katkar Wed, 17 Jun 2026 05:31:52 +0000 https://dev.to/sourav_katkar_5ffec958ab4/how-i-used-googles-new-antigravity-agent-to-build-a-bigquery-cheatsheet-in-a-day-1e5l https://dev.to/sourav_katkar_5ffec958ab4/how-i-used-googles-new-antigravity-agent-to-build-a-bigquery-cheatsheet-in-a-day-1e5l <p>I work as a Data Engineer, spending most of my day writing BigQuery SQL for large-scale GCP migrations. One thing kept annoying me: I'd constantly forget the exact syntax for things like <code>UNNEST</code>, window functions, or <code>MERGE</code> statements, and end up re-Googling the same StackOverflow answers over and over.</p> <p>So I decided to fix it myself, and use it as an excuse to try <strong>Google Antigravity</strong>, the new agentic development platform Google launched this year.</p> <h2> What is Antigravity, anyway? </h2> <p>Unlike a typical AI code editor where you write code and the AI autocompletes it, Antigravity flips the model. You describe the <em>task</em>, and an agent plans, writes, tests, and iterates on the code largely on its own, across your editor, terminal, and even the browser.</p> <p>I wanted to see how far I could get without writing code by hand.</p> <h2> The Build </h2> <p>I gave it a simple starting prompt: build an interactive, offline-first BigQuery SQL cheatsheet — searchable, with copy-to-clipboard buttons, categorized by topic, with a dark/light theme toggle.</p> <p>A few iterations later, I had:</p> <ul> <li>25+ categorized SQL snippets (Arrays, Structs, Window Functions, JSON, DDL/DML, performance tips)</li> <li>Live fuzzy search across titles, tags, and syntax</li> <li>One-click copy on every snippet</li> <li>A glassmorphic dark/light UI</li> <li>Zero backend — just a single HTML/CSS/JS bundle that runs fully offline No frameworks, no build step. Just open <code>index.html</code> in a browser.</li> </ul> <h2> What Surprised Me </h2> <p>The agent handled the boring-but-tedious parts well: organizing snippets into clean categories, building the search/filter logic, and getting the UI polish right (rounded cards, smooth transitions, responsive layout). I mostly nudged it on content accuracy and structure rather than writing CSS by hand.</p> <p>It's not magic — I still had to review the SQL examples for correctness since BigQuery has a lot of edge cases around cost optimization. But for scaffolding an entire interactive tool in an afternoon, it was a genuinely different workflow than the "write code, ask AI to fix it" loop I'm used to.</p> <h2> Try It </h2> <p>I packaged the final result and put it up for anyone who wants it: <a href="https://souravkatkar.gumroad.com/l/knxyvv" rel="noopener noreferrer">BigQuery SQL Interactive Cheatsheet</a></p> <p>It's pay-what-you-want. If you work with BigQuery regularly, or you're studying for a GCP Data Engineer interview, it might save you a few StackOverflow trips.</p> <p>Curious if other data engineers have tried agent-first tools like Antigravity for non-trivial builds — would love to hear what worked (or didn't) for you.</p> webdev ai bigquery showdev