Engineering
Third Normal Form (3NF) vs Star Schema: When to Use Each
Learn the differences between Third Normal Form (3NF) and star schema with SQL examples, table diagrams, and guidance on when to use each in a data warehouse.
Tim Armstrong •
Blog — Engineering
Cloud Asset Inventory
Engineering
Platform Engineering
6 Cloud CMDB Best Practices for Platform Engineers (2026 Guide)
Cloud CMDB best practices for multi-account environments - automated discovery, tiered sync strategies, SQL-based querying, and historical data retention for compliance.
Joe Karlsson •
Cloud Asset Inventory
Engineering
The Real-Time Cloud CMDB - Why Ephemeral Infrastructure Killed Traditional Discovery
Traditional CMDBs miss most ephemeral resources because containers live just minutes. Modern cloud CMDBs use tiered sync strategies (15-30 min for critical, hourly for important, daily for baseline). Compare approaches, costs, and learn why ephemeral infrastructure killed traditional discovery.
Joe Karlsson •
AI
Engineering
Tutorials
Scale GitHub Issues semantic search with CloudQuery, BigQuery, and Vertex AI
Sync GitHub issues to BigQuery with CloudQuery, generate Vertex AI embeddings via BigQuery remote models, and deliver fast, fully managed semantic search and Q&A with Gemini—no vector database to run.
Mariano Gappa •
AWS
Cloud Infrastructure
Engineering
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.
Joe Karlsson •
AI
Engineering
Tutorials
Improve GitHub Issues search effortlessly with CloudQuery, pgvector and OpenAI
Turn GitHub issues into instant insights: sync with CloudQuery, generate pgvector embeddings in PostgreSQL, and answer natural-language questions with a tiny OpenAI-powered script.
Mariano Gappa •
Engineering
CloudQuery Performance Benchmark Analysis: 581 GB/Hour Throughput and the Reality of Cloud API Constraints
Comprehensive 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.
Joe Karlsson •
Engineering
How to Work with CloudQuery Syncs with Snowflake and Backstage
Learn how to query CloudQuery sync data on Snowflake using Backstage, including data transformation and visualization of your cloud asset inventory.
Duru Can Celasun •