Troubleshooting and Solving Data Join Pitfalls

This lab focuses on how to reverse-engineer the relationships between data tables and the pitfalls to avoid when joining them together.

• GSP412
• Overview
• Setup
• Task 1. Create a new dataset to store your tables
• Task 2. Pin the lab project in BigQuery
• Task 3. Examine the fields
• Task 4. Identify a key field in your ecommerce dataset
• Task 5. Pitfall: non-unique key
• Task 6. Join pitfall solution: use distinct SKUs before joining
• Congratulations!