sink-capital.com

In BigQuery SQL, you can check the change in the number of records before join and create a join relationship diagram

Latest Version

Version

0.6.2

Update

March 11, 2023

Size

204KiB

Developer

sink-capital.com

BQ JOIN checker Extension

【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)

Source Manifest.json

{"update_url": "https://clients2.google.com/service/update2/crx", "name": "BQ JOIN checker", "manifest_version": 3, "version": "0.6.2", "description": "__MSG_Description__", "action": { "default_popup": "index.html" }, "content_security_policy": { "extension_pages": "script-src 'self'; object-src 'self'" }, "permissions": [ "clipboardRead", "clipboardWrite", "storage", "tabs" ], "content_scripts": [ { "js": [ "assets/content-script-loader.index.ts.fd978bcf.df305af6.js" ], "matches": [ "https://bq-help-extension.sink-capital.com/viewer.html", "http://localhost:8888/docs/viewer.html" ], "run_at": "document_start" } ], "default_locale": "en", "web_accessible_resources": [ { "matches": [ "http://localhost:8888/*", "https://bq-help-extension.sink-capital.com/*" ], "resources": [ "assets/index.ts.fd978bcf.js" ], "use_dynamic_url": true } ]}

Download CRX(204KiB)