data-engineer-pro video for you are designing a data model in BigQuery for RetailNova , which needs to store retail transaction data. The two largest tables —
You are designing a data model in BigQuery for RetailNova , which needs to store retail transaction data. The two largest tables — sales_transaction_header and sales_transaction_line — have a tightly bound immutable relationship , where transactions are rarely modified after being loaded. These tables are frequently joined during analytical queries. To enhance performance for downstream data analysis, how should you model these tables?