{"id":3714,"date":"2022-02-02T11:46:53","date_gmt":"2022-02-02T11:46:53","guid":{"rendered":"https:\/\/wiki.thomasandsofia.com\/?p=3714"},"modified":"2022-02-18T21:36:00","modified_gmt":"2022-02-18T21:36:00","slug":"bigquery-for-big-data","status":"publish","type":"post","link":"https:\/\/wiki.thomasandsofia.com\/?p=3714","title":{"rendered":"BigQuery for Big Data"},"content":{"rendered":"<h1>Main Menu<\/h1>\n<ul>\n<li><a href=\"\/bqfbd-overview\/\">1-2 Overview<\/a><\/li>\n<li><a href=\"\/bqfbd-dataset-and-table-creation\/\">3 Dataset and Table Creation<\/a><\/li>\n<li><a href=\"\/bqfbd-using-bigquery-dashboard-options\/\">4 Using BigQuery Dashboard Options<\/a><\/li>\n<li><a href=\"\/bqfbd-efficient-schema-design-in-bigquery\/\">5 Efficient Schema Design in BigQuery<\/a><\/li>\n<li><a href=\"\/bqfbd-operations-on-datasets-tables\/\">6 Operations on Datasets &amp; Tables<\/a><\/li>\n<li><a href=\"\/bqfbd-execution-plan-of-bigquery\/\">7 Execution Plan of BigQuery<\/a><\/li>\n<li><a href=\"\/bqfbd-partitioned-tables-in-bigquery\/\">8 Partitioned Tables in BigQuery<\/a><\/li>\n<li><a href=\"\/bqfbd-clustered-tables-in-bigquery\/\">9 Clustered Tables in BigQuery<\/a><\/li>\n<li><a href=\"\/bqfbd-loading-and-querying-external-data-sources\/\">10 Loading and Querying External Data Sources<\/a><\/li>\n<li><a href=\"\/bqfbd-views-in-bigquery\/\">11 Views in BigQuery<\/a><\/li>\n<li><a href=\"\/bqfbd-materialized-views-in-bigquery\/\">12 Materialized Views in BigQuery<\/a><\/li>\n<li><a href=\"\/bqfbd-bigquery-command-line\/\">13 BigQuery Command Line<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h1>Table Joins<\/h1>\n<p><a href=\"https:\/\/wiki.thomasandsofia.com\/wp-content\/uploads\/2022\/02\/bq-table-joins.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3784\" src=\"https:\/\/wiki.thomasandsofia.com\/wp-content\/uploads\/2022\/02\/bq-table-joins.png\" alt=\"\" width=\"626\" height=\"356\" srcset=\"https:\/\/wiki.thomasandsofia.com\/wp-content\/uploads\/2022\/02\/bq-table-joins.png 626w, https:\/\/wiki.thomasandsofia.com\/wp-content\/uploads\/2022\/02\/bq-table-joins-300x171.png 300w, https:\/\/wiki.thomasandsofia.com\/wp-content\/uploads\/2022\/02\/bq-table-joins-150x85.png 150w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><\/a><\/p>\n<h2>Table JOIN Examples<\/h2>\n<pre>SELECT \r\n  member.*, group.* \r\nFROM\r\n `proj.ds.members` as member\r\nJOIN\r\n `proj.ds.groups` as group\r\nON\r\n member.group_id=group.group_id\r\nWHERE\r\n group.group_id=5\r\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Main Menu 1-2 Overview 3 Dataset and Table Creation 4 Using BigQuery Dashboard Options 5 Efficient Schema Design in BigQuery 6 Operations on Datasets &amp; Tables 7 Execution Plan of BigQuery 8 Partitioned Tables in BigQuery 9 Clustered Tables in BigQuery 10 Loading and Querying External Data Sources 11 Views in BigQuery 12 Materialized Views ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/wiki.thomasandsofia.com\/?p=3714\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[77,78],"tags":[],"class_list":["post-3714","post","type-post","status-publish","format-standard","hentry","category-bigquery","category-bigquery-for-big-data-engineers"],"_links":{"self":[{"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/posts\/3714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3714"}],"version-history":[{"count":14,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/posts\/3714\/revisions"}],"predecessor-version":[{"id":3801,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=\/wp\/v2\/posts\/3714\/revisions\/3801"}],"wp:attachment":[{"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wiki.thomasandsofia.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}