Tutorials
Moving Data from PostgreSQL to MotherDuck
How to sync PostgreSQL data to MotherDuck using CloudQuery, with both one-off batch and continuous CDC streaming options for serverless analytics.
Herman Schaaf •
Blog Archive Page 2 — Tutorials
AWS
Best Practices
Tutorials
CloudQuery Sync Performance: A Practical Troubleshooting Guide
Diagnose why CloudQuery syncs slow down after plugin upgrades, identify expensive tables, and use the CLI command that replaces the tables wildcard.
Joe Karlsson •
AWS
Security
Tutorials
Set Up AWS CLI with SSO (IAM Identity Center) — Step by Step
Configure AWS CLI v2 with IAM Identity Center in 5 minutes. Covers sso-session setup, automatic token refresh, and switching between multi-account profiles.
Yevgeny Pats •
Security
Tutorials
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.
Joe Karlsson •
AWS
Cloud Infrastructure
Tutorials
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.
Joe Karlsson •
Security
Tutorials
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.
Joe Karlsson •
Security
Tutorials
Find Commits by Departed Employees Across All Repos with SQL
Identify code changes made by employees who left your organization by cross-referencing git commit authors against your identity provider with SQL.
Joe Karlsson •
Security
Tutorials
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.
Joe Karlsson •