Work
79 posts
AWS IAM Identity Center (Formerly AWS SSO): The Complete 2026 Guide
AWS IAM Identity Center replaced AWS SSO in 2022. Learn how to set it up, configure permission sets, use the AWS CLI, and audit access with CloudQuery.
CWPP vs CNAPP: What Cloud Security Teams Need to Know in 2026
CWPP protects cloud workloads at runtime. CNAPP unifies CWPP, CSPM, and CIEM into one platform. Learn when each makes sense and how they compare.
What Is Attack Surface Management? A Technical Guide for Cloud Teams
Attack surface management finds exposed cloud assets before attackers do. Learn how ASM differs from CSPM and vulnerability management, with SQL examples.
What Is Cloud Governance? The Complete Guide for Platform Engineering Teams
The policies and controls that keep cloud infrastructure secure, compliant, and cost-efficient. Learn the 6 pillars of cloud governance and how to implement them.
AWS Pinpoint Is Being Deprecated: How to Assess Your Migration Scope
AWS Pinpoint reaches end of support October 2026. Query your Pinpoint usage across all accounts to find what needs migrating before the deadline.
CloudQuery Sync Performance: A Practical Troubleshooting Guide
Why CloudQuery syncs slow down (especially after a plugin upgrade), how to diagnose expensive tables, and the CLI command that replaces the tables wildcard with an explicit list.
Did Gemini Just Make Your Google API Keys a Security Risk?
Google API keys safe to embed publicly now authenticate to Gemini. Here's how to audit your GCP projects with CloudQuery to find the exposure.
Cloud Operations Metrics and ROI for Leadership
Track the five metric categories that prove cloud operations ROI to leadership. Includes a one-page scorecard template with before-and-after targets.
A 90-Day Roadmap to Cloud Operations Maturity
A week-by-week plan from first inventory sync to automated governance. Three phases, clear milestones, and metrics to prove ROI to leadership.
What Makes a Cloud Data Layer AI-Ready
AI for cloud operations is only as good as the data behind it. Learn what makes a cloud data layer AI-ready and which use cases it enables first.
Mapping SOC 2 and CIS Controls to SQL for Continuous Compliance
Map SOC 2 and CIS controls to SQL queries that run daily. Replace quarterly audit scrambles with continuous compliance evidence generation.
Writing Cloud Security Posture Checks in SQL
Write cloud security checks in SQL instead of proprietary policy languages. See practical queries for public buckets, MFA, encryption, and more.
Beyond Deploy-Time Checks: Continuous Cloud Governance
Deploy-time policy checks miss console changes, configuration drift, and external changes. Continuous governance catches what CI/CD pipelines cannot.
Visibility-First Cloud Governance: Why You Should Start with Data
Most governance models fail because they enforce rules about infrastructure they cannot see. The Visibility-First model starts with a queryable foundation.
Calculating the True Cost of Cloud Operations Toil
Engineering toil from fragmented cloud visibility costs $47K-$90K per engineer yearly. Use our calculator to measure the real cost at your organization.
Why Cloud Compliance Audit Prep Still Takes Weeks
Most teams spend weeks preparing for audits that should take hours. Learn why compliance scrambles persist and how queryable data eliminates them.
The Hidden Cost of Cloud Security Alert Investigation
Security teams spend more time correlating information than fixing problems. See how a single alert costs 45 minutes of manual investigation.
The Cloud Operations Gap in Multi-Cloud Environments
89% of organizations use multiple clouds but only 8% are cloud-mature. Learn what the Cloud Operations Gap is and why it costs teams hours every week.
Cloud Operations Maturity Model: A Six-Dimension Self-Assessment
Score your cloud operations maturity across six dimensions. Only 8% of orgs qualify as highly cloud-mature - here is where most teams actually fall.
How to Detect Public Databases Across AWS, Azure, and GCP with CloudQuery Policies
Detect publicly accessible databases across AWS RDS, Azure, and GCP Cloud SQL. Step-by-step CloudQuery Policies tutorial with copy-paste ClickHouse SQL.
AWS Lambda Python 3.9 End-of-Support: Find and Upgrade Every Affected Function
AWS Lambda Python 3.9 security patches stopped Dec 15, 2025. Find every affected function across all accounts with SQL queries and upgrade to 3.12 or 3.13.
One Year Into DORA: What Actually Worked for ICT Asset Registers
One year into DORA enforcement, 46% of institutions still struggle with asset registers. Learn what worked, common pitfalls, and how to prepare for stricter 2026 enforcement.
CodeBreach Vulnerability: How to Detect If Your AWS CodeBuild Projects Are Affected
Detect CodeBreach vulnerability in your AWS CodeBuild webhook filters. SQL queries to find unanchored ACTOR_ACCOUNT_ID patterns and missing security controls.
AWS + Google Cloud Networking Partnership: Connectivity Solved, Visibility Still Broken
AWS and Google Cloud partnered on multicloud networking, provisioning connections in minutes. But network pipes were the easy problem. Unified visibility across different cloud APIs remains unsolved.
Audit CODEOWNERS Against Okta to Find Orphaned Code Ownership with SQL
Find CODEOWNERS entries for employees who left the company by joining Git file content with your identity provider data. No scripts, just SQL.
Find Commits by Departed Employees Across All Repos with SQL
Identify code changes made by employees who left your organization. Cross-reference git commit authors against your identity provider to find commits needing review.
Find Every repo Missing a LICENSE File with One SQL Query
Identify repositories without LICENSE files across your organization using SQL. No cloning required, no scripts to maintain - just query your git file data.
Find EOL Docker Images, Missing Licenses, and Stale CODEOWNERS Across Thousands of repos with SQL
Query your Dockerfiles, CODEOWNERS, and package.json files across all repos with SQL. No cloning, no custom scripts - just SQL queries that find EOL images, missing licenses, and outdated dependencies in seconds.
Query Your Dockerfiles with SQL: Find EOL Node 18 Images Across All repos
Node 18 reached end-of-life. Find every Dockerfile using Node 18 base images across your organization with a single SQL query - no cloning repos required.
Track React Dependencies Across Your Organization with SQL
Find every package.json using React across all repositories. Query dependency versions, track upgrades, identify outdated packages - all with SQL.
AWS Lambda Node.js 20 End of Life: Upgrade to Node.js 22 Before April 2026
Node.js 20 on AWS Lambda hits EOL April 30, 2026. Find every affected function across all accounts, fix breaking changes, and upgrade with this step-by-step guide.
Five Tips for Getting Maximum Value from a Cloud Asset Inventory
Discover five essential principles for building cloud asset inventories that deliver real business value. Learn how successful organizations transform cloud infrastructure visibility into measurable outcomes through business-focused implementation, cross-functional collaboration, and actionable intelligence.
How to Design a Cloud Asset Inventory for AWS
Learn the five essential design principles for building cloud asset inventories that deliver results - freshness, completeness, normalization, queryability, and extensibility. Discover the maturity stages from ad-hoc scripts to optimized systems with predictive analytics and real-time decision making.
Introduction to CloudQuery for AWS
Discover how CloudQuery solves cloud visibility fragmentation by providing AI-powered insights across all AWS resources. Learn CloudQuery's architecture, how it transforms multi-source data into unified schemas, and why it's become essential for security monitoring, cost optimization, and compliance automation.
Why and When Do You Need a Cloud Asset Inventory?
Discover why and when you need a cloud asset inventory for your AWS environment. Learn how asset inventories solve critical challenges in security governance, cost optimization, and operational excellence - and when organizations should implement them.
Building Secure AI-Powered Cloud Security: From Data Pipeline to Risk Detection
Learn how AI-powered cloud security reduces investigation time by 55% across AWS, GCP, Azure with our open-source demo.
CloudQuery Performance Benchmark Analysis: 581 GB/Hour Throughput and the Reality of Cloud API Constraints
Performance analysis of CloudQuery across multiple platforms and data sources, achieving 581 GB/hour throughput on consumer grade hardware when processing local data, with detailed analysis of cloud provider API rate limiting impacts.
We benchmarked our ETL tool and synced 1 million rows in 2 seconds on a MacBook
We benchmarked our ETL tool and synced 1 million rows in 2 seconds on laptop hardware, which is 68% faster than enterprise platforms. Full methodology and code included.
What is an AWS Cloud Asset Inventory?
What is AWS Cloud Asset Inventory? Learn why it's essential for security and cost optimization, and compare AWS Config, Systems Manager, and CloudQuery.
How to Make Your Internal Developer Portal Actually Useful
A fresh asset inventory is the foundation of successful developer portals. Learn how organizations achieve 224% ROI, reduce onboarding by 67%, and save millions through inventory-driven Backstage implementations with real case studies from Spotify, Toyota, and financial services.
Kubernetes Asset Tracking: Why 70% of Enterprises are Struggling (And How to Fix It)
Learn how to tackle the challenges of managing Kubernetes assets across multiple clouds with the central configuration store pattern. Discover how CloudQuery enables SQL-based querying for efficient governance, security enforcement, and compliance at scale.
Visualize & Govern Your Cloud Stack with CloudQuery Reports
CloudQuery Reports delivers actionable insights for multi-cloud security, compliance, and cost optimization with ready-to-use dashboards and SQL queries.
What We Learned Querying Cloud Infra for Expired Dependencies
Learn how to easily track and fix end-of-life cloud services across AWS, Azure, and GCP with CloudQuery new End-of-Life (EOL) integration.
The Best Way to Keep Your Cloud Inventory Up to Date
Keeping cloud asset data up to date across AWS, GCP, Azure, and Kubernetes has been a challenge until now. CloudQuery Data Pipelines automate syncing, normalizing, and structuring cloud data into a unified format. No more fragile scripts or manual exports. See how it works
Building an AWS Cloud Asset Inventory
Learn how to build a cloud asset inventory in AWS using CloudQuery, PostgreSQL, and Grafana. This guide covers setting up CloudQuery, transforming data with dbt, and visualizing cloud assets for improved security and compliance.
Stop Wasting Time on Cloud UIs and Scripts, and Query Your Cloud Like a Database
CloudQuery SQL Console lets you search your cloud like a database. No more clicking through endless dashboards or writing brittle scripts - just instant answers with SQL.
How to Eliminate Blind Spots in Your Cloud Environment
Stop guessing what in your multi-cloud environment. Use CloudQuery asset inventory to see everything, secure everything, and save money doing it.
How to Build a Cloud Asset Inventory for Azure
Learn how to build an Azure cloud asset inventory with CloudQuery and PostgreSQL. Covers setup, dbt transformations, and visualizing assets for security and compliance.
Getting Started with Cloud Asset Inventory in 2026
Cloud asset inventory is vital for managing multi-cloud environments, enhancing security, and ensuring compliance. Learn how to build and maintain an effective inventory. Explore best practices, address challenges, and see real-world applications.
What is SOC2 Compliance?
Learn SOC2 compliance essentials: protect data, build trust, and meet regulatory standards with security, availability, integrity, confidentiality, and privacy.
Building a Multi-Cloud Asset Inventory for Google Cloud Platform (GCP) and AWS with CloudQuery
Learn how to build a unified multi-cloud asset inventory with CloudQuery. This post covers pulling data from AWS and GCP, storing it in PostgreSQL, and querying your cloud assets with ease.
How to Build a Multi-Cloud Asset Inventory
Learn how to build a multi-cloud asset inventory (AWS, GCP, Azure) with this step-by-step guide. It covers cloud data collection, transformation, and storage, helping you optimize security, compliance, and cost management in your cloud environments.
Step-by-Step Guide to Building a Cloud Asset Inventory for GCP
Learn how to build a GCP cloud asset inventory with CloudQuery, PostgreSQL, and dbt. Covers setup, data transformation with dbt models, and querying your cloud resources.
Data Warehouses Are Terrible Application Backends
‘The ever-increasing tide of data has become a paradox of plenty for today’’s developers. According to a report from Seagate, by 2025 worldwide data will grow to a staggering 163 zettabytes, over 10...'
How to Build Applications over Streaming Data the Right Way
In modern data ecosystems, streaming data flows like traffic on a busy highway. Each packet of data has a specific destination,...
The Engineer’s Guide to Enriching Streams and Dimensions
Data - it’s the new oil, the new gold, the new … you get the idea. There’s a whole lot of it, and it’s valuable. But unless you’re into data hoarding, the point isn’t just to collect it; you want …...
Why ClickHouse Should Be Your Next Database
“Today, we’re jumping into databases. Another database to learn? But before you sprint for the hills, allow me to introduce you to ClickHouse.”
A step-by-step guide to build a real-time dashboard
Can you imagine shipping a new user-facing dashboard only to have your users met with a visualization that takes several seconds or even minutes to load? No way, right? Your users would get...
How to build a real-time fraud detection system
Financial fraud is a growing concern in our increasingly digital world. According to a report by PwC, almost half of the surveyed organizations experienced fraud in the past 2 years. For...
Modern data management with real-time Change Data Capture
Data engineers are grappling with surging data volumes while stakeholders increasingly demand real-time decision-making and user-facing features powered by data. This raises a fundamental question:...
Real-time Databases: What developers need to know
Selecting the right application database can be a challenge for developers, especially so when you need a database for building real-time applications. Real-time data has become an essential...
Using Bloom filter indexes for real-time text search in ClickHouse
Efficient text search is one of the hardest problems in data engineering. Text-based data presents a unique set of challenges, especially when you need results in real time...
What it takes to build a real-time recommendation system
Real-time, personalized recommendations have become a foundational part of our online experiences. From streaming services suggesting our next binge-worthy TV series to e-commerce platforms offering...
Event sourcing with Kafka: A practical example
Imagine you’re building banking software, and you’ve been asked to figure out one of the most fundamental tasks in fintech: determining the current balance of every customer in your system....
How to query Google Sheets with SQL in real time
Sick of manually wrestling with Google Sheets like it’s an Excel spreadsheet from 2005? Feel like force-quitting Chrome every time you attempt to sift through just 10,000 rows of data? We’ve all...
How to Use SingleStore as a Key-Value Store
Key-value stores are perhaps one of the most popular databases on the market today - and with good reason! They are fast, scalable and super easy to use. But did you know you can get all the...
How to Add Machine Learning Predictions with SingleStore and MindsDB
Have you ever needed to set a machine learning model on your data before?
How to Get Started with SingleStore
Are you looking for the fastest possible way to get a new SingleStore Cluster up and running while testing out sample datasets to experiment with and use?
How to Use SingleStore and Node.js
Do you need to get a basic SingleStore application setup quickly using Node.js?
How to Manage MongoDB Data at Scale
Let’s face it: Your data can get stale and old quickly. But just because the data isn’t being used as often as it once was doesn’t mean that it’s not still valuable or that it won’t be valuable again...
How to Query from Multiple MongoDB Databases
Have you ever needed to make queries across databases, clusters, data centers, or even mix it with data stored in an AWS S3 blob? You probably haven’t had to do all of these at once, but I’m guessing...
How to Seed a MongoDB Database with Fake Data
Have you ever worked on a MongoDB project and needed to seed your database with fake data in order to provide initial values for lookups, demo purposes, proof of concepts, etc.? I’m biased, but I’ve...
How to Use Custom Archival Rules and Partitioning on MongoDB Atlas Online Archive
Okay, so you’ve set up a simple MongoDB Atlas Online Archive, and now you might be wondering, “What’s next?” In this post, we will cover some more advanced Online Archive use cases, including setting...
How to use MongoDB Client-Side Field Level Encryption (CSFLE) with Node.js
Have you ever had to develop an application that stored sensitive data, like credit card numbers or social security numbers? This is a super common use case for databases, and it can be a pain to...
MongoDB Aggregation Pipeline Queries vs SQL Queries
Let’s be honest: Many devs coming to MongoDB are joining the community with a strong background in SQL. I would personally include myself in this subset of MongoDB devs. I think it’s useful to map...
Linked Lists and MongoDB: A Gentle Introduction
Are you new to data structures and algorithms? In this post, you will learn about one of the most important data structures in Computer Science, the Linked List, implemented with a MongoDB twist....
Save The World And Money With MongoDB Atlas Data Lake
Thanks for coming to my talk, Save The World And Money With MongoDB Atlas Data Lake. About Data centers are expensive. It turns out that this is not great for the environment. By 2040, storing...
MongoDB Schema Design Best Practices
Thanks for coming to my talk, MongoDB Schema Design Best Practices. Here you will find all the resources discussed during the talk. About: “How do I model my schema for my...
How to Build a React and MongoDB App From Scratch In 10 Minutes
Are you interested in learning how to build a React and MongoDB App? Like many of you, I have been interested in learning more about MongoDB’s cloud offerings and also not spending a dime. This guide...