This is a dedicated watch page for a single video.
Scenario: You are moving an application that tracks library books and related details, such as the author or year of publication, from an on-premises data warehouse to BigQuery. In the current relational database, author data resides in a separate table and is joined with book information using a common key. Following Google's recommended schema design practices, how should you organize the data to ensure fast query performance for retrieving author details of borrowed books? Question: What schema structure should you use in BigQuery to optimize query performance for retrieving author information for borrowed books?