{"id":3485,"date":"2023-06-14T14:54:28","date_gmt":"2023-06-14T05:54:28","guid":{"rendered":"https:\/\/blog.since2020.jp\/?p=3485"},"modified":"2023-06-14T15:09:04","modified_gmt":"2023-06-14T06:09:04","slug":"looker_guide_part1","status":"publish","type":"post","link":"https:\/\/since2020.jp\/media\/looker_guide_part1\/","title":{"rendered":"\u3010Looker\u306e\u4f7f\u3044\u65b9\u30ac\u30a4\u30c9\u3011View\u3068Model\u3068\u306f\uff1f"},"content":{"rendered":"\n<p>Looker\u306fGoogle Cloud Platform\u306e\u30c7\u30fc\u30bf\u5206\u6790\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u3001\u30c7\u30fc\u30bf\u53ce\u96c6\u304b\u3089\u53ef\u8996\u5316\u307e\u3067\u3092\u7c21\u5358\u306b\u884c\u3048\u307e\u3059\u3002\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3001Looker\u3067\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306aModel\u30d5\u30a1\u30a4\u30eb\u3001View\u30d5\u30a1\u30a4\u30eb\u306e\u69cb\u7bc9\u65b9\u6cd5\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n<h2>Looker\u3068\u306f\uff1f\uff1f<\/h2>\nLooker\u306f\u3001Google Cloud Platform\u304c\u63d0\u4f9b\u3059\u308b\u30c7\u30fc\u30bf\u5206\u6790\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u3059\u3002\u30c7\u30fc\u30bf\u306e\u53ce\u96c6\u3001\u5206\u6790\u3001\u53ef\u8996\u5316\u3092\u7c21\u5358\u306b\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u3001\u30d3\u30b8\u30cd\u30b9\u306e\u610f\u601d\u6c7a\u5b9a\u3092\u652f\u63f4\u3057\u307e\u3059\u3002\r\n\r\nLooker\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u5927\u304d\u304f\u4e09\u3064\u306e\u8981\u7d20\u304b\u3089\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u69cb\u6210\u3057\u3001\u5b9f\u88c5\u3055\u308c\u3066\u3044\u307e\u3059\u3002\r\n<ul style=\"list-style-type: disc;\">\r\n \t<li>Model\u30d5\u30a1\u30a4\u30eb\uff1a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u9593\u306e\u7d50\u5408\u306a\u3069\u3001\u30c6\u30fc\u30d6\u30eb\u5358\u4f4d\u306e\u5b9a\u7fa9\u3092\u884c\u3046<\/li>\r\n \t<li>View\u30d5\u30a1\u30a4\u30eb\uff1a\u63a5\u7d9a\u3057\u305f\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u5b9a\u7fa9\u3092\u884c\u3046<\/li>\r\n \t<li>LookML dashborads\uff1aModel\u30d5\u30a1\u30a4\u30eb\u3084View\u30d5\u30a1\u30a4\u30eb\u3067\u5b9a\u7fa9\u3057\u305f\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u53ef\u8996\u5316\u3092\u884c\u3046<\/li>\r\n<\/ul>\r\n<ul><\/ul>\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/lookml-scaled.jpg\" alt=\"\" \/>\r\n\r\n\u5f15\u7528\uff1a<a href=\"https:\/\/cloud.google.com\/looker\/docs\/what-is-lookml?hl=ja#:~:text=LookML\">https:\/\/cloud.google.com\/looker\/docs\/what-is-lookml<\/a>\r\n\r\n\u4e3b\u306a\u5b9f\u88c5\u30d5\u30ed\u30fc\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\r\n<ul style=\"list-style-type: disc;\">\r\n \t<li>BigQuery\u3084Redshift\u306a\u3069\u306e\u3088\u3046\u306aDWH\u3084MySQL\u306a\u3069\u306eSQL\u30b5\u30fc\u30d0\u30fc\u3068Looker\u306e\u63a5\u7d9a\u3092\u884c\u3046<\/li>\r\n \t<li>View\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3001\u63a5\u7d9a\u3057\u305f\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092Looker\u4e0a\u3067\u3069\u306e\u3088\u3046\u306b\u6271\u3046\u304b\u3092\u5b9a\u7fa9<\/li>\r\n \t<li>View\u30d5\u30a1\u30a4\u30eb\u3092Model\u30d5\u30a1\u30a4\u30eb\u3067\u547c\u3073\u51fa\u3057\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u7d50\u5408\u3084\u3001\u3069\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u4f7f\u3046\u304b\u3092\u5b9a\u7fa9\u4ed8\u3051<\/li>\r\n \t<li>Model\u30d5\u30a1\u30a4\u30eb\u3067\u5b9a\u7fa9\u3057\u305f\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3001\u8868\u3084\u30b0\u30e9\u30d5\u3092\u63cf\u753b\u3057\u3001\u30c7\u30fc\u30bf\u306e\u53ef\u8996\u5316<\/li>\r\n<\/ul>\r\n<ul><\/ul>\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/looker_flow-scaled.jpg\" alt=\"\" \/>\n\n<h2>\u4eca\u56de\u6271\u3046\u30c7\u30fc\u30bf<\/h2>\n\u4eca\u56de\u3001\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066Looker\u3067\u3069\u306e\u3088\u3046\u306b\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b\u306e\u304b\u3092\u8907\u6570\u306e\u30d6\u30ed\u30b0\u306b\u6e21\u3063\u3066\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002\u4eca\u56de\u3001\u524d\u3082\u3063\u3066\u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u3057\u305f\u4e0b\u8a18\u30c7\u30fc\u30bf\u3092BigQuery\u306b\u4fdd\u5b58\u3057\u3066\u4f7f\u7528\u3057\u3066\u3044\u304d\u307e\u3059\u3002\r\n\r\n<a href=\"https:\/\/competition.nishika.com\/competitions\/nishika-mansion-spring-2023\/summary\">https:\/\/competition.nishika.com\/competitions\/nishika-mansion-spring-2023\/summary<\/a>\r\n\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/looker_data.jpg\" alt=\"\" \/>\n\n<h2>View\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3001\u30c7\u30fc\u30bf\u306e\u5b9a\u7fa9\u3092\u884c\u3046<\/h2>\n\u307e\u305a\u3001\u4eca\u56de\u4f7f\u7528\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u3092Looker\u4e0a\u3067\u3069\u306e\u3088\u3046\u306b\u3057\u3066\u6271\u3046\u304b\u3092\u5b9a\u7fa9\u4ed8\u3051\u3059\u308b\u305f\u3081\u3001View\u30d5\u30a1\u30a4\u30eb\u306e\u4f5c\u6210\u3092\u884c\u3044\u307e\u3059\u3002\u4e0b\u8a18\u8868\u306fView\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210\u306b\u4f7f\u7528\u3059\u308b\u30b3\u30fc\u30c9\u306e\u4e00\u4f8b\u3067\u3059\u3002\u4e0b\u8a18\u30b3\u30fc\u30c9\u3092\u4f7f\u3063\u3066Bigquery\u306b\u3042\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092Looker\u4e0a\u3067\u3069\u306e\u3088\u3046\u306b\u6271\u3046\u304b\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002\r\n\r\n<img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2023\/06\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2023-06-14-14.48.07.png\" alt=\"\" \/>\r\n\r\n\u4e0b\u8a18\u304cView\u30d5\u30a1\u30a4\u30eb\u306e\u5b9f\u88c5\u4f8b\u3067\u3059\u3002\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>view: mansion_dataset { \r\n\u3000sql_table_name: `\u4f7f\u7528\u3057\u305f\u3044\u30c6\u30fc\u30d6\u30eb\u306e\u30d1\u30b9`;; \r\n\u3000dimension: id { \r\n\u3000\u3000\u3000primary_key: yes \r\n\u3000\u3000\u3000type: number \r\n\u3000\u3000\u3000sql: ${TABLE}.id ;; \r\n\u3000} \r\n\u3000dimension: city_plan { \r\n\u3000\u3000\u3000type: string \r\n\u3000\u3000\u3000sql: ${TABLE}.city_plan ;;\r\n\u3000} \r\n\u3000dimension: district { \r\n\u3000\u3000\u3000type: string \r\n\u3000\u3000\u3000sql: ${TABLE}.district ;; \r\n\u3000} \r\n\u3000dimension: floor_plan { \r\n\u3000\u3000\u3000type: string \r\n\u3000\u3000\u3000sql: ${TABLE}.floor_plan ;; \r\n\u3000} \r\n\u3000dimension: floor_size { \r\n\u3000\u3000\u3000type: number \r\n\u3000\u3000\u3000sql: ${TABLE}.floor_size ;; \r\n\u3000} \r\n}\r\n<\/code><\/pre>\r\n<\/div>\n\n<h2>Model\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3001\u4eca\u56de\u6271\u3046View\u30d5\u30a1\u30a4\u30eb\u306e\u5b9a\u7fa9\u3092\u884c\u3046<\/h2>\n\u6b21\u306b\u3001Model\u30d5\u30a1\u30a4\u30eb\u306e\u5b9f\u88c5\u3092\u3057\u3066\u3044\u304d\u307e\u3059\u3002Model\u30d5\u30a1\u30a4\u30eb\u3067\u306f\u5148\u307b\u3069\u4f5c\u6210\u3057\u305fView\u30d5\u30a1\u30a4\u30eb\u3092\u3069\u306e\u3088\u3046\u306b\u6271\u3046\u304b\u3092\u5b9a\u7fa9\u3059\u308b\u305f\u3081\u306e\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002\r\n\r\n\u4eca\u56de\u306f\u5b9f\u88c5\u3057\u307e\u305b\u3093\u304c\u3001\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u30de\u30fc\u30b8\u3057\u3066\u4f7f\u7528\u3057\u305f\u3044\u5834\u5408\u306f\u8907\u6570\u3082View\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3001Model\u30d5\u30a1\u30a4\u30eb\u3067\u30de\u30fc\u30b8\u51e6\u7406\u306e\u5b9a\u7fa9\u3092\u884c\u3044\u307e\u3059\u3002\r\n\r\n\u4e0b\u8a18\u304c\u4eca\u56de\u4f7f\u7528\u3059\u308bModel\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002\u300cconnection:~\u300d\u3067\u306f\u3001Looker\u304c\u3069\u306e\u30c6\u30fc\u30d6\u30eb\u3001\u3069\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3068\u63a5\u7d9a\u3059\u308b\u304b\u3092\u5ba3\u8a00\u3057\u307e\u3059\u3002\u300cinclude: &#8220;\/views\/\/*.view&#8221;\u300d\u3067\u306f\u4f5c\u6210\u3057\u305fView\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u3080\u305f\u3081\u306e\u51e6\u7406\u3067\u3059\u3002\u4eca\u56de\u306fviews\u3068\u3044\u3046\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u914d\u4e0b\u306b\u3042\u308bView\u30d5\u30a1\u30a4\u30eb\u3092\u5168\u3066\u8aad\u307f\u8fbc\u3080\u4ed5\u69d8\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u6700\u5f8c\u306b\u3001\u300cexplore: \u301c {}\u300d\u3092\u4f7f\u7528\u3057\u3001\u8aad\u307f\u8fbc\u3093\u3060View\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u3067\u3001\u4eca\u56de\u4f7f\u7528\u3059\u308b\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u5ba3\u8a00\u3092\u884c\u3044\u307e\u3059\u3002\u4eee\u306b\u3001\u300cinclude: &#8220;\/views\/\/*.view&#8221;\u300d\u3067\u8aad\u307f\u8fbc\u3093\u3067\u3082\u300cexplore: \u301c {}\u300d\u3067\u5ba3\u8a00\u3057\u306a\u3044\u3068\u3001Looker\u4e0a\u3067\u306f\u6271\u3046\u3053\u3068\u304c\u3067\u304d\u306a\u3044\u306e\u3067\u6ce8\u610f\u3067\u3059\u3002\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>connection: \"\" \r\n\r\n# include all the views \r\ninclude: \"\/views\/**\/*.view\" \r\n\r\nexplore: mansion_dataset {}<\/code><\/pre>\r\n<\/div>\n\n<h2>\u307e\u3068\u3081<\/h2>\n\u4eca\u56deView\u30d5\u30a1\u30a4\u30eb\u3068Model\u30d5\u30a1\u30a4\u30eb\u3092\u5b9f\u88c5\u3057\u3001Bigquery\u306e\u30c7\u30fc\u30bf\u3092Looker\u4e0a\u3067\u6271\u3046\u305f\u3081\u306e\u74b0\u5883\u69cb\u7bc9\u3092\u884c\u3044\u307e\u3057\u305f\u3002\u6b21\u56de\u306e\u8a18\u4e8b\u304b\u3089\u306f\u5b9f\u969b\u306b\u3069\u306e\u3088\u3046\u306b\u3057\u3066Looker\u4e0a\u3067\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30ba\u3092\u884c\u3063\u3066\u3044\u304f\u306e\u304b\u3092\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059<span data-token-index=\"1\" class=\"discussion-level-1 discussion-id-0ba01aa1-aac2-4273-ab90-957bce017f0b notion-enable-hover\">\u3002<\/span>\r\n\r\n<blockquote class=\"wp-embedded-content\" data-secret=\"mAk4Nb9NcT\"><a href=\"https:\/\/blog.since2020.jp\/bi\/looker_guide_part2\/\">\u3010Looker\u306e\u4f7f\u3044\u65b9\u30ac\u30a4\u30c9\u3011\u8868\u306b\u3088\u308b\u53ef\u8996\u5316<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;\u3010Looker\u306e\u4f7f\u3044\u65b9\u30ac\u30a4\u30c9\u3011\u8868\u306b\u3088\u308b\u53ef\u8996\u5316&#8221; &#8212; Data Driven Knowledgebase\" src=\"https:\/\/blog.since2020.jp\/bi\/looker_guide_part2\/embed\/#?secret=zHXCmJGkY2#?secret=mAk4Nb9NcT\" data-secret=\"mAk4Nb9NcT\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>","protected":false},"excerpt":{"rendered":"<p>Looker\u306fGoogle Cloud Platform\u306e\u30c7\u30fc\u30bf\u5206\u6790\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u3001\u30c7\u30fc\u30bf\u53ce\u96c6\u304b\u3089\u53ef\u8996\u5316\u307e\u3067\u3092\u7c21\u5358\u306b\u884c\u3048\u307e\u3059\u3002\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3001Looker\u3067\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306aModel [&hellip;]<\/p>\n","protected":false},"author":85,"featured_media":1794,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","swell_btn_cv_data":"","footnotes":"","_wp_rev_ctl_limit":""},"categories":[1246],"tags":[258,108,61,58,39],"class_list":{"0":"post-3485","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-data-infrastructure","8":"tag-bi","9":"tag-bigquery","11":"tag-looker","12":"tag-39"},"_links":{"self":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/3485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/users\/85"}],"replies":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/comments?post=3485"}],"version-history":[{"count":0,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/3485\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media\/1794"}],"wp:attachment":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media?parent=3485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/categories?post=3485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/tags?post=3485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}