When designing a data model in BigQuery for retail transaction data with tables `sales_transaction_header` and `sales_transaction_line` that have a closely connected and unchangeable relationship, how can you structure these tables to optimize the efficiency of data analytics queries?

Powered ByGPT-5

Google Professional Data Engineer