AWS Clean Rooms adds intermediate tables — reuse your SQL results!

Hey there, it's Shiichan! Today I've got a small but genuinely handy update from the AWS data-collaboration world to share with you.

AWS What's New aws.amazon.com

What was announced?

Over on AWS's What's New, they announced that AWS Clean Rooms now supports intermediate tables for SQL queries. You can now write the results of a SQL query to an intermediate table inside a collaboration and reuse it in later analyses.

The story so far

Clean Rooms lets multiple companies analyze their data together without exposing raw data to each other, keeping everything inside a privacy boundary. But until now, running complex multi-step analyses meant rewriting the same joins and prep work in every query. That's tedious, and re-running the same computation over and over tends to run up costs too.

What changes

Now you can save those intermediate results as an intermediate table within the collaboration and reuse them in the next analysis. Because the table lives inside the collaboration's privacy boundary, you can build multi-step workflows with confidence — reusing complex joins, or building a shared ID mapping table to feed downstream analyses.

Dive Deep

The example in the announcement makes it click. A publisher and an advertiser can join their first-party data to build an ID mapping table inside the collaboration, then reuse that table across reach, frequency, and attribution analyses. Since they don't have to redo the join from scratch each time, the subsequent analyses cost less and perform better.

For availability, check the AWS Regions where Clean Rooms is offered. The announcement didn't mention pricing.

Wrap-up

• AWS Clean Rooms now supports SQL intermediate tables, so you can save query results and reuse them
• Reuse complex joins or a shared ID mapping table, all inside the collaboration's privacy boundary
• Build an ID mapping table once and share it across reach, frequency, and attribution analyses to cut costs and boost performance

If you're an ads or data-analytics engineer who wants to run multi-step analyses safely with partners, this one's for you!