連接AWS上的dbt Cloud |數據庫<gydF4y2Ba/title> <link rel="stylesheet" href="//www.eheci.com/docs/_static/css/theme.css" type="text/css"> <link rel="stylesheet" href="//www.eheci.com/docs/_static/css/custom.css" type="text/css"> <link rel="stylesheet" href="//www.eheci.com/docs/_static/css/algolia.css" type="text/css"> <link rel="stylesheet" href="//www.eheci.com/docs/_static/css/cloud-provider-selector.css" type="text/css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/7dc8d13f-90bb-11e9-98a5-06d762ad9a62/searchbox.css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/7dc8d13f-90bb-11e9-98a5-06d762ad9a62/external_styles.css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/7dc8d13f-90bb-11e9-98a5-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/_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/_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/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/">文檔<gydF4y2Ba/a></li> <li><a href="//www.eheci.com/kb/">知識庫<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" selected>亞馬遜網絡服務<gydF4y2Ba/option><option value="azuregydF4y2Ba">微軟Azure<gydF4y2Ba/option><option value="gcpgydF4y2Ba">穀歌雲平台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/index.html" class="main-navigation-home">AWS上的數據<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/getting-started/index.html">開始<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/introduction/index.html">什麼是數據庫?<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/getting-started/tutorials/index.html">教程和最佳實踐<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/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/ingestion/index.html">加載數據<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/exploratory-data-analysis/index.html">探索數據<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/data-preparation/index.html">準備數據<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/data-sharing/index.html">數據共享(Delta共享)<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/workspace-index.html">工程數據<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/machine-learning/index.html">機器學習<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/sql/index.html">數據倉庫<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/delta/index.html">三角洲湖<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/dev-tools/index.html">開發人員工具<gydF4y2Ba/a></li> <li class="toctree-l1 current"><a class="reference internal" href="//www.eheci.com/docs/integrations/index.html">技術合作夥伴<gydF4y2Ba/a> <ul class="current"> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/partner-connect/index.html">合作夥伴聯係<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/integrations/jdbc-odbc-bi.html">配置ODBC和JDBC驅動程序<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/integrations/configure-oauth-powerbi.html">配置電源BI的OAuth<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/integrations/configure-oauth-tableau.html">為Tableau配置OAuth<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/integrations/manage-oauth.html">管理Power BI和Tableau的OAuth<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/partner-connect/ingestion.html">攝入<gydF4y2Ba/a></li> <li class="toctree-l2 current"><a class="reference internal" href="//www.eheci.com/docs/partner-connect/prep.html">數據準備與轉換<gydF4y2Ba/a> <ul class="current"> <li class="toctree-l3 current"><a class="current reference internal" href="//www.eheci.com/docs/partners/prep/#">印度生物技術部的雲<gydF4y2Ba/a></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs/partners/prep/dbt.html">印度生物技術部核心<gydF4y2Ba/a></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs/partners/prep/matillion.html">Matillion<gydF4y2Ba/a></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs/partners/prep/prophecy.html">預言<gydF4y2Ba/a></li> </ul></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/partner-connect/ml.html">機器學習<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/partner-connect/bi.html">BI和可視化<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/partner-connect/reverse-etl.html">反向ETL<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/partner-connect/data-quality.html">數據質量<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/partner-connect/semantic-layer.html">語義層<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/partners/data-governance/erwin.html">數據治理<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/partners/data-security/privacera.html">數據安全<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs/integrations/excel.html">從Microsoft Excel連接到Databricks<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/administration-guide/index.html">帳戶和工作空間管理<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/security/index.html">安全性和遵從性<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/data-governance/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/reference/api.html">參考<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/resources/index.html">資源<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/whats-coming.html">未來是什麼?<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs/archive/index.html">文檔歸檔<gydF4y2Ba/a></li> </ul> </div> <div role="contentinfo"> <p class="build_info" data-last-edit="March 21, 2023">2023年3月24日更新<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/index.html">文檔<gydF4y2Ba/a><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.eheci.com/docs/integrations/index.html">技術合作夥伴<gydF4y2Ba/a><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.eheci.com/docs/partner-connect/prep.html">使用夥伴連接連接到數據準備夥伴<gydF4y2Ba/a><span class="db-icon db-icon-chevron-right"></span></li> <li>連接dbt Cloud<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>連接dbt Cloud<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#connect-to-dbt-cloud" title=""></a></h1> <p>DBT(數據構建工具)是一種開發環境，允許數據分析師和數據工程師通過簡單地編寫選擇語句來轉換數據。DBT處理將這些選擇語句轉換為表和視圖。dbt將代碼編譯為原始SQL，然後在Databricks中的指定數據庫上運行該代碼。DBT支持協作編碼模式和最beplay娱乐ios佳實踐，如版本控製、文檔和模塊化。<gydF4y2Ba/p> <p>DBT不提取或加載數據。DBT隻關注轉換步驟，使用“加載後轉換”體係結構。DBT假設您的數據庫中已經有了數據的副本。<gydF4y2Ba/p> <p>本文主要介紹dbt Cloud。dbt Cloud配備了調度作業、CI/CD、服務文檔、監控和警報以及集成開發環境(IDE)的交鑰匙支持。<gydF4y2Ba/p> <p>還可以使用dbt的本地版本dbt Core。dbt Core使您能夠在本地開發機器上的文本編輯器或IDE中編寫dbt代碼，然後從命令行運行dbt。dbt Core包括dbt CLI (Command Line Interface)。dbt CLI是免費使用的開源工具。有關更多信息，請參見<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/partners/prep/dbt.html"><span class="doc">連接到dbt核心<gydF4y2Ba/span></a>．<gydF4y2Ba/p> <p>因為dbt Cloud和dbt Core可以使用托管的git存儲庫(例如，在GitHub, GitLab或BitBucket上)，你可以使用dbt Cloud創建一個dbt項目，然後讓它對你的dbt Cloud和dbt Core用戶可用。有關更多信息，請參見<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/projects">創建dbt項目<gydF4y2Ba/a>而且<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/projects">使用現有項目<gydF4y2Ba/a>在DBT網站上。<gydF4y2Ba/p> <p>要了解dbt的一般概況，請觀看以下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">,<gydF4y2Ba/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>使用Partner Connect連接到dbt Cloud<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#connect-to-dbt-cloud-using-partner-connect" title=""></a></h2> <p>本節描述如何使用Partner connect將Databricks工作區連接到dbt Cloud，然後賦予dbt Cloud對數據的讀訪問權。<gydF4y2Ba/p> <div class="admonition note"> <p class="admonition-title">請注意<gydF4y2Ba/p> <p>“夥伴連接”不連接數據庫<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/clusters/index.html"><span class="doc">集群<gydF4y2Ba/span></a>到dbt Cloud。當集群需要接入dbt Cloud時，需要手動接入dbt Cloud。<gydF4y2Ba/p> </div> <div class="section" id="differences-between-standard-connections-and-dbt-cloud"> <span id="differences"></span> <h3>標準連接與dbt Cloud的區別<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#differences-between-standard-connections-and-dbt-cloud" title=""></a></h3> <p>要使用Partner connect連接到dbt Cloud，請執行下麵的步驟<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/partner-connect/prep.html"><span class="doc">使用夥伴連接連接到數據準備夥伴<gydF4y2Ba/span></a>．dbt雲連接與標準數據準備和轉換連接的區別如下:<gydF4y2Ba/p> <ul class="simple"> <li><p>除了一個服務主體和一個個人訪問令牌之外，Partner Connect還創建一個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/partners/prep/#steps-to-connect" title=""></a></h3> <p>使用Partner connect連接dbt Cloud，請執行以下操作:<gydF4y2Ba/p> <ol class="arabic"> <li><p><a class="reference internal" href="//www.eheci.com/docs/partner-connect/prep.html"><span class="doc">使用夥伴連接連接到數據準備夥伴<gydF4y2Ba/span></a>．<gydF4y2Ba/p></li> <li><p>連接到dbt Cloud後，將出現dbt Cloud指示板。要查看dbt Cloud項目，請在菜單欄中dbt徽標旁邊，從第一個下拉菜單中選擇dbt帳戶名稱(如果沒有顯示)，然後選擇<gydF4y2Bastrong>Databricks合作夥伴連接試用<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>若要查看此項目的Databricks個人訪問令牌信息，請單擊菜單欄上的“人員”圖標，單擊<gydF4y2Bastrong>配置文件>憑證> Databricks合作夥伴連接試用<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>授予dbt Cloud對數據的讀訪問權限的步驟<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#steps-to-give-dbt-cloud-read-access-to-your-data" title=""></a></h3> <p>對象提供僅創建權限<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>服務主體僅在默認目錄上。在Databricks工作空間中按照以下步驟給出<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>服務主體對所選數據的讀訪問權。<gydF4y2Ba/p> <div class="admonition warning"> <p class="admonition-title">警告<gydF4y2Ba/p> <p>您可以調整這些步驟，使dbt Cloud能夠跨目錄、數據庫和工作空間中的表進行額外訪問。但是，作為一種安全性最佳實踐，Databricks強烈建議隻允許訪問所需的各個表<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>服務主體使用，並且隻讀取對這些表的訪問。<gydF4y2Ba/p> </div> <ol class="arabic"> <li><p>將您的工作空間切換到<gydF4y2Bastrong>SQL<gydF4y2Ba/strong>的角色。要做到這一點，在你的工作空間<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/workspace/index.html"><span class="std std-ref">側邊欄<gydF4y2Ba/span></a>，點擊Databricks logo下方的圖標<gydF4y2Baimg alt="磚的標誌gydF4y2Ba" src="//www.eheci.com/docs/_images/databricks-logo.png">，然後選擇<gydF4y2Bastrong>SQL<gydF4y2Ba/strong>．<gydF4y2Ba/p></li> <li><p>點擊<gydF4y2Baimg alt="數據圖標gydF4y2Ba" src="//www.eheci.com/docs/_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/_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/_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>．這是Partner Connect在前一節中為您創建的Databricks服務主體。<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>對於希望給予dbt Cloud讀訪問權的其他表，重複步驟4-9。<gydF4y2Ba/p> </div> <div class="section" id="troubleshoot-the-dbt-cloud-connection"> <span id="troubleshoot-partner-connect"></span> <h3>dbt Cloud連接故障排除<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#troubleshoot-the-dbt-cloud-connection" title=""></a></h3> <p>如果有人在dbt Cloud中刪除此帳戶的項目，您可以單擊<gydF4y2Bastrong>印度生物技術部<gydF4y2Ba/strong>Tile時，將出現一條錯誤消息，說明無法找到該項目。若要修複此問題，請單擊<gydF4y2Bastrong>刪除連接<gydF4y2Ba/strong>，然後從這個過程的開始重新創建連接。<gydF4y2Ba/p> </div> </div> <div class="section" id="connect-to-dbt-cloud-manually"> <span id="manual-connection"></span> <h2>手動連接dbt Cloud<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#connect-to-dbt-cloud-manually" title=""></a></h2> <p>介紹如何連接數據庫<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/clusters/configure.html"><span class="doc">集群<gydF4y2Ba/span></a>或者Databricks SQL<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/sql/admin/create-sql-warehouse.html"><span class="doc">倉庫<gydF4y2Ba/span></a>在你的Databricks工作空間<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-overview">印度生物技術部的雲<gydF4y2Ba/a>．<gydF4y2Ba/p> <div class="admonition note"> <p class="admonition-title">請注意<gydF4y2Ba/p> <p>要創建一個新的SQL倉庫，然後快速將其連接到dbt Cloud，請使用Partner connect。<gydF4y2Ba/p> </div> <div class="section" id="requirements"> <span id="manual-requirements"></span> <h3>需求<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#requirements" title=""></a></h3> <ul> <li><p>Databricks工作區中的集群或SQL倉庫。<gydF4y2Ba/p> <ul class="simple"> <li><p><a class="reference internal" href="//www.eheci.com/docs/clusters/configure.html"><span class="doc">創建集群<gydF4y2Ba/span></a>．<gydF4y2Ba/p></li> <li><p><a class="reference internal" href="//www.eheci.com/docs/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/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/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/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>作為安全最佳實踐，當使用自動化工具、係統、腳本和應用程序進行身份驗證時，Databricks建議您使用屬於的訪問令牌<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/administration-guide/users-groups/service-principals.html"><span class="doc">服務主體<gydF4y2Ba/span></a>而不是工作區用戶。要為服務主體創建訪問令牌，請參見<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/administration-guide/users-groups/service-principals.html"><span class="std std-ref">管理服務主體的訪問令牌<gydF4y2Ba/span></a>．<gydF4y2Ba/p> </div></li> </ul> <ul> <li><p>將dbt Cloud連接到由Unity Catalog (dbt 1.1或以上版本)管理的數據。<gydF4y2Ba/p><p>本文中的步驟創建了一個使用最新dbt版本的新環境。有關為現有環境升級dbt版本的信息，請參見<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-versions/upgrade-core-in-cloud">升級到最新版本的雲dbt<gydF4y2Ba/a>在DBT文檔中。<gydF4y2Ba/p></li> </ul> </div> <div class="section" id="step-1-sign-up-for-dbt-cloud"> <span id="sign-up"></span> <h3>步驟1:注冊dbt Cloud<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#step-1-sign-up-for-dbt-cloud" title=""></a></h3> <p>去<gydF4y2Baa class="reference external" href="https://www.getdbt.com/signup/">dbt雲-注冊<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:創建dbt項目<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#step-2-create-a-dbt-project" title=""></a></h3> <p>在這一步中，您將創建一個dbt<gydF4y2Baem>項目<gydF4y2Ba/em>，其中包含到Databricks的連接<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/clusters/configure.html"><span class="doc">集群<gydF4y2Ba/span></a>或者一個<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/sql/admin/create-sql-warehouse.html"><span class="doc">SQL倉庫<gydF4y2Ba/span></a>，一個包含源代碼的存儲庫，以及一個或多個環境(例如測試和生產環境)。<gydF4y2Ba/p> <ol class="arabic"> <li><p><a class="reference external" href="https://cloud.getdbt.com/login/">登錄dbt Cloud<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>默認情況下，新項目使用Databricks (dbt-databricks)適配器，它支持Unity Catalog。若要將現有項目遷移到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>在DBT文檔中。<gydF4y2Ba/p> </div></li> <li><p>為<gydF4y2Bastrong>服務器主機名<gydF4y2Ba/strong>，輸入要求中的服務器主機名值。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>HTTP路徑<gydF4y2Ba/strong>，從需求中輸入HTTP路徑值。<gydF4y2Ba/p></li> <li><p>如果你的工作空間是Unity catalog，在<gydF4y2Bastrong>可選設置<gydF4y2Ba/strong>，輸入dbt Cloud要使用的目錄名稱。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>令牌<gydF4y2Ba/strong>，從要求中輸入個人訪問令牌。<gydF4y2Ba/p></li> <li><p>為<gydF4y2Bastrong>模式<gydF4y2Ba/strong>，輸入希望dbt Cloud在其中創建表和視圖的模式的名稱(例如，<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></p> <p>有關更多信息，請參見<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-configuring-dbt-cloud/connecting-your-database">連接Databricks ODBC<gydF4y2Ba/a>在DBT網站上。<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>若要查看或更改此項目的Databricks個人訪問令牌值，請單擊“人員”圖標，單擊<gydF4y2Bastrong>配置文件>證書<gydF4y2Ba/strong>，單擊業務群組名稱。如需更改，請單擊<gydF4y2Bastrong>編輯<gydF4y2Ba/strong>．<gydF4y2Ba/p> </div> <p>連接到Databricks集群或Databricks 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-1"> <span id="tutorial"></span> <h2>教程<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#tutorial-1" title=""></a></h2> <p>在本節中，您將使用dbt Cloud項目處理一些示例數據。本節假設您已經創建了項目，並將dbt Cloud 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/partners/prep/#step-1-create-and-run-models" title=""></a></h3> <p>在這一步中，您將使用dbt Cloud 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/dbfs/databricks-datasets.html"><span class="doc">樣本數據集<gydF4y2Ba/span></a>，詳見<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/getting-started/quick-start.html"><span class="std std-ref">創建表<gydF4y2Ba/span></a>的部分<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/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>Block指示DBT根據這條語句在數據庫中創建一個表。<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/spark-configs/">Apache Spark配置<gydF4y2Ba/a>的“模型配置”和“增量模型”部分<gydF4y2Baa class="reference external" href="https://github.com/dbt-labs/dbt-spark/blob/master/README.md">使用筆記<gydF4y2Ba/a>在GitHub的dbt-labs/dbt-spark存儲庫中。<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>塊，此模型指示DBT根據此語句在數據庫中創建視圖。<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>．這個表按鑽石顏色平均鑽石價格，按平均價格從高到低排序。這個模型指示dbt根據這條語句在數據庫中創建一個視圖。<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>數據庫時，DBT創建一個名為<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>．DBT從相關的視圖和表名中獲取這些視圖和表名<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>DBT運行——model models/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 of 3 OK創建表模型default.diamonds_four_cs...............(好吧…)<gydF4y2Ba/span><span class="go">．.．| 2 of 3開始視圖模型default.diamonds_list_colors.................(運行)<gydF4y2Ba/span><span class="go">．.．| 2 of 3 OK創建視圖模型default.diamonds_list_colors............(好吧…)<gydF4y2Ba/span><span class="go">．.．| 3的3開始default.diamonds_prices視圖模型 ......................(運行)<gydF4y2Ba/span><span class="go">．.．| 3 of 3 OK創建視圖模型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">完成了。Pass =3 warn =0 error =0 skip =0 total =3<gydF4y2Ba/span></pre> </div> </div></li> <li><p>運行下麵的SQL代碼列出關於新視圖的信息，並從表和視圖中選擇所有行。<gydF4y2Ba/p><p>如果連接到集群，則可以從數據庫運行此SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/notebooks/notebooks-manage.html"><span class="std std-ref">筆記本<gydF4y2Ba/span></a>，並將SQL指定為筆記本的默認語言。如果連接到SQL倉庫，則可以從數據庫中運行此SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/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 | istem臨時| . view視圖<gydF4y2Ba/span><span class="go">+===========+======================+=============+<gydF4y2Ba/span><span class="go">| default | diamonds_list_colors | false |<gydF4y2Ba/span><span class="go">+-----------+----------------------+-------------+<gydF4y2Ba/span><span class="go">| default | diamonds_prices | false |<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 | Premium | 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/partners/prep/#step-2-create-and-run-more-complex-models" title=""></a></h3> <p>在此步驟中，您將為一組相關數據表創建更複雜的模型。這些數據表包含關於一個虛構的體育聯賽的信息，該聯賽由三支球隊組成，每個賽季打六場比賽。這個過程創建數據表，創建模型，並運行模型。<gydF4y2Ba/p> <ol class="arabic"> <li><p>運行以下SQL代碼創建必要的數據表。<gydF4y2Ba/p><p>如果連接到集群，則可以從數據庫運行此SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/notebooks/notebooks-manage.html"><span class="std std-ref">筆記本<gydF4y2Ba/span></a>，並將SQL指定為筆記本的默認語言。如果連接到SQL倉庫，則可以從數據庫中運行此SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/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>Block指示DBT根據這條語句在數據庫中創建一個表。<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">第四步:將訪客團隊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">第四步中的第三步:顯示每場比賽獲勝者的城市名稱。<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">第四步中的第二步:將主隊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">第四步中的第一步:結合來自不同表格的數據(例如，遊戲和球隊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">第二步:計算每支隊伍的勝利和失敗的次數。<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">——第二步中的第一步:確定每場比賽的贏家和輸家。<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>數據庫(在項目設置中指定)時，DBT創建一個名為<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>．DBT從相關的視圖和表名中獲取這些視圖和表名<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>DBT運行——model models/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 of 2 OK創建表模型default.zzz_game_details...............(好吧…)<gydF4y2Ba/span><span class="go">．.．| 2 2開始default.zzz_win_loss_records視圖模型 .................(運行)<gydF4y2Ba/span><span class="go">．.．| 2 of 2 OK創建視圖模型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">完成了。Pass =2 warn =0 error =0 skip =0 total =2<gydF4y2Ba/span></pre> </div> </div></li> <li><p>運行以下SQL代碼列出關於新視圖的信息，並從表和視圖中選擇所有行。<gydF4y2Ba/p><p>如果連接到集群，則可以從數據庫運行此SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/notebooks/notebooks-manage.html"><span class="std std-ref">筆記本<gydF4y2Ba/span></a>，並將SQL指定為筆記本的默認語言。如果連接到SQL倉庫，則可以從數據庫中運行此SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/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 | istem臨時| . view視圖<gydF4y2Ba/span><span class="go">+===========+======================+=============+<gydF4y2Ba/span><span class="go">| default | zzz_win_loss_records | false |<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 | visitor | home_score | visitor_score | winner | date |<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/partners/prep/#step-3-create-and-run-tests" title=""></a></h3> <p>在此步驟中，您將創建<gydF4y2Baem>測試<gydF4y2Ba/em>，這是你對你的模型做出的斷言。運行這些測試時，dbt會告訴您項目中的每個測試是通過還是失敗。<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和2021-02-06之間。<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>命令使用<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">——模式<gydF4y2Ba/span></code>屬性中的兩個模型的名稱<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ schema.yml<gydF4y2Ba/span></code>文件運行為這些模型指定的測試。<gydF4y2Ba/p> <div class="highlight-bash notranslate"> <div class="highlight"> <pre><span></span>印度生物技術部<gydF4y2Baspan class="nb">測驗<gydF4y2Ba/span>——schema——models zzz_game_details zzz_win_loss_records<gydF4y2Ba/pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">．.．<gydF4y2Ba/span><span class="go">．.．| 1 of 15 START測試accepted_values_zzz_game_details_home__阿姆斯特丹__san_francisco__seattle [RUN]<gydF4y2Ba/span><span class="go">．.．| 1 of 15 PASS accepted_values_zzz_game_details_home__Amsterdam__San_Francisco__Seattle [PASS…]<gydF4y2Ba/span><span class="go">．.．<gydF4y2Ba/span><span class="go">．.．|<gydF4y2Ba/span><span class="go">．.．|完成15個測試…<gydF4y2Ba/span><span class="go">成功完成<gydF4y2Ba/span><span class="go">完成了。Pass =15 warn =0 error =0 skip =0 total =15<gydF4y2Ba/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">測試<gydF4y2Ba/span></code>目錄中。<gydF4y2Ba/p> <div class="highlight-bash notranslate"> <div class="highlight"> <pre><span></span>印度生物技術部<gydF4y2Baspan class="nb">測驗<gydF4y2Ba/span>——數據<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 zzz_game_details_check_dates開始測試 .......................(運行)<gydF4y2Ba/span><span class="go">．.．1 | 3通過zzz_game_details_check_dates .............................(通過…)<gydF4y2Ba/span><span class="go">．.．<gydF4y2Ba/span><span class="go">．.．|<gydF4y2Ba/span><span class="go">．.．|完成3個測試…<gydF4y2Ba/span><span class="go">成功完成<gydF4y2Ba/span><span class="go">完成了。Pass =3 warn =0 error =0 skip =0 total =3<gydF4y2Ba/span></pre> </div> </div></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/partners/prep/#step-4-clean-up" title=""></a></h3> <p>可以通過運行以下SQL代碼刪除為本例創建的表和視圖。<gydF4y2Ba/p> <p>如果連接到集群，則可以從數據庫運行此SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/notebooks/notebooks-manage.html"><span class="std std-ref">筆記本<gydF4y2Ba/span></a>，並將SQL指定為筆記本的默認語言。如果連接到SQL倉庫，則可以從數據庫中運行此SQL代碼<gydF4y2Baa class="reference internal" href="//www.eheci.com/docs/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-1"> <span id="next-steps"></span> <h2>下一個步驟<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#next-steps-1" title=""></a></h2> <ul class="simple"> <li><p>了解更多關於dbt的知識<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>你的DBT項目。<gydF4y2Ba/p></li> <li><p>學習如何使用<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/jinja-macros">金賈的<gydF4y2Ba/a>，一種模板語言，用於在dbt項目中編程SQL。<gydF4y2Ba/p></li> <li><p>了解dbt<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-1"> <span id="additional-resources"></span> <h2>額外的資源<gydF4y2Baa class="headerlink" href="//www.eheci.com/docs/partners/prep/#additional-resources-1" title=""></a></h2> <ul class="simple"> <li><p><a class="reference external" href="https://blog.getdbt.com/what--exactly--is-dbt-/">dbt到底是什麼?<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/introduction">dbt通用文檔<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://github.com/dbt-labs/dbt">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/">麵向所有人的分析工程:dbt雲中的數據<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-overview">dbt雲概述<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> <footer> <hr> <div role="contentinfo"> <p class="copyright">©Databricks 2023。版權所有。Apache、Apache Spark、Spark和Spark標誌均為<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/privacy-policy">隱私政策<gydF4y2Ba/a>|<gydF4y2Baa href="//www.eheci.com/docs/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>