Overview
In BigQuery SQL, you can check the change in the number of records before join and create a join relationship diagram
【OVERVIEW】 By inputting standardSQL including BigQuery join clause, generate SQL to check the change in the number of records before and after join, and use the SQL for verification to detect unintended increase/decrease of records in join clause. I can. You can also visualize the SQL structure by analyzing the JOIN clause relationships. 【USE CASE】 When creating a mart SQL that connects sales and product data, etc., you can check from the record increase/decrease whether there is a non-normalization method. Examples of incorrect denormalization methods include the following possibilities: ・join key is wrong ・The id of the products table is not PK ・Join key is missing (sales.product_id contains NULL)
5 out of 51 rating
Google doesn't verify reviews. Learn more about results and reviews.
Details
- Version0.6.2
- UpdatedMarch 11, 2023
- Size204KiB
- Languages2 languages
- Developer
- TraderThis developer has identified itself as a trader per the definition from the European Union.
Privacy
BQ JOIN checker has disclosed the following information regarding the collection and usage of your data.
BQ JOIN checker handles the following:
This developer declares that your data is
- Not being sold to third parties, outside of the approved use cases
- Not being used or transferred for purposes that are unrelated to the item's core functionality
- Not being used or transferred to determine creditworthiness or for lending purposes
Support
For help with questions, suggestions, or problems, please open this page on your desktop browser