Insights
Practical knowledge in data, cloud, AI and software development
Articles, technical guides, how-tos, and talks from our team and community. Filter by topic or content type.
Latest insights
-
Amazon Redshift SQL Cheat Sheet: Tables, Views, Users and Practical Commands
Commands for finding Redshift tables and views, getting table definitions, listing users, loading data with COPY and checking query history and plans.
-
How to Fix Athena “Query Exhausted Resources at This Scale Factor”
Amazon Athena returns “Query exhausted resources at this scale factor” when a query needs more resources than its execution cluster can provide. Here is how to find the operation behind…
-
Presto on AWS Explained: Amazon EMR, Athena and Trino
Presto, Trino and Athena share a history, which makes older guides confusing. Here is how Presto on Amazon EMR compares with Athena, and what to check before choosing an engine.
-
80% Cost Reduction in Google Cloud BigQuery
Google Cloud BigQuery costs can be reduced by limiting unnecessary data scans, avoiding repeated calculations and setting query quotas to control consumption. At Investing.com, introducing quotas reduced monthly spending from…
-
How to Name Your Events: A Tracking Plan for Product Analytics
Clear event and property names make every chart readable at a glance, and they decide whether Amplitude’s AI picks the right events. Here are the naming rules we use.
-
TypeScript in the era of AI… or why your types matter more than your skills
Skill files and comments are suggestions an AI agent can skip. A TypeScript conditional type turns a misuse into a compiler error that also explains the business reason.
