Skip to content

Changing fact_bigquery_job_statistics left join to inner join

Choose a tag to compare

@eduardo-nercolini eduardo-nercolini released this 16 Jul 17:47
· 29 commits to main since this release
7b80764

The join for job_id key was changed to inner join instead of left join, as a proposed fix for duplicate metrics_sk and null query_fk due to the discrepancy in the number of job_ids between the CTE fact_query_metrics (which pulls from stg_bigquery_analytics_information_schema_jobs) and the dim_bigquery_query.