Madzamadza.hashnode.dev·Feb 17, 2025Introducing StackQL - Manage Your Cloud Services & Interact with APIs using SQL 🧑💻🔥In the fast-paced digital age, modern cloud stacks have become more complex, meaning users often have to learn various technologies and utilities to manage them. Each cloud provider offers its own set of tools, interfaces, and APIs, leading to a frag...Web Development
Abhijeet Patilgcp-learning.hashnode.dev·Feb 16, 2025Google Cloud Platform🌥️ Introduction to Google Cloud Platform (GCP) Google Cloud Platform (GCP) is a collection of cloud computing services offered by Google. It provides infrastructure, platform, and software tools to help businesses and developers build, deploy, and m...GCP
Gauravlostinopensrc.hashnode.dev·Feb 15, 2025Shift Security Left for Infra as CodeIn Today’s Cloud Native World , keeping Infra Secure and Compliant has become priority , thus the Shift left Strategy towards securing Cloud Infra needs to be focused and discussed more. I was exploring on this topic and landed upon a cool Opensource...1 likeTerraform
Constantin Lungudatawise.dev·Feb 13, 2025How ARRAY() can function as UNPIVOT and UNNEST as PIVOT?I’ve come across this SQL transformation multiple times, and it’s an interesting two-way problem. 1️⃣ From columns to rows (ARRAY as UNPIVOT):We start with separate timestamps for different lifecycle events. To analyze events dynamically, we reshape ...Practical SQLbigquery
Ray Yaoknack4tech.hashnode.dev·Feb 13, 2025AI Agent Setup with n8n - Google Drive OAuth in Local Network without Domain/URIIf you are having issue setting up an OAuth credential in n8n due to invalid URI, this article outlines how you can use nip.io to workaround the restriction even if you only have a local IP. One of the great things you can do with an AI agent is to c...n8n
Constantin Lungudatawise.dev·Feb 12, 2025Choosing the Right Ranking Function: Why Ties in SQL MatterIf you’re like me, you probably use QUALIFY + ROW_NUMBER() almost daily for deduplication or finding the first/last occurrence of something. It’s a powerful combo in modern SQL ! But here’s the catch: there are subtle nuances and edge cases that can ...Practical SQLbigquery
Steven J. MunnforSpacerunners Tech Blogblog.spacerunners.com·Feb 10, 2025Serving Stable Diffusion XL on Google CloudServing outputs from generative AI models is notoriously resource-intensive1. At Space Runners, we are primarily focused on diffusion models for generating or modifying images, which we apply to fashion items. Visitors should be excited to create wit...46 readsAI
Halimah Teniola Jamiutheteniverse.hashnode.dev·Feb 9, 2025Cloud Storage vs. Local Storage: A ComparisonIntroduction Storage technology is a crucial component of data management, impacting security, accessibility, and cost efficiency. This article compares cloud storage and local storage, evaluating their strengths, weaknesses, and ideal use cases. It ...cloud-storage
Constantin Lungudatawise.dev·Feb 8, 2025A closer look at STRING_AGG in BigQueryModern SQL engines have a wealth of aggregation functions. Here's a quick example that makes use ofBigQuery STRING_AGG. What does it do? It aggregates all the values in a grouping, joined by a separator of our choice, creating a string of those...Practical SQLbigquery
Constantin Lungudatawise.dev·Feb 8, 2025Here's a great use case for GenAI writing SQLTruth be told, I almost never use GenAI as part of my day-to-day work as a Data Engineer. For the most part, it’s just easier and faster for me to write the SQL code myself. There are a few reasons for this:➡️ If the task is complex enough to need Ch...Practical SQLSQL
