data-engineer-pro video for scenario: You are designing a data model in BigQuery to store retail transaction data. The two main tables, sales_transaction_header
Scenario: You are designing a data model in BigQuery to store retail transaction data. The two main tables, sales_transaction_header and sales_transaction_line, have a tightly coupled immutable relationship. These tables are rarely modified after they are loaded and are frequently joined together in queries. You need to optimize the model of the sales_transaction_header and sales_transaction_line tables to enhance the performance of data analytics queries. Question: What approach should you take to model the sales_transaction_header and sales_transaction_line tables for improved query performance?