AWS Clean Rooms now supports intermediate tables for SQL

AWS Clean Rooms Update

AWS Clean Rooms now supports intermediate tables for SQL queries, enhancing flexibility for organizations conducting complex, multi-step analytical workflows with partners. Customers can now write SQL query results to an intermediate table within a collaboration for reuse in subsequent analyses. This feature enables multi-step analytical workflows, such as reusing complex joins and building shared ID mapping tables for downstream analyses, all within the privacy boundary of the collaboration.

For example, a publisher and an advertiser can join their first-party data to build an ID mapping table in a collaboration, then reuse it across reach, frequency, and attribution analyses, reducing costs and optimizing performance for subsequent analyses.

AWS Clean Rooms helps companies and their partners analyze and collaborate on collective datasets without revealing or copying each other’s underlying data.

What to do

• Explore the new intermediate tables feature in AWS Clean Rooms for multi-step analytical workflows.
• Reuse complex joins and shared ID mapping tables within the privacy boundary of the collaboration.
• Optimize performance and reduce costs for subsequent analyses.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.