BigQuery data clean rooms now generally available: https://archive.analyticsengineering.net/2024/000038.html
Partitioning in Google BigQuery and dbt Incremental models: https://archive.analyticsengineering.net/2024/000039.html