連接到印度生物技術部雲|磚在穀歌的雲<gydF4y2Ba/title> <link href="https://agao00.github.io/static/css/2.fb64e31e.chunk.css" rel="stylesheet"> <link href="https://agao00.github.io/static/css/main.06d416f3.chunk.css" rel="stylesheet"> <link rel="stylesheet" href="//www.eheci.com/docs.gcp/_static/css/theme.css" type="text/css"> <link rel="stylesheet" href="//www.eheci.com/docs.gcp/_static/css/custom.css" type="text/css"> <link rel="stylesheet" href="//www.eheci.com/docs.gcp/_static/css/algolia.css" type="text/css"> <link rel="stylesheet" href="//www.eheci.com/docs.gcp/_static/css/cloud-provider-selector.css" type="text/css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/80c8c516-6f89-11eb-883d-06d762ad9a62/searchbox.css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/80c8c516-6f89-11eb-883d-06d762ad9a62/external_styles.css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/80c8c516-6f89-11eb-883d-06d762ad9a62/feedback.css"> </head> <body class="wy-body-for-nav Connect to dbt Cloud" role="document">  <noscript> <iframe src="https://www.eheci.com/ns.html?id=GTM-T85FQ33" height="0" width="0" style="display:none;visibility:hidden"></iframe> </noscript> <noscript> <iframe src="https://www.eheci.com/ns.html?id=GTM-TWTKQQ" height="0" width="0" style="display:none;visibility:hidden"></iframe> </noscript>  <nav class="wy-nav-top header su_header" role="navigation" aria-label="top navigation"> <nav class="wy-nav-top header su_header" role="navigation" aria-label="top navigation"> <div class="container-logo"> <ul class="mobile-menu-toggle"> <li class="menu-toggle"><i data-toggle="wy-nav-top" class="wy-nav-top-menu-button db-icon db-icon-menu pull-left"></i><a href="//www.eheci.com/" class="wy-nav-top-logo"><img src="//www.eheci.com/docs.gcp/_static/databricks-logo-mobile.png" width="137" height="21" alt="磚gydF4y2Ba"></a></li> </ul> <ul class="su_nav-menu"> <li class="menu-toggle"><i data-toggle="wy-nav-top" class="wy-nav-top-menu-button db-icon db-icon-menu pull-left"></i><a href="//www.eheci.com/" class="wy-nav-top-logo"><img src="//www.eheci.com/docs.gcp/_static/databricks-logo-mobile.png" width="137" height="21" alt="磚gydF4y2Ba"></a></li> </ul> </div> <div class="su_nav-right"> <ul class="su_link-mobile">  </ul> <ul class="right-try-list"> <li><a href="//www.eheci.com/help">支持<gydF4y2Ba/a></li> <li><a href="mailto:doc-feedback@www.eheci.com?subject=Documentation Feedback">反饋<gydF4y2Ba/a></li> <li class="try-databrick-item"><a href="//www.eheci.com/docs.gcp/try-databricks">試著磚<gydF4y2Ba/a></li> </ul> </div> </nav> </nav> <div class="su_sub-header"> <div class="container"> <div class="su_sub-header-inner"> <div class="su_subnav-menu"> <ul> <li><a href="//www.eheci.com/help/s/">幫助中心<gydF4y2Ba/a></li> <li class="active"><a href="//www.eheci.com/docs.gcp/">文檔<gydF4y2Ba/a></li> <li><a href="//www.eheci.com/kb.gcp/">知識庫<gydF4y2Ba/a></li> </ul> </div> <div class="su_subnav-menu-right"> <div id="auto" style="width: 100%"> <div ng-controller="SearchautoController"> <div bind-html-compile="autocompleteHtml"> <form class="su__search-box-1"> <input class="su__search-input" type="search" name="Search box" id="su__search-b" placeholder="Search here"> <button class="button button-success" type="submit" on> <svg width="20" height="20" viewbox="0 0 28 28"> <path fill="#fff" d="M1688.27,61.271a1.327,1.327,0,0,1,0,1.859l-1.54,1.531a1.25,1.25,0,0,1-.93.383,1.282,1.282,0,0,1-.93-0.383l-5.46-5.469a1.254,1.254,0,0,1-.39-0.93V57.388a11.4,11.4,0,0,1-12.71.875,11.5,11.5,0,0,1-4.13-4.129,11.438,11.438,0,0,1,0-11.43,11.5,11.5,0,0,1,4.13-4.129,11.431,11.431,0,0,1,11.43,0,11.5,11.5,0,0,1,4.13,4.129,11.4,11.4,0,0,1-.88,12.715h0.88a1.282,1.282,0,0,1,.93.383Zm-16.25-5.852a6.952,6.952,0,0,0,3.53-.93,6.772,6.772,0,0,0,2.54-2.543,7.154,7.154,0,0,0,0-7.055,6.772,6.772,0,0,0-2.54-2.543,7.147,7.147,0,0,0-7.05,0,6.8,6.8,0,0,0-2.55,2.543,7.154,7.154,0,0,0,0,7.055,6.8,6.8,0,0,0,2.55,2.543A6.916,6.916,0,0,0,1672.02,55.419Z" transform="translate(-1660.66 -37.031)"></path> </svg></button> </form> </div> </div> </div> </div> <div> <select name="cloud provider selector" id="cloud-provider-selector"><option value="awsgydF4y2Ba">亞馬遜網絡服務<gydF4y2Ba/option><option value="azuregydF4y2Ba">微軟Azure<gydF4y2Ba/option><option value="gcpgydF4y2Ba" selected>穀歌雲平台Beplay体育安卓版本<gydF4y2Ba/option></select> </div> </div> </div> </div> <page class="js-page-container"> <nav data-toggle="wy-nav-shift" class="wy-nav-side su_nav-side"> <div class="wy-side-scroll"> <div class="wy-side-nav-search"></div> <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation"> <a href="//www.eheci.com/docs.gcp/index.html" class="main-navigation-home">磚在穀歌的雲<gydF4y2Ba/a> <p class="caption"><span class="caption-text">開始<gydF4y2Ba/span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/getting-started/index.html">開始<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/introduction/index.html">磚是什麼?<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/getting-started/tutorials/index.html">教程和最佳實踐<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/release-notes/index.html">發布說明<gydF4y2Ba/a></li> </ul> <p class="caption"><span class="caption-text">加載和管理數據<gydF4y2Ba/span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/ingestion/index.html">加載數據<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/exploratory-data-analysis/index.html">探索數據<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/data-preparation/index.html">準備數據<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/data-sharing/index.html">共享數據(δ共享)<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/marketplace/index.html">市場數據<gydF4y2Ba/a></li> </ul> <p class="caption"><span class="caption-text">處理數據<gydF4y2Ba/span></p> <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/workspace-index.html">工程數據<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/machine-learning/index.html">機器學習<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/sql/index.html">數據倉庫<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/delta/index.html">三角洲湖<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/dev-tools/index.html">開發人員工具<gydF4y2Ba/a></li> <li class="toctree-l1 current"><a class="reference internal" href="//www.eheci.com/docs.gcp/integrations/index.html">技術合作夥伴<gydF4y2Ba/a> <ul class="current"> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/index.html">合作夥伴聯係<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/integrations/jdbc-odbc-bi.html">配置ODBC、JDBC驅動程序<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/ingestion.html">攝入<gydF4y2Ba/a></li> <li class="toctree-l2 current"><a class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/prep.html">數據準備和轉換<gydF4y2Ba/a> <ul class="current"> <li class="toctree-l3 current"><a class="current reference internal" href="//www.eheci.com/docs.gcp/partners/prep/#">印度生物技術部的雲<gydF4y2Ba/a></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/partners/prep/dbt.html">印度生物技術部核心<gydF4y2Ba/a></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/partners/prep/prophecy.html">預言<gydF4y2Ba/a></li> </ul></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/ml.html">機器學習<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/bi.html">BI和可視化<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/reverse-etl.html">反向ETL<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/semantic-layer.html">語義層<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/data-governance.html">數據治理<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/integrations/excel.html">連接到數據磚從Microsoft Excel<gydF4y2Ba/a></li> </ul></li> </ul> <p class="caption"><span class="caption-text">政府<gydF4y2Ba/span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/administration-guide/index.html">賬戶和工作區管理<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/security/index.html">安全性和遵從性<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/data-governance/index.html">數據治理<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/lakehouse-architecture/index.html">Lakehouse架構<gydF4y2Ba/a></li> </ul> <p class="caption"><span class="caption-text">引用和資源<gydF4y2Ba/span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/reference/api.html">參考<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/resources/index.html">資源<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/whats-coming.html">未來是什麼?<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/archive/index.html">文檔歸檔<gydF4y2Ba/a></li> </ul> </div> <div role="contentinfo"> <p class="build_info" data-last-edit="July 18, 2023">2023年7月21日更新<gydF4y2Ba/p> <p><a id="feedbacklink" href="mailto:doc-feedback@www.eheci.com?subject=Documentation Feedback">給我們反饋<gydF4y2Ba/a></p> </div> </div> </nav> <main class="wy-grid-for-nav su_nav-grid"> <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap"> <div class="wy-nav-content su__nav_content"> <div class="rst-content"> <div role="navigation" aria-label="breadcrumbs navigation" class="wy-breadcrumbs-wrapper"> <ul class="wy-breadcrumbs"> <li><a href="//www.eheci.com/docs.gcp/index.html">文檔<gydF4y2Ba/a><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.eheci.com/docs.gcp/integrations/index.html">技術合作夥伴<gydF4y2Ba/a><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.eheci.com/docs.gcp/partner-connect/prep.html">連接到數據準備合作夥伴使用合作夥伴連接<gydF4y2Ba/a><span class="db-icon db-icon-chevron-right"></span></li> <li>連接到印度生物技術部雲<gydF4y2Ba/li> <li class="wy-breadcrumbs-aside"></li> </ul> </div> <div role="main" class="document" itemscope itemtype="http://schema.org/Article"> <div itemprop="articleBody"> <div class="section" id="connect-to-dbt-cloud"> <h1>連接到印度生物技術部雲<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#connect-to-dbt-cloud" title=""></a></h1> <p>印度生物技術部(數據構建工具)是一個開發環境,使數據分析師和數據工程師將數據通過簡單的select語句。印度生物技術部處理這些select語句表和視圖。印度生物技術部將代碼編譯為原始SQL,然後運行該代碼指定的數據庫中數據磚。印度生物技術部支持協作編碼beplay娱乐ios模式和最佳實踐,如版本控製、文檔和模塊化。<gydF4y2Ba/p> <p>印度生物技術部不提取或加載數據。印度生物技術部隻專注於轉換步驟,使用“轉換後加載”架構。印度生物技術部假設您已經有一個複製數據庫中的數據。<gydF4y2Ba/p> <p>本文主要關注印度生物技術部雲。印度生物技術部雲配有交鑰匙支持調度工作,CI / CD,服務文檔,監控和警報,以及一個集成開發環境(IDE)。<gydF4y2Ba/p> <p>印度生物技術部的本地版本稱為印度生物技術部核心也是可用的。印度生物技術部核心使您能夠編寫印度生物技術部代碼在您所選的文本編輯器或IDE本地開發機器上,然後從命令行運行印度生物技術部。印度生物技術部核心包括印度生物技術部命令行接口(CLI)。印度生物技術部CLI是免費使用的,開源的。有關更多信息,請參見<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/partners/prep/dbt.html"><span class="doc">連接到印度生物技術部核心<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <p>因為印度生物技術部雲和印度生物技術部核心可以使用托管git存儲庫(例如,在GitHub, GitLab或BitBucket都),您可以使用印度生物技術部雲來創建一個印度生物技術部項目,然後提供給你的印度生物技術部雲和印度生物技術部核心用戶。有關更多信息,請參見<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/projects">創建一個印度生物技術部項目<gydF4y2Ba/a>和<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/projects">使用現有的項目<gydF4y2Ba/a>印度生物技術部的網站上。<gydF4y2Ba/p> <p>印度生物技術部的一般概述,請看下麵的YouTube視頻(26分鍾)。<gydF4y2Ba/p> <p></p> <iframe width="640" height="360" style="margin-bottom: 25px" src="https://www.youtube.com/embed/zoHoIGE6tPc?rel=0" frameborder="0" allowfullscreen="1"> </iframe> <p></p> <div class="section" id="connect-to-dbt-cloud-using-partner-connect"> <span id="connect-to-dbt-cloud-using-pc"></span> <span id="partner-connect"></span> <h2>使用合作夥伴連接連接到印度生物技術部雲<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#connect-to-dbt-cloud-using-partner-connect" title=""></a></h2> <p>本節描述如何連接磚SQL的倉庫使用合作夥伴連接印度生物技術部雲,然後給印度生物技術部雲讀訪問你的數據。<gydF4y2Ba/p> <div class="section" id="differences-between-standard-connections-and-dbt-cloud"> <span id="differences"></span> <h3>標準連接和印度生物技術部雲之間的區別<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#differences-between-standard-connections-and-dbt-cloud" title=""></a></h3> <p>使用合作夥伴連接連接到印度生物技術部雲,你遵循的步驟<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/prep.html"><span class="doc">連接到數據準備合作夥伴使用合作夥伴連接<gydF4y2Ba/span></a>。印度生物技術部雲連接是不同於標準的數據準備和轉換連接在以下方式:<gydF4y2Ba/p> <ul class="simple"> <li><p>除了一個服務主體和個人訪問令牌,合作夥伴連接創建一個SQL倉庫(原SQL端點)命名<gydF4y2Bastrong>DBT_CLOUD_ENDPOINT<gydF4y2Ba/strong>默認情況下。<gydF4y2Ba/p></li> </ul> </div> <div class="section" id="steps-to-connect"> <span id="partner-connect-steps"></span> <h3>步驟來連接<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#steps-to-connect" title=""></a></h3> <p>使用合作夥伴連接連接到印度生物技術部雲,做到以下幾點:<gydF4y2Ba/p> <ol class="arabic"> <li><p><a class="reference internal" href="//www.eheci.com/docs.gcp/partner-connect/prep.html"><span class="doc">連接到數據準備合作夥伴使用合作夥伴連接<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> <li><p>在您連接到印度生物技術部雲,印度生物技術部雲儀表板出現。探索印度生物技術部雲項目,在菜單欄中,印度生物技術部標誌旁邊,從第一個下拉選擇你的印度生物技術部賬戶名稱如果不顯示出來,然後選擇<gydF4y2Bastrong>磚夥伴連接試驗<gydF4y2Ba/strong>項目從第二個下拉菜單如果不顯示。<gydF4y2Ba/p> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>查看項目的設置,單擊“三條紋”或“漢堡包”菜單,點擊<gydF4y2Bastrong>帳戶設置>項目<gydF4y2Ba/strong>項目的名稱,然後單擊。查看連接設置,點擊旁邊的鏈接<gydF4y2Bastrong>連接<gydF4y2Ba/strong>。要更改任何設置,點擊<gydF4y2Bastrong>編輯<gydF4y2Ba/strong>。<gydF4y2Ba/p> <p>把磚個人訪問令牌信息對於這個項目,單擊菜單欄上的“人”圖標,點擊<gydF4y2Bastrong>概要文件>憑證>磚夥伴連接試驗<gydF4y2Ba/strong>項目的名稱,然後單擊。要做出改變,單擊<gydF4y2Bastrong>編輯<gydF4y2Ba/strong>。<gydF4y2Ba/p> </div></li> </ol> </div> <div class="section" id="steps-to-give-dbt-cloud-read-access-to-your-data"> <span id="read-access"></span> <h3>步驟給印度生物技術部雲讀訪問您的數據<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#steps-to-give-dbt-cloud-read-access-to-your-data" title=""></a></h3> <p>合作夥伴將允許隻創建連接到<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>隻在默認目錄服務主體。按照以下步驟在您的磚工作區給<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>服務主體讀訪問權你選擇的數據。<gydF4y2Ba/p> <div class="admonition warning"> <p class="admonition-title">警告<gydF4y2Ba/p> <p>您可以調整這些步驟給印度生物技術部雲額外的訪問在目錄、數據庫和表在你的工作區。然而,作為一個安全最佳實踐,磚強烈建議你給訪問單獨的表,你需要<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>服務主體與和隻讀訪問這些表。<gydF4y2Ba/p> </div> <ol class="arabic"> <li><p>您的工作區切換到<gydF4y2Bastrong>SQL<gydF4y2Ba/strong>的角色。要做到這一點,在你的工作空間的側邊欄,單擊圖標下麵磚的標誌<gydF4y2Baimg alt="磚的標誌gydF4y2Ba" src="//www.eheci.com/docs.gcp/_images/databricks-logo.png">,然後選擇<gydF4y2Bastrong>SQL<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>點擊<gydF4y2Baimg alt="數據圖標gydF4y2Ba" src="//www.eheci.com/docs.gcp/_images/data-icon.png"><strong>數據<gydF4y2Ba/strong>在側邊欄。<gydF4y2Ba/p></li> <li><p>選擇SQL倉庫(<gydF4y2Bastrong>DBT_CLOUD_ENDPOINT<gydF4y2Ba/strong>頂部的下拉列表)。<gydF4y2Ba/p> <div class="figure align-default"> <img alt="選擇倉庫gydF4y2Ba" src="//www.eheci.com/docs.gcp/_images/select-endpoint.png"> </div> <ol class="loweralpha simple"> <li><p>下<gydF4y2Bastrong>數據瀏覽<gydF4y2Ba/strong>,選擇的目錄,其中包含數據庫表。<gydF4y2Ba/p></li> <li><p>選擇包含您的數據庫表。<gydF4y2Ba/p></li> <li><p>選擇您的表。<gydF4y2Ba/p></li> </ol> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>如果您沒有看到您的目錄、數據庫或表列出,輸入名稱的任何部分<gydF4y2Bastrong>選擇目錄<gydF4y2Ba/strong>,<gydF4y2Bastrong>選擇數據庫<gydF4y2Ba/strong>,或<gydF4y2Bastrong>過濾表<gydF4y2Ba/strong>列表框,分別來縮小。<gydF4y2Ba/p> <div class="figure align-default"> <img alt="過濾表gydF4y2Ba" src="//www.eheci.com/docs.gcp/_images/filter-tables.png"> </div> </div></li> <li><p>點擊<gydF4y2Bastrong>權限<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>點擊<gydF4y2Bastrong>格蘭特<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>類型添加多個用戶或組<gydF4y2Ba/strong>中,選擇<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>。這個磚服務主體的合作夥伴為你在前一節中創建連接。<gydF4y2Ba/p> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>如果您沒有看到<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>,開始打字<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">DBT_CLOUD_USER<gydF4y2Ba/span></code>在<gydF4y2Bastrong>類型添加多個用戶或組<gydF4y2Ba/strong>盒子,直到它出現在列表中,然後選擇它。<gydF4y2Ba/p> </div></li> <li><p>隻有選擇授予讀訪問<gydF4y2Bastrong>選擇<gydF4y2Ba/strong>和<gydF4y2Bastrong>READ_METADATA<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>點擊<gydF4y2Bastrong>好吧<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> </ol> <p>重複步驟4 - 9日為每個額外的表,你想給印度生物技術部雲讀訪問權。<gydF4y2Ba/p> </div> <div class="section" id="troubleshoot-the-dbt-cloud-connection"> <span id="troubleshoot-partner-connect"></span> <h3>排除印度生物技術部雲連接<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#troubleshoot-the-dbt-cloud-connection" title=""></a></h3> <p>如果有人刪除的項目在印度生物技術部雲賬戶,你點擊<gydF4y2Bastrong>印度生物技術部<gydF4y2Ba/strong>瓷磚,則會出現一條錯誤消息,指出項目無法找到。為了解決這個問題,點擊<gydF4y2Bastrong>刪除連接<gydF4y2Ba/strong>這個過程,然後從頭開始再次創建連接。<gydF4y2Ba/p> </div> </div> <div class="section" id="connect-to-dbt-cloud-manually"> <span id="manual-connection"></span> <h2>手動連接到印度生物技術部雲<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#connect-to-dbt-cloud-manually" title=""></a></h2> <p>本節描述如何連接磚集群或磚SQL倉庫磚工作區印度生物技術部雲。<gydF4y2Ba/p> <div class="admonition important"> <p class="admonition-title">重要的<gydF4y2Ba/p> <p>磚建議連接到SQL的倉庫。如果你沒有磚的SQL訪問權利,或者如果你想運行Python模型,您可以連接到一個集群。<gydF4y2Ba/p> </div> <div class="section" id="requirements"> <span id="manual-requirements"></span> <h3>需求<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#requirements" title=""></a></h3> <ul> <li><p>一個集群或SQL倉庫在磚工作區。<gydF4y2Ba/p> <ul class="simple"> <li><p><a class="reference internal" href="//www.eheci.com/docs.gcp/clusters/configure.html"><span class="doc">創建一個集群<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> <li><p><a class="reference internal" href="//www.eheci.com/docs.gcp/sql/admin/create-sql-warehouse.html"><span class="doc">配置SQL倉庫<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> </ul></li> <li><p>集群或SQL的連接細節倉庫,專門的<gydF4y2Bastrong>服務器主機名<gydF4y2Ba/strong>,<gydF4y2Bastrong>港口<gydF4y2Ba/strong>,<gydF4y2Bastrong>HTTP路徑<gydF4y2Ba/strong>值。<gydF4y2Ba/p> <ul class="simple"> <li><p><a class="reference internal" href="//www.eheci.com/docs.gcp/integrations/jdbc-odbc-bi.html"><span class="std std-ref">獲得一個集群的連接細節<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> <li><p><a class="reference internal" href="//www.eheci.com/docs.gcp/integrations/jdbc-odbc-bi.html"><span class="std std-ref">得到一個SQL的連接細節,倉庫<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> </ul></li> <li><p>一個磚<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/dev-tools/auth.html"><span class="std std-ref">個人訪問令牌<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <div class="admonition note"> <p class="admonition-title">請注意<gydF4y2Ba/p> <p>安全最佳實踐,當您使用自動化工具進行身份驗證,係統中,腳本和應用程序,磚屬於建議您使用個人訪問令牌<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/administration-guide/users-groups/service-principals.html"><span class="doc">服務主體<gydF4y2Ba/span></a>而不是用戶工作區。為服務主體,創建令牌<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/administration-guide/users-groups/service-principals.html"><span class="std std-ref">管理個人訪問令牌服務主體<gydF4y2Ba/span></a>。<gydF4y2Ba/p> </div></li> </ul> <ul> <li><p>連接印度生物技術部雲數據管理的統一目錄,印度生物技術部版本1.1或更高版本。<gydF4y2Ba/p><p>本文中的步驟創建一個新的環境,印度生物技術部使用最新版本。印度生物技術部版本升級現有的信息環境,明白了<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-versions/upgrade-core-in-cloud">升級到最新版本的印度生物技術部在雲<gydF4y2Ba/a>印度生物技術部的文檔。<gydF4y2Ba/p></li> </ul> </div> <div class="section" id="step-1-sign-up-for-dbt-cloud"> <span id="sign-up"></span> <h3>第一步:注冊印度生物技術部雲<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#step-1-sign-up-for-dbt-cloud" title=""></a></h3> <p>去<gydF4y2Baa class="reference external" href="https://www.getdbt.com/signup/">印度生物技術部雲-注冊<gydF4y2Ba/a>輸入您的電子郵件,姓名和公司信息。創建一個密碼,然後單擊<gydF4y2Bastrong>創建我的帳戶<gydF4y2Ba/strong>。<gydF4y2Ba/p> </div> <div class="section" id="step-2-create-a-dbt-project"> <span id="create-project"></span> <h3>步驟2:創建一個印度生物技術部項目<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#step-2-create-a-dbt-project" title=""></a></h3> <p>在這個步驟中,您創建一個印度生物技術部<gydF4y2Baem>項目<gydF4y2Ba/em>,其中包含一個連接到一個磚集群或SQL的倉庫,一個存儲庫,其中包含源代碼,和一個或多個環境(如測試和生產環境)。<gydF4y2Ba/p> <ol class="arabic"> <li><p><a class="reference external" href="https://cloud.getdbt.com/login/">在印度生物技術部雲跡象<gydF4y2Ba/a>。<gydF4y2Ba/p></li> <li><p>點擊設置圖標,然後單擊<gydF4y2Bastrong>帳戶設置<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>點擊<gydF4y2Bastrong>新項目<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>的名字<gydF4y2Ba/strong>輸入惟一名稱為您的項目,然後單擊<gydF4y2Bastrong>繼續<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>選擇一個倉庫<gydF4y2Ba/strong>,點擊<gydF4y2Bastrong>磚<gydF4y2Ba/strong>,然後單擊<gydF4y2Bastrong>下一個<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>的名字<gydF4y2Ba/strong>這個連接,輸入一個唯一的名稱。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>選擇適配器<gydF4y2Ba/strong>中,選擇<gydF4y2Bastrong>磚(dbt-databricks)<gydF4y2Ba/strong>。<gydF4y2Ba/p> <div class="admonition note"> <p class="admonition-title">請注意<gydF4y2Ba/p> <p>默認情況下,新項目使用磚(dbt-databricks)的適配器,它支持統一目錄。現有項目遷移到磚(dbt-databricks),看到的<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/guides/migration/tools/migrating-from-spark-to-databricks">從dbt-spark遷移到dbt-databricks<gydF4y2Ba/a>印度生物技術部的文檔。<gydF4y2Ba/p> </div></li> <li><p>為<gydF4y2Bastrong>服務器主機名<gydF4y2Ba/strong>中,輸入服務器主機名的價值需求。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>HTTP路徑<gydF4y2Ba/strong>,輸入HTTP路徑值的要求。<gydF4y2Ba/p></li> <li><p>如果你的工作區Catalog-enabled統一,<gydF4y2Bastrong>可選設置<gydF4y2Ba/strong>,為印度生物技術部雲輸入目錄的名稱使用。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>令牌<gydF4y2Ba/strong>從需求,輸入個人訪問令牌。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>模式<gydF4y2Ba/strong>輸入模式的名稱,你想要印度生物技術部雲創建表和視圖(例如,<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默認的<gydF4y2Ba/span></code>)。<gydF4y2Ba/p></li> <li><p>點擊<gydF4y2Bastrong>測試連接<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>如果測試成功,單擊<gydF4y2Bastrong>繼續<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> </ol> <p></p> <p></p> <p>有關更多信息,請參見<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-configuring-dbt-cloud/connecting-your-database">連接到數據磚ODBC<gydF4y2Ba/a>印度生物技術部的網站上。<gydF4y2Ba/p> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>為這個項目查看或更改設置,或刪除項目,點擊設置圖標,點擊<gydF4y2Bastrong>帳戶設置>項目<gydF4y2Ba/strong>項目的名稱,然後單擊。要更改設置,請單擊<gydF4y2Bastrong>編輯<gydF4y2Ba/strong>。刪除該項目,點擊<gydF4y2Bastrong>編輯>刪除項目<gydF4y2Ba/strong>。<gydF4y2Ba/p> <p>查看或改變你的磚個人訪問令牌的值對於這個項目,單擊“人”圖標,點擊<gydF4y2Bastrong>概要文件>憑證<gydF4y2Ba/strong>項目的名稱,然後單擊。要做出改變,單擊<gydF4y2Bastrong>編輯<gydF4y2Ba/strong>。<gydF4y2Ba/p> </div> <p>後連接到一個磚集群或磚SQL倉庫,按照屏幕上的指示<gydF4y2Bastrong>建立一個庫<gydF4y2Ba/strong>然後點擊<gydF4y2Bastrong>繼續<gydF4y2Ba/strong>。<gydF4y2Ba/p> <p>設置存儲庫之後,按照屏幕上的指示邀請用戶,然後單擊<gydF4y2Bastrong>完整的<gydF4y2Ba/strong>。或者點擊<gydF4y2Bastrong>跳過&完成<gydF4y2Ba/strong>。<gydF4y2Ba/p> <p>繼續本教程或下一個步驟。<gydF4y2Ba/p> </div> </div> <div class="section" id="tutorial"> <h2>教程<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#tutorial" title=""></a></h2> <p>在本節中,您使用您的印度生物技術部雲項目使用一些樣例數據。本節假設您已經創建了您的項目,印度生物技術部雲IDE打開該項目。<gydF4y2Ba/p> <div class="section" id="step-1-create-and-run-models"> <span id="create-model"></span> <h3>步驟1:創建和運行模式<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#step-1-create-and-run-models" title=""></a></h3> <p>在這個步驟中,您使用印度生物技術部雲IDE創建和運行<gydF4y2Baem>模型<gydF4y2Ba/em>,這是<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">選擇<gydF4y2Ba/span></code>語句創建一個新視圖(默認)或一個新表在數據庫中,基於現有的數據在同一數據庫中。這個程序創建一個模型基於樣本<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">鑽石<gydF4y2Ba/span></code>表的<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/dbfs/databricks-datasets.html"><span class="doc">樣本數據集<gydF4y2Ba/span></a>,如所描述的<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/getting-started/quick-start.html"><span class="std std-ref">創建一個表<gydF4y2Ba/span></a>的部分<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/getting-started/quick-start.html"><span class="doc">與筆記本電腦教程:查詢數據<gydF4y2Ba/span></a>。這個過程假定這個表已經在工作區中創建的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默認的<gydF4y2Ba/span></code>數據庫。<gydF4y2Ba/p> <ol class="arabic"> <li><p>與項目打開,點擊<gydF4y2Bastrong>開始開發<gydF4y2Ba/strong>。<gydF4y2Ba/p> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>如果<gydF4y2Bastrong>開始開發<gydF4y2Ba/strong>按鈕不顯示,點擊<gydF4y2Bastrong>開發<gydF4y2Ba/strong>在“三條紋”或“漢堡包”菜單。<gydF4y2Ba/p> </div></li> <li><p>在<gydF4y2Bastrong>項目<gydF4y2Ba/strong>窗格中,單擊<gydF4y2Bastrong>初始化您的項目<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>創建第一個模型:單擊<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夾,單擊省略號,然後單擊<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>輸入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ diamonds_four_cs.sql<gydF4y2Ba/span></code>並點擊<gydF4y2Bastrong>創建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_four_cs.sql<gydF4y2Ba/span></code>文件,輸入下麵的SQL語句,然後單擊<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。這種說法隻選擇克拉,切割、顏色和清晰的細節為每個鑽石<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">鑽石<gydF4y2Ba/span></code>表。的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置<gydF4y2Ba/span></code>塊指示印度生物技術部在數據庫中創建一個表基於此聲明。<gydF4y2Ba/p> <div class="highlight-default notranslate"> <div class="highlight"> <pre><span></span><span class="p">{{<gydF4y2Ba/span><span class="n">配置<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">物化<gydF4y2Ba/span><span class="o">=<gydF4y2Ba/span><span class="s1">“表”<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="n">file_format<gydF4y2Ba/span><span class="o">=<gydF4y2Ba/span><span class="s1">“δ”<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="p">}}<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="n">克拉<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">減少<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">顏色<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">清晰<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">鑽石<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>額外的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置<gydF4y2Ba/span></code>選項,如<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">合並<gydF4y2Ba/span></code>增量策略,看到<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/reference/resource-configs/databricks-configs">磚的配置<gydF4y2Ba/a>印度生物技術部的文檔。<gydF4y2Ba/p> </div></li> <li><p>創建第二個模型:在<gydF4y2Bastrong>項目<gydF4y2Ba/strong>窗格中,單擊<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夾,單擊省略號,然後單擊<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>輸入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ diamonds_list_colors.sql<gydF4y2Ba/span></code>並點擊<gydF4y2Bastrong>創建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_list_colors.sql<gydF4y2Ba/span></code>文件,輸入下麵的SQL語句,然後單擊<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。這個語句選擇獨特的值<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">顏色<gydF4y2Ba/span></code>列<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_four_cs<gydF4y2Ba/span></code>表,首先按字母順序排序的結果。因為沒有<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置<gydF4y2Ba/span></code>塊,該模型指導印度生物技術部在數據庫中創建一個視圖基於此聲明。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="k">截然不同的<gydF4y2Ba/span><span class="w"></span><span class="n">顏色<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_four_cs<gydF4y2Ba/span><span class="w"></span><span class="n">排序<gydF4y2Ba/span><span class="w"></span><span class="k">通過<gydF4y2Ba/span><span class="w"></span><span class="n">顏色<gydF4y2Ba/span><span class="w"></span><span class="k">asc<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>創建第三個模型:在<gydF4y2Bastrong>項目<gydF4y2Ba/strong>窗格中,單擊<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夾,單擊省略號,然後單擊<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>輸入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ diamonds_prices.sql<gydF4y2Ba/span></code>並點擊<gydF4y2Bastrong>創建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_prices.sql<gydF4y2Ba/span></code>文件,輸入下麵的SQL語句,然後單擊<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。這個語句平均鑽石價格的顏色,排序結果的平均價格從最高到最低。該模型指導印度生物技術部在數據庫中創建一個視圖基於此聲明。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="n">顏色<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="k">avg<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">價格<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">價格<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">鑽石<gydF4y2Ba/span><span class="w"></span><span class="k">集團<gydF4y2Ba/span><span class="w"></span><span class="k">通過<gydF4y2Ba/span><span class="w"></span><span class="n">顏色<gydF4y2Ba/span><span class="w"></span><span class="k">訂單<gydF4y2Ba/span><span class="w"></span><span class="k">通過<gydF4y2Ba/span><span class="w"></span><span class="n">價格<gydF4y2Ba/span><span class="w"></span><span class="k">desc<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>運行模式:在<gydF4y2Bastrong>運行<gydF4y2Ba/strong>盒子,運行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技術部<gydF4y2Ba/span><span class="pre">運行<gydF4y2Ba/span></code>與前三個文件路徑的命令。在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默認的<gydF4y2Ba/span></code>創建一個數據庫,辯證行為療法表命名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_four_cs<gydF4y2Ba/span></code>和兩個視圖命名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_list_colors<gydF4y2Ba/span></code>和<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_prices<gydF4y2Ba/span></code>。印度生物技術部得到這些相關的視圖和表名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">. sql<gydF4y2Ba/span></code>文件的名字。<gydF4y2Ba/p> <div class="highlight-bash notranslate"> <div class="highlight"> <pre><span></span>印度生物技術部/ diamonds_four_cs運行——模型模型。sql / diamonds_list_colors模型。sql模型/ diamonds_prices.sql<gydF4y2Ba/pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">…<gydF4y2Ba/span><span class="go">…| 1 3開始表模型default.diamonds_four_cs ....................(運行)<gydF4y2Ba/span><span class="go">…| 1 3創建好表模型default.diamonds_four_cs ...............(好吧…)<gydF4y2Ba/span><span class="go">…| 2 3開始視圖模型default.diamonds_list_colors .................(運行)<gydF4y2Ba/span><span class="go">…| 2 3好創建視圖模型default.diamonds_list_colors ............(好吧…)<gydF4y2Ba/span><span class="go">…| 3的3開始視圖模型default.diamonds_prices ......................(運行)<gydF4y2Ba/span><span class="go">…| 3的3好創建視圖模型default.diamonds_prices .................(好吧…)<gydF4y2Ba/span><span class="go">…|<gydF4y2Ba/span><span class="go">…|運行結束之後1表格模型,2視圖模型……<gydF4y2Ba/span><span class="go">成功完成<gydF4y2Ba/span><span class="go">完成了。通過= 3 = 0 = 0跳過錯誤警告總= 3 = 0<gydF4y2Ba/span></pre> </div> </div></li> <li><p>運行以下SQL代碼列表信息的新觀點和選擇從表中所有行和視圖。<gydF4y2Ba/p><p>如果你連接到一個集群,您可以運行這個SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/notebooks/notebooks-manage.html"><span class="std std-ref">筆記本<gydF4y2Ba/span></a>附加到集群中,指定SQL作為默認語言的筆記本。如果你連接到SQL的倉庫,你可以運行這個SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/sql/user/queries/queries.html"><span class="std std-ref">查詢<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">顯示<gydF4y2Ba/span><span class="w"></span><span class="n">的觀點<gydF4y2Ba/span><span class="w"></span><span class="k">在<gydF4y2Ba/span><span class="w"></span><span class="k">默認的<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">| |名稱空間viewName | isTemporary |<gydF4y2Ba/span><span class="go">+ = = = = = = = = = = = + = = = = = = = = = = = = = = = = = = = = = = + = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="go">| |違約diamonds_list_colors假| |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">| |違約diamonds_prices假| |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_four_cs<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">|克拉| |清晰| |顏色<gydF4y2Ba/span><span class="go">+ = = = = = = = + = = = = = = = = = + = = = = = = = + = = = = = = = = = +<gydF4y2Ba/span><span class="go">理想| 0.23 | | | E SI2 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">溢價| 0.21 | | | E SI1 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">…<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_list_colors<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - +<gydF4y2Ba/span><span class="go">| |顏色<gydF4y2Ba/span><span class="go">+ = = = = = = = +<gydF4y2Ba/span><span class="go">D | |<gydF4y2Ba/span><span class="go">+ - - - - - - - +<gydF4y2Ba/span><span class="go">| E |<gydF4y2Ba/span><span class="go">+ - - - - - - - +<gydF4y2Ba/span><span class="go">…<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_prices<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">| | |顏色價格<gydF4y2Ba/span><span class="go">+ = = = = = = = + = = = = = = = = = +<gydF4y2Ba/span><span class="go">J | | 5323.82 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">我| | 5091.87 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">…<gydF4y2Ba/span></pre> </div> </div></li> </ol> </div> <div class="section" id="step-2-create-and-run-more-complex-models"> <span id="complex-models"></span> <h3>步驟2:創建和運行更複雜的模型<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#step-2-create-and-run-more-complex-models" title=""></a></h3> <p>在這個步驟中,您創建更複雜的模型為一組相關的數據表。這些數據表包含的信息一個虛構的體育聯盟的三支球隊打一個賽季6場比賽。這個過程創建數據表,創建模型和運行模式。<gydF4y2Ba/p> <ol class="arabic"> <li><p>運行以下SQL代碼創建必要的數據表。<gydF4y2Ba/p><p>如果你連接到一個集群,您可以運行這個SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/notebooks/notebooks-manage.html"><span class="std std-ref">筆記本<gydF4y2Ba/span></a>附加到集群中,指定SQL作為默認語言的筆記本。如果你連接到SQL的倉庫,你可以運行這個SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/sql/user/queries/queries.html"><span class="std std-ref">查詢<gydF4y2Ba/span></a>。<gydF4y2Ba/p><p>這一步開始的表和視圖<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_<gydF4y2Ba/span></code>幫助確定他們作為這個示例的一部分。你不需要為自己的表和視圖遵循這種模式。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="k">如果<gydF4y2Ba/span><span class="w"></span><span class="k">存在<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="k">如果<gydF4y2Ba/span><span class="w"></span><span class="k">存在<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="k">如果<gydF4y2Ba/span><span class="w"></span><span class="k">存在<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="k">如果<gydF4y2Ba/span><span class="w"></span><span class="k">存在<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">創建<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">home_team_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_team_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">使用<gydF4y2Ba/span><span class="w"></span><span class="n">δ<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">4<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">5<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">6<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="c1">——結果:<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| game_id | home_team_id | visitor_team_id |<gydF4y2Ba/span><span class="c1">- + = = = = = = = = = + = = = = = = = = = = = = = = + = = = = = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="c1">——| 1 | 1 | 2 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 2 | 1 | 3 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 3 | 2 | 1 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 4 | 2 | 3 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 5 | 3 | 1 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 6 | 3 | 2 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="k">創建<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">home_team_score<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_team_score<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">使用<gydF4y2Ba/span><span class="w"></span><span class="n">δ<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">4<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">4<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">5<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">6<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="c1">——結果:<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| game_id | home_team_score | visitor_team_score |<gydF4y2Ba/span><span class="c1">- + = = = = = = = = = + = = = = = = = = = = = = = = = = = + = = = = = = = = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="c1">——| 1 | 4 | 2 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 2 | 0 | 1 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 3 | 1 | 2 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 4 | 3 | 2 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 5 | 3 | 0 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 6 | 3 | 1 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="k">創建<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">使用<gydF4y2Ba/span><span class="w"></span><span class="n">δ<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2020-12-12”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-01-09”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2020-12-19”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">4<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-01-16”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">5<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-01-23”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">6<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-02-06”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="c1">——結果:<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| game_id | game_date |<gydF4y2Ba/span><span class="c1">- + = = = = = = = = = + = = = = = = = = = = = = +<gydF4y2Ba/span><span class="c1">——| 1 | 2020-12-12 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 2 | 2021-01-09 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 3 | 2020-12-19 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 4 | 2021-01-16 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 5 | 2021-01-23 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 6 | 2021-02-06 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="k">創建<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="n">team_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">team_city<gydF4y2Ba/span><span class="w"></span><span class="nb">VARCHAR<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="mi">15<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">使用<gydF4y2Ba/span><span class="w"></span><span class="n">δ<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="ss">“舊金山”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="ss">“西雅圖”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="ss">“阿姆斯特丹”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="c1">——結果:<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| team_id | team_city |<gydF4y2Ba/span><span class="c1">- + = = = = = = = = = + = = = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="c1">舊金山——| 1 | |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">西雅圖——| 2 | |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">阿姆斯特丹- | 3 | |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span></pre> </div> </div></li> <li><p>創建第一個模型:在<gydF4y2Bastrong>項目<gydF4y2Ba/strong>窗格中,單擊<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夾,單擊省略號,然後單擊<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>輸入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ zzz_game_details.sql<gydF4y2Ba/span></code>並點擊<gydF4y2Bastrong>創建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details.sql<gydF4y2Ba/span></code>文件,輸入下麵的SQL語句,然後單擊<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。這條語句創建一個表,提供每個遊戲的細節,比如團隊的名字和分數。的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置<gydF4y2Ba/span></code>塊指示印度生物技術部在數據庫中創建一個表基於此聲明。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——創建一個表,提供全部細節為每個遊戲,包括<gydF4y2Ba/span><span class="c1">——遊戲ID,家裏來訪團隊的城市名稱和成績,<gydF4y2Ba/span><span class="c1">——遊戲的贏家的城市名稱,比賽日期。<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-default notranslate"> <div class="highlight"> <pre><span></span><span class="p">{{<gydF4y2Ba/span><span class="n">配置<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">物化<gydF4y2Ba/span><span class="o">=<gydF4y2Ba/span><span class="s1">“表”<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="n">file_format<gydF4y2Ba/span><span class="o">=<gydF4y2Ba/span><span class="s1">“δ”<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="p">}}<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">步驟4的4:遊客團隊id替換為他們的城市的名字。<gydF4y2Ba/span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_city<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">遊客<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">步驟3——4:顯示城市名稱為每個遊戲的贏家。<gydF4y2Ba/span><span class="w"></span><span class="k">情況下<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">當<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">然後<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">當<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">然後<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_city<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">結束<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">贏家<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">步驟2 - 4:主隊id替換為實際的城市名字。<gydF4y2Ba/span><span class="w"></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_city<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_team_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">步驟1 - 4:把數據從各種各樣的表(例如,遊戲和團隊id、分數、日期)。<gydF4y2Ba/span><span class="w"></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">去<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">home_team_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">gs<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">home_team_score<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">去<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">visitor_team_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">gs<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">visitor_team_score<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="k">去<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">gs<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">在哪裏<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="k">去<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="k">和<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">gs<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">all_ids<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">在哪裏<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">all_ids<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">home_team_id<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_id<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_ids<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="w"></span><span class="k">在哪裏<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_ids<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">visitor_team_id<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_id<gydF4y2Ba/span><span class="w"></span><span class="k">訂單<gydF4y2Ba/span><span class="w"></span><span class="k">通過<gydF4y2Ba/span><span class="w"></span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="k">desc<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>創建第二個模型:在<gydF4y2Bastrong>項目<gydF4y2Ba/strong>窗格中,單擊<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夾,單擊省略號,然後單擊<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>輸入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ zzz_win_loss_records.sql<gydF4y2Ba/span></code>並點擊<gydF4y2Bastrong>創建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_win_loss_records.sql<gydF4y2Ba/span></code>文件,輸入下麵的SQL語句,然後單擊<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。這個語句創建一個視圖列出了本賽季球隊輸贏記錄。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">創建一個視圖,總結本賽季的勝利和損失記錄團隊。<gydF4y2Ba/span><span class="c1">——2:步驟2計算的數量為每個團隊成功與失敗。<gydF4y2Ba/span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">贏家<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">團隊<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">數<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">贏家<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">贏了<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">——每個團隊打了4場比賽。<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">4<gydF4y2Ba/span><span class="w"></span><span class="o">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="k">數<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">贏家<gydF4y2Ba/span><span class="p">))<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">損失<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">步驟1——2:確定每個遊戲的贏家和輸家。<gydF4y2Ba/span><span class="w"></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">贏家<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">情況下<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">當<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">贏家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">然後<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">遊客<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">其他的<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">結束<gydF4y2Ba/span><span class="w"></span><span class="k">作為<gydF4y2Ba/span><span class="w"></span><span class="n">失敗者<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">集團<gydF4y2Ba/span><span class="w"></span><span class="k">通過<gydF4y2Ba/span><span class="w"></span><span class="n">贏家<gydF4y2Ba/span><span class="w"></span><span class="k">訂單<gydF4y2Ba/span><span class="w"></span><span class="k">通過<gydF4y2Ba/span><span class="w"></span><span class="n">贏了<gydF4y2Ba/span><span class="w"></span><span class="k">desc<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>運行模式:在<gydF4y2Bastrong>運行<gydF4y2Ba/strong>盒子,運行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技術部<gydF4y2Ba/span><span class="pre">運行<gydF4y2Ba/span></code>前兩個文件命令的路徑。在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默認的<gydF4y2Ba/span></code>數據庫(如項目設置中指定),印度生物技術部創建一個表命名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details<gydF4y2Ba/span></code>和一個視圖命名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_win_loss_records<gydF4y2Ba/span></code>。印度生物技術部得到這些相關的視圖和表名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">. sql<gydF4y2Ba/span></code>文件的名字。<gydF4y2Ba/p> <div class="highlight-bash notranslate"> <div class="highlight"> <pre><span></span>印度生物技術部/ zzz_game_details運行——模型模型。sql模型/ zzz_win_loss_records.sql<gydF4y2Ba/pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">…<gydF4y2Ba/span><span class="go">…| 1 2開始表模型default.zzz_game_details ....................(運行)<gydF4y2Ba/span><span class="go">…| 1 2創建好表模型default.zzz_game_details ...............(好吧…)<gydF4y2Ba/span><span class="go">…| 2 2開始視圖模型default.zzz_win_loss_records .................(運行)<gydF4y2Ba/span><span class="go">…| 2的2好創建視圖模型default.zzz_win_loss_records ............(好吧…)<gydF4y2Ba/span><span class="go">…|<gydF4y2Ba/span><span class="go">…|運行1表模型,完成1視圖模型…<gydF4y2Ba/span><span class="go">成功完成<gydF4y2Ba/span><span class="go">完成了。通過= 2警告= 0 = 0跳過錯誤= 0 = 2<gydF4y2Ba/span></pre> </div> </div></li> <li><p>運行以下SQL代碼信息新的視圖和列表選擇表和視圖的所有行。<gydF4y2Ba/p><p>如果你連接到一個集群,您可以運行這個SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/notebooks/notebooks-manage.html"><span class="std std-ref">筆記本<gydF4y2Ba/span></a>附加到集群中,指定SQL作為默認語言的筆記本。如果你連接到SQL的倉庫,你可以運行這個SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/sql/user/queries/queries.html"><span class="std std-ref">查詢<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">顯示<gydF4y2Ba/span><span class="w"></span><span class="n">的觀點<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="k">默認的<gydF4y2Ba/span><span class="w"></span><span class="k">就像<gydF4y2Ba/span><span class="w"></span><span class="s1">“zzz_win_loss_records”<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">| |名稱空間viewName | isTemporary |<gydF4y2Ba/span><span class="go">+ = = = = = = = = = = = + = = = = = = = = = = = = = = = = = = = = = = + = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="go">| |違約zzz_win_loss_records假| |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">| | game_id |回家訪客| home_score | visitor_score | | |贏家日期<gydF4y2Ba/span><span class="go">+ = = = = = = = = = + = = = = = = = = = = = = = = = + = = = = = = = = = = = = = = = + = = = = = = = = = = = = + = = = = = = = = = = = = = = = + = = = = = = = = = = = = = = = + = = = = = = = = = = = = +<gydF4y2Ba/span><span class="go">西雅圖舊金山| 1 | | | 4 | 2 |舊金山| 2020-12-12 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">阿姆斯特丹舊金山| 2 | | | 0 | 1 | 2021-01-09 | |阿姆斯特丹<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">舊金山西雅圖| 3 | | | 1 | 2 |舊金山| 2020-12-19 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">阿姆斯特丹西雅圖| 4 | | | 3 | 2 | 2021-01-16 | |西雅圖<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">舊金山阿姆斯特丹| 5 | | | 3 | 0 | 2021-01-23 | |阿姆斯特丹<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">西雅圖阿姆斯特丹| 6 | | | 3 | 1 | 2021-02-06 | |阿姆斯特丹<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_win_loss_records<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">| | |團隊贏得|損失<gydF4y2Ba/span><span class="go">+ = = = = = = = = = = = = = = = + = = = = = = + = = = = = = = = +<gydF4y2Ba/span><span class="go">阿姆斯特丹| | 3 | 1 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">舊金山| | 2 | 2 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">西雅圖| | 1 | 3 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span></pre> </div> </div></li> </ol> </div> <div class="section" id="step-3-create-and-run-tests"> <span id="tests"></span> <h3>步驟3:創建和運行測試<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#step-3-create-and-run-tests" title=""></a></h3> <p>在這個步驟中,您將創建<gydF4y2Baem>測試<gydF4y2Ba/em>你對模型做出的斷言。當您運行這些測試,印度生物技術部告訴你如果在您的項目中每個測試通過或失敗。<gydF4y2Ba/p> <p>有兩種類型的測試。<gydF4y2Baem>模式測試<gydF4y2Ba/em>寫在YAML,返回的記錄數不通過斷言。當這個數字是零,所有記錄,因此測試通過。<gydF4y2Baem>數據測試<gydF4y2Ba/em>特定的查詢必須返回零記錄。<gydF4y2Ba/p> <ol class="arabic"> <li><p>創建模式測試:在<gydF4y2Bastrong>項目<gydF4y2Ba/strong>窗格中,單擊<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夾,單擊省略號,然後單擊<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>輸入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ schema.yml<gydF4y2Ba/span></code>並點擊<gydF4y2Bastrong>創建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">schema.yml<gydF4y2Ba/span></code>文件,輸入以下內容,然後單擊<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。這個文件包括模式測試,確定指定的列有獨特的價值觀,不是零,隻有指定的值,或組合。<gydF4y2Ba/p> <div class="highlight-yaml notranslate"> <div class="highlight"> <pre><span></span><span class="nt">版本<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">2<gydF4y2Ba/span><span class="w"></span><span class="nt">模型<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">zzz_game_details<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">列<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">game_id<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">獨特的<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">accepted_values<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">值<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="p p-Indicator">(<gydF4y2Ba/span><span class="s">“阿姆斯特丹”<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“聖<gydF4y2Ba/span><span class="nv"></span><span class="s">舊金山的<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“西雅圖”<gydF4y2Ba/span><span class="p p-Indicator">]<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">遊客<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">accepted_values<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">值<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="p p-Indicator">(<gydF4y2Ba/span><span class="s">“阿姆斯特丹”<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“聖<gydF4y2Ba/span><span class="nv"></span><span class="s">舊金山的<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“西雅圖”<gydF4y2Ba/span><span class="p p-Indicator">]<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">home_score<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">贏家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">accepted_values<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">值<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="p p-Indicator">(<gydF4y2Ba/span><span class="s">“阿姆斯特丹”<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“聖<gydF4y2Ba/span><span class="nv"></span><span class="s">舊金山的<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“西雅圖”<gydF4y2Ba/span><span class="p p-Indicator">]<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">日期<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">zzz_win_loss_records<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">列<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">團隊<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">獨特的<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的關係<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">來<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">裁判(“zzz_game_details”)<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">場<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">贏了<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">損失<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">測試<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>創建第一個數據測試:在<gydF4y2Bastrong>項目<gydF4y2Ba/strong>窗格中,單擊<gydF4y2Bastrong>測試<gydF4y2Ba/strong>文件夾,單擊省略號,然後單擊<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>輸入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">測試/ zzz_game_details_check_dates.sql<gydF4y2Ba/span></code>並點擊<gydF4y2Bastrong>創建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details_check_dates.sql<gydF4y2Ba/span></code>文件,輸入下麵的SQL語句,然後單擊<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。這個文件包含一個數據測試來決定遊戲是否發生以外的常規賽。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——本賽季的比賽發生在2020-12-12和2020-12-12之間。<gydF4y2Ba/span><span class="c1">對於這個測試通過,這個查詢必須返回任何結果。<gydF4y2Ba/span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="w"></span><span class="k">在哪裏<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="s1">“2020-12-12”<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-02-06”<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>創建第二個數據測試:<gydF4y2Bastrong>項目<gydF4y2Ba/strong>窗格中,單擊<gydF4y2Bastrong>測試<gydF4y2Ba/strong>文件夾,單擊省略號,然後單擊<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>輸入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">測試/ zzz_game_details_check_scores.sql<gydF4y2Ba/span></code>並點擊<gydF4y2Bastrong>創建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details_check_scores.sql<gydF4y2Ba/span></code>文件,輸入下麵的SQL語句,然後單擊<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。這個文件包含一個數據測試,以確定是否有任何分數-或任何相關的遊戲。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——這項運動不允許負成績或領帶遊戲。<gydF4y2Ba/span><span class="c1">對於這個測試通過,這個查詢必須返回任何結果。<gydF4y2Ba/span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="w"></span><span class="k">在哪裏<gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>創建第三個數據測試:在<gydF4y2Bastrong>項目<gydF4y2Ba/strong>窗格中,單擊<gydF4y2Bastrong>測試<gydF4y2Ba/strong>文件夾,單擊省略號,然後單擊<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>輸入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">測試/ zzz_win_loss_records_check_records.sql<gydF4y2Ba/span></code>並點擊<gydF4y2Bastrong>創建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_win_loss_records_check_records.sql<gydF4y2Ba/span></code>文件,輸入下麵的SQL語句,然後單擊<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。這個文件包含一個數據測試來確定團隊是否成功或失敗有負麵記錄,有更多的成功或失敗比比賽記錄,或者比被允許玩更多的遊戲。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">本賽季,每個團隊參加了4場比賽。<gydF4y2Ba/span><span class="c1">對於這個測試通過,這個查詢必須返回任何結果。<gydF4y2Ba/span><span class="k">選擇<gydF4y2Ba/span><span class="w"></span><span class="n">贏了<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">損失<gydF4y2Ba/span><span class="w"></span><span class="k">從<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_win_loss_records<gydF4y2Ba/span><span class="w"></span><span class="k">在哪裏<gydF4y2Ba/span><span class="w"></span><span class="n">贏了<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">贏了<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="mi">4<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">損失<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">損失<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="mi">4<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="n">贏了<gydF4y2Ba/span><span class="w"></span><span class="o">+<gydF4y2Ba/span><span class="w"></span><span class="n">損失<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="mi">4<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>運行測試:在<gydF4y2Bastrong>運行<gydF4y2Ba/strong>盒子,運行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技術部<gydF4y2Ba/span><span class="pre">測試<gydF4y2Ba/span></code>命令。<gydF4y2Ba/p></li> </ol> </div> <div class="section" id="step-4-clean-up"> <span id="clean-up"></span> <h3>第四步:清理<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#step-4-clean-up" title=""></a></h3> <p>您可以刪除您對於這個例子創建的表和視圖通過運行以下SQL代碼。<gydF4y2Ba/p> <p>如果你連接到一個集群,您可以運行這個SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/notebooks/notebooks-manage.html"><span class="std std-ref">筆記本<gydF4y2Ba/span></a>附加到集群中,指定SQL作為默認語言的筆記本。如果你連接到SQL的倉庫,你可以運行這個SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs.gcp/sql/user/queries/queries.html"><span class="std std-ref">查詢<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">視圖<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_win_loss_records<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">鑽石<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_four_cs<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">視圖<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_list_colors<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">視圖<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_prices<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> </div> </div> <div class="section" id="next-steps"> <h2>下一個步驟<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#next-steps" title=""></a></h2> <ul class="simple"> <li><p>了解更多關於印度生物技術部<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/building-models">模型<gydF4y2Ba/a>。<gydF4y2Ba/p></li> <li><p>學習如何<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/tests">測試<gydF4y2Ba/a>你的印度生物技術部項目。<gydF4y2Ba/p></li> <li><p>學習如何使用<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/jinja-macros">金賈的<gydF4y2Ba/a>模板語言,編程SQL在印度生物技術部項目中。<gydF4y2Ba/p></li> <li><p>了解印度生物技術部<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/guides/best-practices">最佳實踐<gydF4y2Ba/a>。<gydF4y2Ba/p></li> </ul> </div> <div class="section" id="additional-resources"> <h2>額外的資源<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs.gcp/partners/prep/#additional-resources" title=""></a></h2> <ul class="simple"> <li><p><a class="reference external" href="https://blog.getdbt.com/what--exactly--is-dbt-/">究竟什麼是印度生物技術部嗎?<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/introduction">一般印度生物技術部文檔<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://github.com/dbt-labs/dbt">dbt-core GitHub庫<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/dbt-cli/cli-overview">印度生物技術部CLI<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://www.getdbt.com/pricing/">印度生物技術部的定價<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://blog.getdbt.com/analytics-engineering-for-everyone-databricks-in-dbt-cloud/">分析工程對所有人:磚在印度生物技術部的雲<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-overview">印度生物技術部的雲計算概述<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-configuring-dbt-cloud/connecting-your-database">連接到數據磚<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://discourse.getdbt.com/">印度生物技術部話語社區<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://blog.getdbt.com/">印度生物技術部的博客<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-dbt-cloud-support">支持<gydF4y2Ba/a></p></li> </ul> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> </div> </div> </div> </div> <div class="suapp-rating"> <div id="suPageRateApp"> <su-app></su-app> </div> </div> <hr> <footer> <div role="contentinfo"> <p class="copyright">©2023磚。保留所有權利。Apache, Apache火花,火花,火花標誌的商標<gydF4y2Baa href="http://www.apache.org/">Apache軟件基金會<gydF4y2Ba/a>。<gydF4y2Ba/p> <p><a id="feedbacklink" href="mailto:doc-feedback@www.eheci.com?subject=Documentation Feedback">給我們反饋<gydF4y2Ba/a>|<gydF4y2Baa href="//www.eheci.com/docs.gcp/privacy-policy">隱私政策<gydF4y2Ba/a>|<gydF4y2Baa href="//www.eheci.com/docs.gcp/terms-of-use">使用條款<gydF4y2Ba/a></p> </div> </footer> </div> </div> </section> </main> </page>  <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet">  <div style="text-align:center;margin-bottom:5px;"><form action="http://www.baidu.com/baidu" target="_blank"><div bgcolor="#FFFFFF" style="text-align:center;"><input name="tn" type="hidden" value="baidu"><a href="http://www.baidu.com/"><img src="http://img.baidu.com/img/logo-80px.gif" width="80px" height="29px" alt="Baidu" align="bottom" border="0"></a><input type="text" name="word" size="30" placeholder="" value=""><input type="submit" value="baidu"></div></form></div><div id="so360" style="text-align:center;margin-bottom:5px;"><form action="https://www.so.com/" target="_blank" id="so360form"><img src="http://p1.qhimg.com/d/_onebox/search.png" width="100px" height="25px"> <input type="text" autocomplete="off" name="q" id="so360_keyword" placeholder="" value=""> <input type="submit" id="so360_submit" value="360"> <input type="hidden" name="ie" value="gbk"><input type="hidden" name="src" value="zz"> <input type="hidden" name="site" value="so.com"> <input type="hidden" name="rg" value="1"></form></div><div id="sogou" style="text-align:center;margin-bottom:5px;"><form action="https://www.sogou.com/" target="_blank" id="so360form"><img src="https://www.sogou.com/web/index/images/logo_440x140.v.4.png" width="100px" height="25px"> <input type="text" autocomplete="off" name="q" id="sogou.com_keyword" placeholder="" value=""> <input type="submit" id="sogou_submit" value="sougou"> <input type="hidden" name="ie" value="gbk"><input type="hidden" name="src" value="zz"> <input type="hidden" name="site" value="so.com"> <input type="hidden" name="rg" value="1"></form></div><div align="center"><a target="_blank" href="/sitemap.xml">map</a></div></body> </html>