AWS
Tutorials
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.
Joe Karlsson •
Blog — Tutorials
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 •
AWS
Best Practices
Tutorials
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.
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. Cross-reference git commit authors against your identity provider to find commits needing review.
Joe Karlsson •