连接AWS上的dbt Cloud |数据库</tgydF4y2Baitle> <link rel="stylesheet" href="//www.neidfyre.com/docs/_static/css/theme.css" type="text/css"> <link rel="stylesheet" href="//www.neidfyre.com/docs/_static/css/custom.css" type="text/css"> <link rel="stylesheet" href="//www.neidfyre.com/docs/_static/css/algolia.css" type="text/css"> <link rel="stylesheet" href="//www.neidfyre.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.neidfyre.com/ns.html?id=GTM-T85FQ33" 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.neidfyre.com/" class="wy-nav-top-logo"><img src="//www.neidfyre.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.neidfyre.com/" class="wy-nav-top-logo"><img src="//www.neidfyre.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.neidfyre.com/help">支持</gydF4y2Baa></li> <li><a href="mailto:doc-feedback@www.neidfyre.com?subject=Documentation Feedback">反馈</gydF4y2Baa></li> <li class="try-databrick-item"><a href="//www.neidfyre.com/docs/try-databricks">试着砖</gydF4y2Baa></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.neidfyre.com/help/s/">帮助中心</gydF4y2Baa></li> <li class="active"><a href="//www.neidfyre.com/docs/">文档</gydF4y2Baa></li> <li><a href="//www.neidfyre.com/kb/">知识库</gydF4y2Baa></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>亚马逊网络服务</gydF4y2Baoption><option value="azuregydF4y2Ba">微软Azure</gydF4y2Baoption><option value="gcpgydF4y2Ba">谷歌云平台bob体育客户端下载</gydF4y2Baoption></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.neidfyre.com/docs/index.html" class="main-navigation-home">AWS上的数据</gydF4y2Baa> <p class="caption"><span class="caption-text">开始</gydF4y2Baspan></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/getting-started/index.html">开始</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/introduction/index.html">什么是数据库?</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/getting-started/tutorials/index.html">教程和最佳实践</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/release-notes/index.html">发布说明</gydF4y2Baa></li> </ul> <p class="caption"><span class="caption-text">加载和管理数据</gydF4y2Baspan></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/ingestion/index.html">加载数据</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/exploratory-data-analysis/index.html">探索数据</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/data-preparation/index.html">准备数据</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/data-sharing/index.html">数据共享(Delta共享)</gydF4y2Baa></li> </ul> <p class="caption"><span class="caption-text">处理数据</gydF4y2Baspan></p> <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/workspace-index.html">工程数据</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/machine-learning/index.html">机器学习</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/sql/index.html">数据仓库</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/delta/index.html">三角洲湖</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/dev-tools/index.html">开发人员工具</gydF4y2Baa></li> <li class="toctree-l1 current"><a class="reference internal" href="//www.neidfyre.com/docs/integrations/index.html">集成</gydF4y2Baa> <ul class="current"> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs/partner-connect/index.html">合作伙伴联系</gydF4y2Baa></li> <li class="toctree-l2 current"><a class="reference internal" href="//www.neidfyre.com/docs/docs/partners.html">砖的合作伙伴bob体育外网下载</gydF4y2Baa> <ul class="current"> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/data-quality/anomalo.html">Anomalo</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ingestion/arcion.html">Arcion</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/semantic-layer/atscale.html">AtScale</gydF4y2Baa></li> <li class="toctree-l3 current"><a class="current reference internal" href="//www.neidfyre.com/docs/dev-tools/#">印度生物技术部的云</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/dev-tools/dbt.html">印度生物技术部核心</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/data-governance/erwin.html">erwin数据建模器</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ingestion/fivetran.html">Fivetran</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ingestion/hevo.html">Hevo数据</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/hex.html">十六进制</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/reverse-etl/hightouch.html">Hightouch</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ingestion/infoworks.html">Infoworks</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ml/john-snow-labs.html">约翰·斯诺实验室</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ml/labelbox.html">Labelbox</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/data-quality/lightup.html">Lightup</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/looker.html">美人</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/dev-tools/matillion.html">Matillion</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/microstrategy.html">MicroStrategy</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/mode.html">模式</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/power-bi.html">权力BI</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/preset.html">预设</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/data-security/privacera.html">Privacera</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/dev-tools/prophecy.html">预言</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ingestion/qlik.html">Qlik复制</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/qlik-sense.html">Qlik感</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ingestion/rivery.html">多溪流的</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/sigma.html">σ</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/workbenchj.html">SQL工作台/ J</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/semantic-layer/stardog.html">Stardog</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ingestion/stitch.html">针</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ingestion/streamsets.html">StreamSets</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/ingestion/syncsort.html">Syncsort</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/tableau.html">表</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/thoughtspot.html">ThoughtSpot</gydF4y2Baa></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs/docs/bi/spotfire.html">TIBCO Spotfire分析师</gydF4y2Baa></li> </ul></li> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs/integrations/jdbc-odbc-bi.html">连接ODBC和JDBC驱动程序</gydF4y2Baa></li> </ul></li> </ul> <p class="caption"><span class="caption-text">政府</gydF4y2Baspan></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/administration-guide/index.html">帐户和工作空间管理</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/security/index.html">安全性和遵从性</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/data-governance/index.html">数据治理</gydF4y2Baa></li> </ul> <p class="caption"><span class="caption-text">参考和资源</gydF4y2Baspan></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/reference/api.html">参考</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/resources/index.html">资源</gydF4y2Baa></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs/archive/index.html">文档归档</gydF4y2Baa></li> </ul> </div> <div role="contentinfo"> <p class="build_info" data-last-edit="January 06, 2023">2023年1月13日更新</gydF4y2Bap> <p><a id="feedbacklink" href="mailto:doc-feedback@www.neidfyre.com?subject=Documentation Feedback">给我们反馈</gydF4y2Baa></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.neidfyre.com/docs/index.html">文档</gydF4y2Baa><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.neidfyre.com/docs/integrations/index.html">砖的集成</gydF4y2Baa><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.neidfyre.com/docs/docs/partners.html">砖的合作伙伴bob体育外网下载</gydF4y2Baa><span class="db-icon db-icon-chevron-right"></span></li> <li>连接dbt Cloud</gydF4y2Bali> <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.neidfyre.com/docs/dev-tools/#connect-to-dbt-cloud" title=""></a></h1> <p>DBT(数据构建工具)是一种开发环境，允许数据分析师和数据工程师通过简单地编写选择语句来转换数据。DBT处理将这些选择语句转换为表和视图。dbt将代码编译为原始SQL，然后在Databricks中的指定数据库上运行该代码。DBT支持协作编码模式和最佳实践，如版本控制、文档和模块化。</gydF4y2Bap> <p>DBT不提取或加载数据。DBT只关注转换步骤，使用“加载后转换”体系结构。DBT假设您的数据库中已经有了数据的副本。</gydF4y2Bap> <p>本文主要介绍dbt Cloud。dbt Cloud配备了调度作业、CI/CD、服务文档、监控和警报以及集成开发环境(IDE)的交钥匙支持。</gydF4y2Bap> <p>还可以使用dbt的本地版本dbt Core。dbt Core使您能够在本地开发机器上的文本编辑器或IDE中编写dbt代码，然后从命令行运行dbt。dbt Core包括dbt CLI (Command Line Interface)。dbt CLI是免费使用的开源工具。bob下载地址有关更多信息，请参见<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/docs/dev-tools/dbt.html"><span class="doc">连接到dbt核心</gydF4y2Baspan></a>．</gydF4y2Bap> <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项目</gydF4y2Baa>而且<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/projects">使用现有项目</gydF4y2Baa>在DBT网站上。</gydF4y2Bap> <p>要了解dbt的一般概况，请观看以下YouTube视频(26分钟)。</gydF4y2Bap> <p></p> <iframe width="640" height="360" style="margin-bottom: 25px" src="https://www.youtube.com/embed/zoHoIGE6tPc?rel=0" frameborder="0" allowfullscreen="1">,</gydF4y2Baiframe> <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.neidfyre.com/docs/dev-tools/#connect-to-dbt-cloud-using-partner-connect" title=""></a></h2> <p>本节描述如何使用Partner connect将Databricks工作区连接到dbt Cloud，然后赋予dbt Cloud对数据的读访问权。</gydF4y2Bap> <div class="admonition note"> <p class="admonition-title">请注意</gydF4y2Bap> <p>“伙伴连接”不连接数据库<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/clusters/index.html"><span class="doc">集群</gydF4y2Baspan></a>到dbt Cloud。当集群需要接入dbt Cloud时，需要手动接入dbt Cloud。</gydF4y2Bap> </div> <div class="section" id="differences-between-standard-connections-and-dbt-cloud"> <span id="differences"></span> <h3>标准连接与dbt Cloud的区别<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#differences-between-standard-connections-and-dbt-cloud" title=""></a></h3> <p>要使用Partner connect连接到dbt Cloud，请执行下面的步骤<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/partner-connect/prep.html"><span class="doc">使用伙伴连接连接到数据准备伙伴</gydF4y2Baspan></a>．dbt云连接与标准数据准备和转换连接的区别如下:</gydF4y2Bap> <ul class="simple"> <li><p>除了一个服务主体和一个个人访问令牌之外，Partner Connect还创建一个SQL仓库(以前称为SQL端点)<gydF4y2Bastrong>DBT_CLOUD_ENDPOINT</gydF4y2Bastrong>默认情况下。</gydF4y2Bap></li> </ul> </div> <div class="section" id="steps-to-connect"> <span id="partner-connect-steps"></span> <h3>连接的步骤<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#steps-to-connect" title=""></a></h3> <p>使用Partner connect连接dbt Cloud，请执行以下操作:</gydF4y2Bap> <ol class="arabic"> <li><p><a class="reference internal" href="//www.neidfyre.com/docs/partner-connect/prep.html"><span class="doc">使用伙伴连接连接到数据准备伙伴</gydF4y2Baspan></a>．</gydF4y2Bap></li> <li><p>连接到dbt Cloud后，将出现dbt Cloud指示板。要查看dbt Cloud项目，请在菜单栏中dbt徽标旁边，从第一个下拉菜单中选择dbt帐户名称(如果没有显示)，然后选择<gydF4y2Bastrong>Databricks合作伙伴连接试用</gydF4y2Bastrong>如果没有显示，则从第二个下拉菜单中选择项目。</gydF4y2Bap> <div class="admonition tip"> <p class="admonition-title">提示</gydF4y2Bap> <p>要查看项目的设置，请单击“三条条纹”或“汉堡包”菜单，单击<gydF4y2Bastrong>帐户设置>项目</gydF4y2Bastrong>，单击业务群组名称。若要查看连接设置，请单击右侧的链接<gydF4y2Bastrong>连接</gydF4y2Bastrong>．单击，可更改任何设置<gydF4y2Bastrong>编辑</gydF4y2Bastrong>．</gydF4y2Bap> <p>若要查看此项目的Databricks个人访问令牌信息，请单击菜单栏上的“人员”图标，单击<gydF4y2Bastrong>配置文件>凭证> Databricks合作伙伴连接试用</gydF4y2Bastrong>，单击业务群组名称。如需更改，请单击<gydF4y2Bastrong>编辑</gydF4y2Bastrong>．</gydF4y2Bap> </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.neidfyre.com/docs/dev-tools/#steps-to-give-dbt-cloud-read-access-to-your-data" title=""></a></h3> <p>对象提供仅创建权限<gydF4y2Bastrong>DBT_CLOUD_USER</gydF4y2Bastrong>服务主体仅在默认目录上。在Databricks工作空间中按照以下步骤给出<gydF4y2Bastrong>DBT_CLOUD_USER</gydF4y2Bastrong>服务主体对所选数据的读访问权。</gydF4y2Bap> <div class="admonition warning"> <p class="admonition-title">警告</gydF4y2Bap> <p>您可以调整这些步骤，使dbt Cloud能够跨目录、数据库和工作空间中的表进行额外访问。但是，作为一种安全性最佳实践，Databricks强烈建议只允许访问所需的各个表<gydF4y2Bastrong>DBT_CLOUD_USER</gydF4y2Bastrong>服务主体使用，并且只读取对这些表的访问。</gydF4y2Bap> </div> <ol class="arabic"> <li><p>将您的工作空间切换到<gydF4y2Bastrong>SQL</gydF4y2Bastrong>的角色。要做到这一点，在你的工作空间<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/workspace/index.html"><span class="std std-ref">侧边栏</gydF4y2Baspan></a>，点击Databricks logo下方的图标<gydF4y2Baimg alt="砖的标志gydF4y2Ba" src="//www.neidfyre.com/docs/_images/databricks-logo.png">，然后选择<gydF4y2Bastrong>SQL</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>点击<gydF4y2Baimg alt="数据图标gydF4y2Ba" src="//www.neidfyre.com/docs/_images/data-icon.png"><strong>数据</gydF4y2Bastrong>在侧栏中。</gydF4y2Bap></li> <li><p>选择SQL仓库(<gydF4y2Bastrong>DBT_CLOUD_ENDPOINT</gydF4y2Bastrong>)在右上方的下拉列表中。</gydF4y2Bap> <div class="figure align-default"> <img alt="选择仓库gydF4y2Ba" src="//www.neidfyre.com/docs/_images/select-endpoint.png"> </div> <ol class="loweralpha simple"> <li><p>下<gydF4y2Bastrong>数据浏览</gydF4y2Bastrong>，选择包含表的数据库的目录。</gydF4y2Bap></li> <li><p>选择包含表的数据库。</gydF4y2Bap></li> <li><p>选择您的表。</gydF4y2Bap></li> </ol> <div class="admonition tip"> <p class="admonition-title">提示</gydF4y2Bap> <p>列表中没有列出目录、数据库或表，请输入名称的任意部分<gydF4y2Bastrong>选择目录</gydF4y2Bastrong>，<gydF4y2Bastrong>选择数据库</gydF4y2Bastrong>,或<gydF4y2Bastrong>过滤表</gydF4y2Bastrong>框，以缩小列表范围。</gydF4y2Bap> <div class="figure align-default"> <img alt="过滤表gydF4y2Ba" src="//www.neidfyre.com/docs/_images/filter-tables.png"> </div> </div></li> <li><p>点击<gydF4y2Bastrong>权限</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>点击<gydF4y2Bastrong>格兰特</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>输入可添加多个用户或组</gydF4y2Bastrong>中,选择<gydF4y2Bastrong>DBT_CLOUD_USER</gydF4y2Bastrong>．这是Partner Connect在前一节中为您创建的Databricks服务主体。</gydF4y2Bap> <div class="admonition tip"> <p class="admonition-title">提示</gydF4y2Bap> <p>如果你看不见<gydF4y2Bastrong>DBT_CLOUD_USER</gydF4y2Bastrong>，开始打字<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">DBT_CLOUD_USER</gydF4y2Baspan></code>在<gydF4y2Bastrong>输入可添加多个用户或组</gydF4y2Bastrong>框，直到它出现在列表中，然后选择它。</gydF4y2Bap> </div></li> <li><p>仅通过选择授予读访问权限<gydF4y2Bastrong>选择</gydF4y2Bastrong>而且<gydF4y2Bastrong>READ_METADATA</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>点击<gydF4y2Bastrong>好吧</gydF4y2Bastrong>．</gydF4y2Bap></li> </ol> <p>对于希望给予dbt Cloud读访问权的其他表，重复步骤4-9。</gydF4y2Bap> </div> <div class="section" id="troubleshoot-the-dbt-cloud-connection"> <h3>dbt Cloud连接故障排除<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#troubleshoot-the-dbt-cloud-connection" title=""></a></h3> <p>如果有人在dbt Cloud中删除此帐户的项目，您可以单击<gydF4y2Bastrong>印度生物技术部</gydF4y2Bastrong>Tile时，将出现一条错误消息，说明无法找到该项目。若要修复此问题，请单击<gydF4y2Bastrong>删除连接</gydF4y2Bastrong>，然后从这个过程的开始重新创建连接。</gydF4y2Bap> </div> </div> <div class="section" id="connect-to-dbt-cloud-manually"> <span id="manual-connection"></span> <h2>手动连接dbt Cloud<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#connect-to-dbt-cloud-manually" title=""></a></h2> <p>介绍如何连接数据库<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/clusters/create-cluster.html"><span class="doc">集群</gydF4y2Baspan></a>或者Databricks SQL<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/sql/admin/sql-endpoints.html"><span class="doc">仓库</gydF4y2Baspan></a>在你的Databricks工作空间<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-overview">印度生物技术部的云</gydF4y2Baa>．</gydF4y2Bap> <div class="admonition note"> <p class="admonition-title">请注意</gydF4y2Bap> <p>要创建一个新的SQL仓库，然后快速将其连接到dbt Cloud，请使用Partner connect。</gydF4y2Bap> </div> <p></p> <div class="section" id="requirements"> <span id="manual-requirements"></span> <h3>需求<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#requirements" title=""></a></h3> <p>一个砖<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/dev-tools/auth.html"><span class="std std-ref">个人访问令牌</gydF4y2Baspan></a>．</gydF4y2Bap> <div class="admonition note"> <p class="admonition-title">请注意</gydF4y2Bap> <p>作为安全最佳实践，当使用自动化工具、系统、脚本和应用程序进行身份验证时，Databricks建议您使用属于的访问令牌<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/administration-guide/users-groups/service-principals.html"><span class="doc">服务主体</gydF4y2Baspan></a>而不是工作区用户。要为服务主体创建访问令牌，请参见<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/administration-guide/users-groups/service-principals.html"><span class="std std-ref">管理服务主体的访问令牌</gydF4y2Baspan></a>．</gydF4y2Bap> </div> </div> <div class="section" id="step-1-sign-up-for-dbt-cloud"> <h3>步骤1:注册dbt Cloud<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#step-1-sign-up-for-dbt-cloud" title=""></a></h3> <p>去<gydF4y2Baa class="reference external" href="https://www.getdbt.com/signup/">dbt云-注册</gydF4y2Baa>然后输入您的电子邮件、姓名和公司信息。创建密码，单击<gydF4y2Bastrong>创建我的帐户</gydF4y2Bastrong>．</gydF4y2Bap> </div> <div class="section" id="step-2-create-a-dbt-project"> <h3>步骤2:创建dbt项目<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#step-2-create-a-dbt-project" title=""></a></h3> <p>在这一步中，您将创建一个dbt<gydF4y2Baem>项目</gydF4y2Baem>，其中包含到Databricks的连接<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/clusters/create-cluster.html"><span class="doc">集群</gydF4y2Baspan></a>或者一个<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/sql/admin/sql-endpoints.html"><span class="std std-ref">SQL仓库</gydF4y2Baspan></a>，一个包含源代码的存储库，以及一个或多个环境(例如测试和生产环境)。</gydF4y2Bap> <ol class="arabic"> <li><p><a class="reference external" href="https://cloud.getdbt.com/login/">登录dbt Cloud</gydF4y2Baa>．</gydF4y2Bap></li> <li><p>点击“三道条纹”或“汉堡”菜单，然后点击<gydF4y2Bastrong>帐户设置</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>点击<gydF4y2Bastrong>新项目</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>点击<gydF4y2Bastrong>开始</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bastrong>项目设置</gydF4y2Bastrong>页面,<gydF4y2Bastrong>的名字</gydF4y2Bastrong>，输入项目的唯一名称，然后单击<gydF4y2Bastrong>继续</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bastrong>建立数据库连接</gydF4y2Bastrong>页面,点击<gydF4y2Bastrong>砖</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>的名字</gydF4y2Bastrong>，为此连接输入唯一的名称。</gydF4y2Bap></li> <li><p>根据要连接的对象，输入以下信息。</gydF4y2Bap> <div class="js-code-language-tabs compound"> <div class="compound-first compound" lang="Cluster"> <ol class="compound-first arabic simple"> <li><p>离开<gydF4y2Bastrong>方法</gydF4y2Bastrong>设置为<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">ODBC</gydF4y2Baspan></code>．</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>主机名</gydF4y2Bastrong>，进入<gydF4y2Bastrong>服务器主机名</gydF4y2Bastrong>的值。<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/integrations/jdbc-odbc-bi.html"><span class="std std-ref">高级选项，JDBC/ODBC</gydF4y2Baspan></a>选项卡为Databricks集群设置。</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>港口</gydF4y2Bastrong>，进入<gydF4y2Bastrong>港口</gydF4y2Bastrong>的值。<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/integrations/jdbc-odbc-bi.html"><span class="std std-ref">高级选项，JDBC/ODBC</gydF4y2Baspan></a>选项卡为Databricks集群设置。</gydF4y2Bap></li> <li><p>离开<gydF4y2Bastrong>组织</gydF4y2Bastrong>空白。</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>集群</gydF4y2Bastrong>，输入Databricks集群的ID。这应该是最后一个正斜杠字符(<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">/</gydF4y2Baspan></code>)在<gydF4y2Bastrong>HTTP路径</gydF4y2Bastrong>的值。<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/integrations/jdbc-odbc-bi.html"><span class="std std-ref">高级选项，JDBC/ODBC</gydF4y2Baspan></a>选项卡为Databricks集群设置。例如,<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">1234 - 567890 test123</gydF4y2Baspan></code>．</gydF4y2Bap></li> <li><p>离开<gydF4y2Bastrong>端点</gydF4y2Bastrong>空白。</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>用户</gydF4y2Bastrong>,输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">令牌</gydF4y2Baspan></code>．</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>令牌</gydF4y2Bastrong>，输入“数据库”的值<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/dev-tools/api/latest/authentication.html"><span class="doc">个人访问令牌</gydF4y2Baspan></a>．</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>模式</gydF4y2Bastrong>，输入希望dbt Cloud在其中创建表和视图的数据库的名称(例如，<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默认的</gydF4y2Baspan></code>）.</gydF4y2Bap></li> <li><p>点击<gydF4y2Bastrong>测试连接</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>如果测试成功，单击<gydF4y2Bastrong>继续</gydF4y2Bastrong>．</gydF4y2Bap></li> </ol> <p class="compound-last">有关更多信息，请参见<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-configuring-dbt-cloud/connecting-your-database">连接Databricks ODBC</gydF4y2Baa>在DBT网站上。</gydF4y2Bap> </div> <div class="compound-last compound" lang="SQL warehouse"> <ol class="compound-first arabic simple"> <li><p>离开<gydF4y2Bastrong>方法</gydF4y2Bastrong>设置为<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">ODBC</gydF4y2Baspan></code>．</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>主机名</gydF4y2Bastrong>，进入<gydF4y2Bastrong>服务器主机名</gydF4y2Bastrong>的值。<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/integrations/jdbc-odbc-bi.html"><span class="std std-ref">连接细节</gydF4y2Baspan></a>选项卡为您的SQL仓库。</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>港口</gydF4y2Bastrong>，进入<gydF4y2Bastrong>港口</gydF4y2Bastrong>的值。<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/integrations/jdbc-odbc-bi.html"><span class="std std-ref">连接细节</gydF4y2Baspan></a>选项卡为您的SQL仓库。</gydF4y2Bap></li> <li><p>离开<gydF4y2Bastrong>组织</gydF4y2Bastrong>空白。</gydF4y2Bap></li> <li><p>离开<gydF4y2Bastrong>集群</gydF4y2Bastrong>空白。</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>端点</gydF4y2Bastrong>，输入SQL仓库的ID。这是在最后一个正斜杠字符(<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">/</gydF4y2Baspan></code>)在<gydF4y2Bastrong>HTTP路径</gydF4y2Bastrong>的值。<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/integrations/jdbc-odbc-bi.html"><span class="std std-ref">连接细节</gydF4y2Baspan></a>选项卡为您的SQL仓库。例如,<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">a123456bcde7f890</gydF4y2Baspan></code>．</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>用户</gydF4y2Bastrong>,输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">令牌</gydF4y2Baspan></code>．</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>令牌</gydF4y2Bastrong>，输入“数据库”的值<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/dev-tools/auth.html"><span class="std std-ref">个人访问令牌</gydF4y2Baspan></a>．</gydF4y2Bap></li> <li><p>为<gydF4y2Bastrong>模式</gydF4y2Bastrong>，输入希望dbt Cloud在其中创建表和视图的数据库的名称(例如，<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默认的</gydF4y2Baspan></code>）.</gydF4y2Bap></li> <li><p>点击<gydF4y2Bastrong>测试连接</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>如果测试成功，单击<gydF4y2Bastrong>继续</gydF4y2Bastrong>．</gydF4y2Bap></li> </ol> <p class="compound-last">有关更多信息，请参见<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-configuring-dbt-cloud/connecting-your-database">连接Databricks ODBC</gydF4y2Baa>在DBT网站上。</gydF4y2Bap> </div> </div></li> </ol> <div class="admonition tip"> <p class="admonition-title">提示</gydF4y2Bap> <p>若要查看或更改此项目的设置，或完全删除该项目，请单击“三条条纹”或“汉堡包”菜单，单击<gydF4y2Bastrong>帐户设置>项目</gydF4y2Bastrong>，单击业务群组名称。如需修改，请单击<gydF4y2Bastrong>编辑</gydF4y2Bastrong>．单击，删除业务群组<gydF4y2Bastrong>编辑>删除项目</gydF4y2Bastrong>．</gydF4y2Bap> <p>若要查看或更改此项目的Databricks个人访问令牌值，请单击“人员”图标，单击<gydF4y2Bastrong>配置文件>证书</gydF4y2Bastrong>，单击业务群组名称。如需更改，请单击<gydF4y2Bastrong>编辑</gydF4y2Bastrong>．</gydF4y2Bap> </div> <p>连接到Databricks集群或Databricks SQL仓库后，按照屏幕上的说明进行<gydF4y2Bastrong>建立一个存储库</gydF4y2Bastrong>然后点击<gydF4y2Bastrong>继续</gydF4y2Bastrong>．</gydF4y2Bap> <p>设置存储库后，按照屏幕上的说明邀请用户，然后单击<gydF4y2Bastrong>完整的</gydF4y2Bastrong>．或者点击<gydF4y2Bastrong>跳过&完成</gydF4y2Bastrong>．</gydF4y2Bap> <p>继续阅读<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/dev-tools/#tutorial"><span class="std std-ref">教程</gydF4y2Baspan></a>或<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/dev-tools/#next-steps"><span class="std std-ref">下一个步骤</gydF4y2Baspan></a>．</gydF4y2Bap> </div> </div> <div class="section" id="tutorial"> <h2>教程<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#tutorial" title=""></a></h2> <p>在本节中，您将使用dbt Cloud项目处理一些示例数据。本节假设您已经创建了项目，并将dbt Cloud IDE打开到该项目。</gydF4y2Bap> <div class="section" id="step-1-create-and-run-models"> <h3>步骤1:创建并运行模型<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#step-1-create-and-run-models" title=""></a></h3> <p>在这一步中，您将使用dbt Cloud IDE来创建和运行<gydF4y2Baem>模型</gydF4y2Baem>，分别是<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">选择</gydF4y2Baspan></code>基于同一数据库中的现有数据在数据库中创建新视图(默认值)或新表的语句。这个过程基于样本创建一个模型<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">钻石</gydF4y2Baspan></code>表中的<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/dbfs/databricks-datasets.html"><span class="doc">样本数据集</gydF4y2Baspan></a>，详见<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/getting-started/quick-start.html"><span class="std std-ref">创建表</gydF4y2Baspan></a>的部分<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/getting-started/quick-start.html"><span class="doc">教程:使用笔记本查询数据</gydF4y2Baspan></a>．此过程假设已经在您的工作区中创建了此表<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默认的</gydF4y2Baspan></code>数据库。</gydF4y2Bap> <ol class="arabic"> <li><p>打开项目后，单击<gydF4y2Bastrong>开始开发</gydF4y2Bastrong>．</gydF4y2Bap> <div class="admonition tip"> <p class="admonition-title">提示</gydF4y2Bap> <p>如果<gydF4y2Bastrong>开始开发</gydF4y2Bastrong>按钮未显示，单击<gydF4y2Bastrong>开发</gydF4y2Bastrong>在“三道条纹”或“汉堡”菜单上。</gydF4y2Bap> </div></li> <li><p>在<gydF4y2Bastrong>项目</gydF4y2Bastrong>窗格中,单击<gydF4y2Bastrong>初始化项目</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>创建第一个模型:单击<gydF4y2Bastrong>模型</gydF4y2Bastrong>文件夹，单击省略号，然后单击<gydF4y2Bastrong>新文件</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ diamonds_four_cs.sql</gydF4y2Baspan></code>并点击<gydF4y2Bastrong>创建</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_four_cs.sql</gydF4y2Baspan></code>输入以下SQL语句，单击<gydF4y2Bastrong>保存</gydF4y2Bastrong>．此语句仅从列表中选择每颗钻石的克拉、切工、颜色和净度细节<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">钻石</gydF4y2Baspan></code>表格的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置</gydF4y2Baspan></code>Block指示DBT根据这条语句在数据库中创建一个表。</gydF4y2Bap> <div class="highlight-default notranslate"> <div class="highlight"> <pre><span></span><span class="p">{{</gydF4y2Baspan><span class="n">配置</gydF4y2Baspan><span class="p">（</gydF4y2Baspan><span class="n">物化</gydF4y2Baspan><span class="o">＝</gydF4y2Baspan><span class="s1">“表”</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="n">file_format</gydF4y2Baspan><span class="o">＝</gydF4y2Baspan><span class="s1">“δ”</gydF4y2Baspan><span class="p">）</gydF4y2Baspan><span class="p">}}</gydF4y2Baspan></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="n">克拉</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">减少</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">颜色</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">清晰</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">钻石</gydF4y2Baspan><span class="w"></span></pre> </div> </div> <div class="admonition tip"> <p class="admonition-title">提示</gydF4y2Bap> <p>额外的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置</gydF4y2Baspan></code>选项，例如<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">合并</gydF4y2Baspan></code>增量策略，请参见<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/reference/resource-configs/spark-configs/">Apache Spark配置</gydF4y2Baa>的“模型配置”和“增量模型”部分<gydF4y2Baa class="reference external" href="https://github.com/dbt-labs/dbt-spark/blob/master/README.md">使用笔记</gydF4y2Baa>在GitHub的dbt-labs/dbt-spark存储库中。</gydF4y2Bap> </div></li> <li><p>创建第二个模型:在<gydF4y2Bastrong>项目</gydF4y2Bastrong>窗格，单击<gydF4y2Bastrong>模型</gydF4y2Bastrong>文件夹，单击省略号，然后单击<gydF4y2Bastrong>新文件</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ diamonds_list_colors.sql</gydF4y2Baspan></code>并点击<gydF4y2Bastrong>创建</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_list_colors.sql</gydF4y2Baspan></code>输入以下SQL语句，单击<gydF4y2Bastrong>保存</gydF4y2Bastrong>．属性中的惟一值<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">颜色</gydF4y2Baspan></code>中的列。<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_four_cs</gydF4y2Baspan></code>表，排序结果在字母顺序从第一到最后。因为没有<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置</gydF4y2Baspan></code>块，此模型指示DBT根据此语句在数据库中创建视图。</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="k">截然不同的</gydF4y2Baspan><span class="w"></span><span class="n">颜色</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">diamonds_four_cs</gydF4y2Baspan><span class="w"></span><span class="n">排序</gydF4y2Baspan><span class="w"></span><span class="k">通过</gydF4y2Baspan><span class="w"></span><span class="n">颜色</gydF4y2Baspan><span class="w"></span><span class="k">asc</gydF4y2Baspan><span class="w"></span></pre> </div> </div></li> <li><p>创建第三个模型:在<gydF4y2Bastrong>项目</gydF4y2Bastrong>窗格，单击<gydF4y2Bastrong>模型</gydF4y2Bastrong>文件夹，单击省略号，然后单击<gydF4y2Bastrong>新文件</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ diamonds_prices.sql</gydF4y2Baspan></code>并点击<gydF4y2Bastrong>创建</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_prices.sql</gydF4y2Baspan></code>输入以下SQL语句，单击<gydF4y2Bastrong>保存</gydF4y2Bastrong>．这个表按钻石颜色平均钻石价格，按平均价格从高到低排序。这个模型指示dbt根据这条语句在数据库中创建一个视图。</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="n">颜色</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="k">avg</gydF4y2Baspan><span class="p">（</gydF4y2Baspan><span class="n">价格</gydF4y2Baspan><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">价格</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">钻石</gydF4y2Baspan><span class="w"></span><span class="k">集团</gydF4y2Baspan><span class="w"></span><span class="k">通过</gydF4y2Baspan><span class="w"></span><span class="n">颜色</gydF4y2Baspan><span class="w"></span><span class="k">订单</gydF4y2Baspan><span class="w"></span><span class="k">通过</gydF4y2Baspan><span class="w"></span><span class="n">价格</gydF4y2Baspan><span class="w"></span><span class="k">desc</gydF4y2Baspan><span class="w"></span></pre> </div> </div></li> <li><p>运行模型:在<gydF4y2Bastrong>运行</gydF4y2Bastrong>方框，运行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技术部</gydF4y2Baspan><span class="pre">运行</gydF4y2Baspan></code>命令，使用上述三个文件的路径。在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默认的</gydF4y2Baspan></code>数据库时，DBT创建一个名为<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_four_cs</gydF4y2Baspan></code>还有两个视图<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_list_colors</gydF4y2Baspan></code>而且<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_prices</gydF4y2Baspan></code>．DBT从相关的视图和表名中获取这些视图和表名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">. sql</gydF4y2Baspan></code>文件的名字。</gydF4y2Bap> <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</gydF4y2Bapre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">．.．</gydF4y2Baspan><span class="go">．.．1 | 3 default.diamonds_four_cs开始表模型 ....................(运行)</gydF4y2Baspan><span class="go">．.．| 1 of 3 OK创建表模型default.diamonds_four_cs...............(好吧…)</gydF4y2Baspan><span class="go">．.．| 2 of 3开始视图模型default.diamonds_list_colors.................(运行)</gydF4y2Baspan><span class="go">．.．| 2 of 3 OK创建视图模型default.diamonds_list_colors............(好吧…)</gydF4y2Baspan><span class="go">．.．| 3的3开始default.diamonds_prices视图模型 ......................(运行)</gydF4y2Baspan><span class="go">．.．| 3 of 3 OK创建视图模型default.diamonds_prices.................(好吧…)</gydF4y2Baspan><span class="go">．.．|</gydF4y2Baspan><span class="go">．.．完成运行1个表模型，2个视图模型…</gydF4y2Baspan><span class="go">成功完成</gydF4y2Baspan><span class="go">完成了。Pass =3 warn =0 error =0 skip =0 total =3</gydF4y2Baspan></pre> </div> </div></li> <li><p>运行下面的SQL代码列出关于新视图的信息，并从表和视图中选择所有行。</gydF4y2Bap><p>如果连接到集群，则可以从数据库运行此SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/notebooks/notebooks-manage.html"><span class="std std-ref">笔记本</gydF4y2Baspan></a>，并将SQL指定为笔记本的默认语言。如果连接到SQL仓库，则可以从数据库中运行此SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/sql/user/queries/queries.html"><span class="std std-ref">查询</gydF4y2Baspan></a>．</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">显示</gydF4y2Baspan><span class="w"></span><span class="n">的观点</gydF4y2Baspan><span class="w"></span><span class="k">在</gydF4y2Baspan><span class="w"></span><span class="k">默认的</gydF4y2Baspan><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+-----------+----------------------+-------------+</gydF4y2Baspan><span class="go">|命名空间| viewName | istem临时| . view视图</gydF4y2Baspan><span class="go">+===========+======================+=============+</gydF4y2Baspan><span class="go">| default | diamonds_list_colors | false |</gydF4y2Baspan><span class="go">+-----------+----------------------+-------------+</gydF4y2Baspan><span class="go">| default | diamonds_prices | false |</gydF4y2Baspan><span class="go">+-----------+----------------------+-------------+</gydF4y2Baspan></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="o">＊</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">diamonds_four_cs</gydF4y2Baspan><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+-------+---------+-------+---------+</gydF4y2Baspan><span class="go">|克拉|切|颜色|清晰度|</gydF4y2Baspan><span class="go">+=======+=========+=======+=========+</gydF4y2Baspan><span class="go">| 0.23 |理想| E | SI2 |</gydF4y2Baspan><span class="go">+-------+---------+-------+---------+</gydF4y2Baspan><span class="go">| 0.21 | Premium | E | SI1 |</gydF4y2Baspan><span class="go">+-------+---------+-------+---------+</gydF4y2Baspan><span class="go">．.．</gydF4y2Baspan></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="o">＊</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">diamonds_list_colors</gydF4y2Baspan><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+-------+</gydF4y2Baspan><span class="go">|颜色|</gydF4y2Baspan><span class="go">+ = = = = = = = +</gydF4y2Baspan><span class="go">| d |</gydF4y2Baspan><span class="go">+-------+</gydF4y2Baspan><span class="go">| e |</gydF4y2Baspan><span class="go">+-------+</gydF4y2Baspan><span class="go">．.．</gydF4y2Baspan></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="o">＊</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">diamonds_prices</gydF4y2Baspan><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+-------+---------+</gydF4y2Baspan><span class="go">|颜色|价格|</gydF4y2Baspan><span class="go">+=======+=========+</gydF4y2Baspan><span class="go">| j | 5323.82 |</gydF4y2Baspan><span class="go">+-------+---------+</gydF4y2Baspan><span class="go">|我| 5091.87 |</gydF4y2Baspan><span class="go">+-------+---------+</gydF4y2Baspan><span class="go">．.．</gydF4y2Baspan></pre> </div> </div></li> </ol> </div> <div class="section" id="step-2-create-and-run-more-complex-models"> <h3>步骤2:创建并运行更复杂的模型<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#step-2-create-and-run-more-complex-models" title=""></a></h3> <p>在此步骤中，您将为一组相关数据表创建更复杂的模型。这些数据表包含关于一个虚构的体育联赛的信息，该联赛由三支球队组成，每个赛季打六场比赛。这个过程创建数据表，创建模型，并运行模型。</gydF4y2Bap> <ol class="arabic"> <li><p>运行以下SQL代码创建必要的数据表。</gydF4y2Bap><p>如果连接到集群，则可以从数据库运行此SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/notebooks/notebooks-manage.html"><span class="std std-ref">笔记本</gydF4y2Baspan></a>，并将SQL指定为笔记本的默认语言。如果连接到SQL仓库，则可以从数据库中运行此SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/sql/user/queries/queries.html"><span class="std std-ref">查询</gydF4y2Baspan></a>．</gydF4y2Bap><p>此步骤中的表和视图从<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_</gydF4y2Baspan></code>在这个例子中帮助识别它们。对于您自己的表和视图，不需要遵循此模式。</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="k">如果</gydF4y2Baspan><span class="w"></span><span class="k">存在</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="k">如果</gydF4y2Baspan><span class="w"></span><span class="k">存在</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="k">如果</gydF4y2Baspan><span class="w"></span><span class="k">存在</gydF4y2Baspan><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="k">如果</gydF4y2Baspan><span class="w"></span><span class="k">存在</gydF4y2Baspan><span class="w"></span><span class="n">zzz_teams</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">创建</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="w"></span><span class="n">game_id</gydF4y2Baspan><span class="w"></span><span class="nb">INT</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">home_team_id</gydF4y2Baspan><span class="w"></span><span class="nb">INT</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">visitor_team_id</gydF4y2Baspan><span class="w"></span><span class="nb">INT</gydF4y2Baspan><span class="w"></span><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="k">使用</gydF4y2Baspan><span class="w"></span><span class="n">δ</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">1</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">1</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">2</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">2</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">1</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">3.</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">3.</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">2</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">1</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">4</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">2</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">3.</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">5</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">3.</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">1</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">6</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">3.</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">2</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="c1">——结果:</gydF4y2Baspan><span class="c1">-- +---------+--------------+-----------------+</gydF4y2Baspan><span class="c1">——| game_id | home_team_id | visitor_team_id |</gydF4y2Baspan><span class="c1">-- +=========+==============+=================+</gydF4y2Baspan><span class="c1">——| 1 | 1 | 2 |</gydF4y2Baspan><span class="c1">-- +---------+--------------+-----------------+</gydF4y2Baspan><span class="c1">——| 2 | 1 | 3 |</gydF4y2Baspan><span class="c1">-- +---------+--------------+-----------------+</gydF4y2Baspan><span class="c1">——| 3 | 2 | 1 |</gydF4y2Baspan><span class="c1">-- +---------+--------------+-----------------+</gydF4y2Baspan><span class="c1">——| 4 | 2 | 3 |</gydF4y2Baspan><span class="c1">-- +---------+--------------+-----------------+</gydF4y2Baspan><span class="c1">——| 5 | 3 | 1 |</gydF4y2Baspan><span class="c1">-- +---------+--------------+-----------------+</gydF4y2Baspan><span class="c1">——| 6 | 3 | 2 |</gydF4y2Baspan><span class="c1">-- +---------+--------------+-----------------+</gydF4y2Baspan><span class="k">创建</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="w"></span><span class="n">game_id</gydF4y2Baspan><span class="w"></span><span class="nb">INT</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">home_team_score</gydF4y2Baspan><span class="w"></span><span class="nb">INT</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">visitor_team_score</gydF4y2Baspan><span class="w"></span><span class="nb">INT</gydF4y2Baspan><span class="w"></span><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="k">使用</gydF4y2Baspan><span class="w"></span><span class="n">δ</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">1</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">4</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">2</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">2</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">0</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">1</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">3.</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">1</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">2</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">4</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">3.</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">2</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">5</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">3.</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">0</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">6</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">3.</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="mi">1</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="c1">——结果:</gydF4y2Baspan><span class="c1">-- +---------+-----------------+--------------------+</gydF4y2Baspan><span class="c1">——| game_id | home_team_score | visitor_team_score |</gydF4y2Baspan><span class="c1">-- +=========+=================+====================+</gydF4y2Baspan><span class="c1">——| 1 | 4 | 2 |</gydF4y2Baspan><span class="c1">-- +---------+-----------------+--------------------+</gydF4y2Baspan><span class="c1">——| 2 | 0 | 1 |</gydF4y2Baspan><span class="c1">-- +---------+-----------------+--------------------+</gydF4y2Baspan><span class="c1">——| 3 | 1 | 2 |</gydF4y2Baspan><span class="c1">-- +---------+-----------------+--------------------+</gydF4y2Baspan><span class="c1">——| 4 | 3 | 2 |</gydF4y2Baspan><span class="c1">-- +---------+-----------------+--------------------+</gydF4y2Baspan><span class="c1">——| 5 | 3 | 0 |</gydF4y2Baspan><span class="c1">-- +---------+-----------------+--------------------+</gydF4y2Baspan><span class="c1">——| 6 | 3 | 1 |</gydF4y2Baspan><span class="c1">-- +---------+-----------------+--------------------+</gydF4y2Baspan><span class="k">创建</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="w"></span><span class="n">game_id</gydF4y2Baspan><span class="w"></span><span class="nb">INT</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">game_date</gydF4y2Baspan><span class="w"></span><span class="nb">日期</gydF4y2Baspan><span class="w"></span><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="k">使用</gydF4y2Baspan><span class="w"></span><span class="n">δ</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">1</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="s1">“2020-12-12”</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">2</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="s1">“2021-01-09”</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">3.</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="s1">“2020-12-19”</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">4</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="s1">“2021-01-16”</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">5</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="s1">“2021-01-23”</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">6</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="s1">“2021-02-06”</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="c1">——结果:</gydF4y2Baspan><span class="c1">-- +---------+------------+</gydF4y2Baspan><span class="c1">——| game_id | game_date |</gydF4y2Baspan><span class="c1">-- +=========+============+</gydF4y2Baspan><span class="c1">——| 1 | 2020-12-12 |</gydF4y2Baspan><span class="c1">-- +---------+------------+</gydF4y2Baspan><span class="c1">——| 2 | 2021-01-09 |</gydF4y2Baspan><span class="c1">-- +---------+------------+</gydF4y2Baspan><span class="c1">——| 3 | 2020-12-19 |</gydF4y2Baspan><span class="c1">-- +---------+------------+</gydF4y2Baspan><span class="c1">——| 4 | 2021-01-16 |</gydF4y2Baspan><span class="c1">-- +---------+------------+</gydF4y2Baspan><span class="c1">——| 5 | 2021-01-23 |</gydF4y2Baspan><span class="c1">-- +---------+------------+</gydF4y2Baspan><span class="c1">——| 6 | 2021-02-06 |</gydF4y2Baspan><span class="c1">-- +---------+------------+</gydF4y2Baspan><span class="k">创建</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">zzz_teams</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="w"></span><span class="n">team_id</gydF4y2Baspan><span class="w"></span><span class="nb">INT</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">team_city</gydF4y2Baspan><span class="w"></span><span class="nb">VARCHAR</gydF4y2Baspan><span class="p">（</gydF4y2Baspan><span class="mi">15</gydF4y2Baspan><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="k">使用</gydF4y2Baspan><span class="w"></span><span class="n">δ</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_teams</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">1</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="ss">“旧金山”</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_teams</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">2</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="ss">“西雅图”</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="k">插入</gydF4y2Baspan><span class="w"></span><span class="k">成</gydF4y2Baspan><span class="w"></span><span class="n">zzz_teams</gydF4y2Baspan><span class="w"></span><span class="k">值</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">3.</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="ss">“阿姆斯特丹”</gydF4y2Baspan><span class="p">）;</gydF4y2Baspan><span class="w"></span><span class="c1">——结果:</gydF4y2Baspan><span class="c1">-- +---------+---------------+</gydF4y2Baspan><span class="c1">——| team_id | team_city |</gydF4y2Baspan><span class="c1">-- +=========+===============+</gydF4y2Baspan><span class="c1">——| 1 |旧金山|</gydF4y2Baspan><span class="c1">-- +---------+---------------+</gydF4y2Baspan><span class="c1">——西雅图| 2 |</gydF4y2Baspan><span class="c1">-- +---------+---------------+</gydF4y2Baspan><span class="c1">——阿姆斯特丹| 3 |</gydF4y2Baspan><span class="c1">-- +---------+---------------+</gydF4y2Baspan></pre> </div> </div></li> <li><p>创建第一个模型:在<gydF4y2Bastrong>项目</gydF4y2Bastrong>窗格，单击<gydF4y2Bastrong>模型</gydF4y2Bastrong>文件夹，单击省略号，然后单击<gydF4y2Bastrong>新文件</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ zzz_game_details.sql</gydF4y2Baspan></code>并点击<gydF4y2Bastrong>创建</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details.sql</gydF4y2Baspan></code>输入以下SQL语句，单击<gydF4y2Bastrong>保存</gydF4y2Bastrong>．这条语句创建了一个表，其中提供了每场比赛的详细信息，比如球队名称和分数。的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置</gydF4y2Baspan></code>Block指示DBT根据这条语句在数据库中创建一个表。</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">—创建一个表格，提供每款游戏的全部细节，包括</gydF4y2Baspan><span class="c1">-比赛ID，主队和客队的城市名称和比分，</gydF4y2Baspan><span class="c1">——比赛获胜者的城市名称和比赛日期。</gydF4y2Baspan></pre> </div> </div> <div class="highlight-default notranslate"> <div class="highlight"> <pre><span></span><span class="p">{{</gydF4y2Baspan><span class="n">配置</gydF4y2Baspan><span class="p">（</gydF4y2Baspan><span class="n">物化</gydF4y2Baspan><span class="o">＝</gydF4y2Baspan><span class="s1">“表”</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="n">file_format</gydF4y2Baspan><span class="o">＝</gydF4y2Baspan><span class="s1">“δ”</gydF4y2Baspan><span class="p">）</gydF4y2Baspan><span class="p">}}</gydF4y2Baspan></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">第四步:将访客团队id替换为他们所在城市的名称。</gydF4y2Baspan><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">game_id</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">首页</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">t</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">team_city</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">游客</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">home_score</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">visitor_score</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="c1">第四步中的第三步:显示每场比赛获胜者的城市名称。</gydF4y2Baspan><span class="w"></span><span class="k">情况下</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">当</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">home_score</gydF4y2Baspan><span class="w"></span><span class="o">></gydF4y2Baspan><span class="w"></span><span class="n">visitor_score</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">然后</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">首页</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">当</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">visitor_score</gydF4y2Baspan><span class="w"></span><span class="o">></gydF4y2Baspan><span class="w"></span><span class="n">home_score</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">然后</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">t</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">team_city</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">结束</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">赢家</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">game_date</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="nb">日期</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="c1">第四步中的第二步:将主队id替换为他们实际的城市名称。</gydF4y2Baspan><span class="w"></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">game_id</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">t</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">team_city</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">首页</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">home_score</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">visitor_team_id</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">visitor_score</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">game_date</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="c1">第四步中的第一步:结合来自不同表格的数据(例如，游戏和球队id，分数，日期)。</gydF4y2Baspan><span class="w"></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">g</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">game_id</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">去</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">home_team_id</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">gs</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">home_team_score</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">home_score</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">去</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">visitor_team_id</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">gs</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">visitor_team_score</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">visitor_score</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">g</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">game_date</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="k">g</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="k">去</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">gs</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">在哪里</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">g</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">game_id</gydF4y2Baspan><span class="w"></span><span class="o">＝</gydF4y2Baspan><span class="w"></span><span class="k">去</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">game_id</gydF4y2Baspan><span class="w"></span><span class="k">而且</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">g</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">game_id</gydF4y2Baspan><span class="w"></span><span class="o">＝</gydF4y2Baspan><span class="w"></span><span class="n">gs</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">game_id</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">all_ids</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">zzz_teams</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">t</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">在哪里</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">all_ids</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">home_team_id</gydF4y2Baspan><span class="w"></span><span class="o">＝</gydF4y2Baspan><span class="w"></span><span class="n">t</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">team_id</gydF4y2Baspan><span class="w"></span><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">visitor_ids</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">zzz_teams</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">t</gydF4y2Baspan><span class="w"></span><span class="k">在哪里</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">visitor_ids</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">visitor_team_id</gydF4y2Baspan><span class="w"></span><span class="o">＝</gydF4y2Baspan><span class="w"></span><span class="n">t</gydF4y2Baspan><span class="p">．</gydF4y2Baspan><span class="n">team_id</gydF4y2Baspan><span class="w"></span><span class="k">订单</gydF4y2Baspan><span class="w"></span><span class="k">通过</gydF4y2Baspan><span class="w"></span><span class="n">game_date</gydF4y2Baspan><span class="w"></span><span class="k">desc</gydF4y2Baspan><span class="w"></span></pre> </div> </div></li> <li><p>创建第二个模型:在<gydF4y2Bastrong>项目</gydF4y2Bastrong>窗格，单击<gydF4y2Bastrong>模型</gydF4y2Bastrong>文件夹，单击省略号，然后单击<gydF4y2Bastrong>新文件</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ zzz_win_loss_records.sql</gydF4y2Baspan></code>并点击<gydF4y2Bastrong>创建</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_win_loss_records.sql</gydF4y2Baspan></code>输入以下SQL语句，单击<gydF4y2Bastrong>保存</gydF4y2Bastrong>．该语句创建了一个视图，其中列出了本赛季球队的输赢记录。</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">—创建一个视图，根据球队总结本赛季的胜利和失败记录。</gydF4y2Baspan><span class="c1">第二步:计算每支队伍的胜利和失败的次数。</gydF4y2Baspan><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">赢家</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">团队</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">数</gydF4y2Baspan><span class="p">（</gydF4y2Baspan><span class="n">赢家</gydF4y2Baspan><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">赢了</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="c1">——每队打4场比赛。</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="mi">4</gydF4y2Baspan><span class="w"></span><span class="o">-</gydF4y2Baspan><span class="w"></span><span class="k">数</gydF4y2Baspan><span class="p">（</gydF4y2Baspan><span class="n">赢家</gydF4y2Baspan><span class="p">）)</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">损失</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="c1">——第二步中的第一步:确定每场比赛的赢家和输家。</gydF4y2Baspan><span class="w"></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">game_id</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">赢家</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">情况下</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">当</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">首页</gydF4y2Baspan><span class="w"></span><span class="o">＝</gydF4y2Baspan><span class="w"></span><span class="n">赢家</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">然后</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">游客</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">其他的</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="n">首页</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">结束</gydF4y2Baspan><span class="w"></span><span class="k">作为</gydF4y2Baspan><span class="w"></span><span class="n">失败者</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_details</gydF4y2Baspan><span class="w"></span><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="k">集团</gydF4y2Baspan><span class="w"></span><span class="k">通过</gydF4y2Baspan><span class="w"></span><span class="n">赢家</gydF4y2Baspan><span class="w"></span><span class="k">订单</gydF4y2Baspan><span class="w"></span><span class="k">通过</gydF4y2Baspan><span class="w"></span><span class="n">赢了</gydF4y2Baspan><span class="w"></span><span class="k">desc</gydF4y2Baspan><span class="w"></span></pre> </div> </div></li> <li><p>运行模型:在<gydF4y2Bastrong>运行</gydF4y2Bastrong>方框，运行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技术部</gydF4y2Baspan><span class="pre">运行</gydF4y2Baspan></code>命令，使用前面两个文件的路径。在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默认的</gydF4y2Baspan></code>数据库(在项目设置中指定)时，DBT创建一个名为<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details</gydF4y2Baspan></code>一个视图名为<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_win_loss_records</gydF4y2Baspan></code>．DBT从相关的视图和表名中获取这些视图和表名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">. sql</gydF4y2Baspan></code>文件的名字。</gydF4y2Bap> <div class="highlight-bash notranslate"> <div class="highlight"> <pre><span></span>DBT运行——model models/zzz_game_details。sql模型/ zzz_win_loss_records.sql</gydF4y2Bapre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">．.．</gydF4y2Baspan><span class="go">．.．| 1 2 default.zzz_game_details开始表模型 ....................(运行)</gydF4y2Baspan><span class="go">．.．| 1 of 2 OK创建表模型default.zzz_game_details...............(好吧…)</gydF4y2Baspan><span class="go">．.．| 2 2开始default.zzz_win_loss_records视图模型 .................(运行)</gydF4y2Baspan><span class="go">．.．| 2 of 2 OK创建视图模型default.zzz_win_loss_records............(好吧…)</gydF4y2Baspan><span class="go">．.．|</gydF4y2Baspan><span class="go">．.．完成运行1个表模型，1个视图模型…</gydF4y2Baspan><span class="go">成功完成</gydF4y2Baspan><span class="go">完成了。Pass =2 warn =0 error =0 skip =0 total =2</gydF4y2Baspan></pre> </div> </div></li> <li><p>运行以下SQL代码列出关于新视图的信息，并从表和视图中选择所有行。</gydF4y2Bap><p>如果连接到集群，则可以从数据库运行此SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/notebooks/notebooks-manage.html"><span class="std std-ref">笔记本</gydF4y2Baspan></a>，并将SQL指定为笔记本的默认语言。如果连接到SQL仓库，则可以从数据库中运行此SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/sql/user/queries/queries.html"><span class="std std-ref">查询</gydF4y2Baspan></a>．</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">显示</gydF4y2Baspan><span class="w"></span><span class="n">的观点</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="k">默认的</gydF4y2Baspan><span class="w"></span><span class="k">就像</gydF4y2Baspan><span class="w"></span><span class="s1">“zzz_win_loss_records”</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+-----------+----------------------+-------------+</gydF4y2Baspan><span class="go">|命名空间| viewName | istem临时| . view视图</gydF4y2Baspan><span class="go">+===========+======================+=============+</gydF4y2Baspan><span class="go">| default | zzz_win_loss_records | false |</gydF4y2Baspan><span class="go">+-----------+----------------------+-------------+</gydF4y2Baspan></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="o">＊</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_details</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+---------+---------------+---------------+------------+---------------+---------------+------------+</gydF4y2Baspan><span class="go">| game_id | home | visitor | home_score | visitor_score | winner | date |</gydF4y2Baspan><span class="go">+=========+===============+===============+============+===============+===============+============+</gydF4y2Baspan><span class="go">| 1 |旧金山|西雅图| 4 | 2 |旧金山| 2020-12-12 |</gydF4y2Baspan><span class="go">+---------+---------------+---------------+------------+---------------+---------------+------------+</gydF4y2Baspan><span class="go">| 2 |旧金山|阿姆斯特丹| 0 | 1 |阿姆斯特丹| 2021-01-09 |</gydF4y2Baspan><span class="go">+---------+---------------+---------------+------------+---------------+---------------+------------+</gydF4y2Baspan><span class="go">| 3 |西雅图|旧金山| 1 | 2 |旧金山| 2020-12-19 |</gydF4y2Baspan><span class="go">+---------+---------------+---------------+------------+---------------+---------------+------------+</gydF4y2Baspan><span class="go">| 4 |西雅图|阿姆斯特丹| 3 | 2 |西雅图| 2021-01-16 |</gydF4y2Baspan><span class="go">+---------+---------------+---------------+------------+---------------+---------------+------------+</gydF4y2Baspan><span class="go">| 5 |阿姆斯特丹|旧金山| 3 | 0 |阿姆斯特丹| 2021-01-23 |</gydF4y2Baspan><span class="go">+---------+---------------+---------------+------------+---------------+---------------+------------+</gydF4y2Baspan><span class="go">| 6 |阿姆斯特丹|西雅图| 3 | 1 |阿姆斯特丹| 2021-02-06 |</gydF4y2Baspan><span class="go">+---------+---------------+---------------+------------+---------------+---------------+------------+</gydF4y2Baspan></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="o">＊</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">zzz_win_loss_records</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+---------------+------+--------+</gydF4y2Baspan><span class="go">|队|赢|输|</gydF4y2Baspan><span class="go">+===============+======+========+</gydF4y2Baspan><span class="go">|阿姆斯特丹| 3 | 1 |</gydF4y2Baspan><span class="go">+---------------+------+--------+</gydF4y2Baspan><span class="go">|旧金山| 2 | 2 |</gydF4y2Baspan><span class="go">+---------------+------+--------+</gydF4y2Baspan><span class="go">|西雅图| 1 | 3 |</gydF4y2Baspan><span class="go">+---------------+------+--------+</gydF4y2Baspan></pre> </div> </div></li> </ol> </div> <div class="section" id="step-3-create-and-run-tests"> <h3>步骤3:创建并运行测试<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#step-3-create-and-run-tests" title=""></a></h3> <p>在此步骤中，您将创建<gydF4y2Baem>测试</gydF4y2Baem>，这是你对你的模型做出的断言。运行这些测试时，dbt会告诉您项目中的每个测试是通过还是失败。</gydF4y2Bap> <p>有两种类型的测试。<gydF4y2Baem>模式测试</gydF4y2Baem>，用YAML编写，返回未通过断言的记录数。当这个数字为零时，所有记录通过，因此测试通过。<gydF4y2Baem>数据测试</gydF4y2Baem>是必须返回零记录才能通过的特定查询。</gydF4y2Bap> <ol class="arabic"> <li><p>创建模式测试:在<gydF4y2Bastrong>项目</gydF4y2Bastrong>窗格，单击<gydF4y2Bastrong>模型</gydF4y2Bastrong>文件夹，单击省略号，然后单击<gydF4y2Bastrong>新文件</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ schema.yml</gydF4y2Baspan></code>并点击<gydF4y2Bastrong>创建</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">schema.yml</gydF4y2Baspan></code>文件，输入以下内容，单击<gydF4y2Bastrong>保存</gydF4y2Bastrong>．此文件包括模式测试，用于确定指定列是否具有惟一值、是否为空、是否仅具有指定值或组合。</gydF4y2Bap> <div class="highlight-yaml notranslate"> <div class="highlight"> <pre><span></span><span class="nt">版本</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">2</gydF4y2Baspan><span class="w"></span><span class="nt">模型</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">zzz_game_details</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">列</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">game_id</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">独特的</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">首页</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">accepted_values</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">值</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="p p-Indicator">［</gydF4y2Baspan><span class="s">“阿姆斯特丹”</gydF4y2Baspan><span class="p p-Indicator">，</gydF4y2Baspan><span class="w"></span><span class="s">“圣</gydF4y2Baspan><span class="nv"></span><span class="s">旧金山的</gydF4y2Baspan><span class="p p-Indicator">，</gydF4y2Baspan><span class="w"></span><span class="s">“西雅图”</gydF4y2Baspan><span class="p p-Indicator">］</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">游客</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">accepted_values</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">值</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="p p-Indicator">［</gydF4y2Baspan><span class="s">“阿姆斯特丹”</gydF4y2Baspan><span class="p p-Indicator">，</gydF4y2Baspan><span class="w"></span><span class="s">“圣</gydF4y2Baspan><span class="nv"></span><span class="s">旧金山的</gydF4y2Baspan><span class="p p-Indicator">，</gydF4y2Baspan><span class="w"></span><span class="s">“西雅图”</gydF4y2Baspan><span class="p p-Indicator">］</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">home_score</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">visitor_score</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">赢家</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">accepted_values</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">值</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="p p-Indicator">［</gydF4y2Baspan><span class="s">“阿姆斯特丹”</gydF4y2Baspan><span class="p p-Indicator">，</gydF4y2Baspan><span class="w"></span><span class="s">“圣</gydF4y2Baspan><span class="nv"></span><span class="s">旧金山的</gydF4y2Baspan><span class="p p-Indicator">，</gydF4y2Baspan><span class="w"></span><span class="s">“西雅图”</gydF4y2Baspan><span class="p p-Indicator">］</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">日期</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">zzz_win_loss_records</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">列</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">团队</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">独特的</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的关系</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">来</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">裁判(“zzz_game_details”)</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">场</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">首页</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">赢了</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="nt">的名字</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">损失</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="nt">测试</gydF4y2Baspan><span class="p">：</gydF4y2Baspan><span class="w"></span><span class="w"></span><span class="p p-Indicator">-</gydF4y2Baspan><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null</gydF4y2Baspan><span class="w"></span></pre> </div> </div></li> <li><p>中创建第一个数据测试<gydF4y2Bastrong>项目</gydF4y2Bastrong>窗格，单击<gydF4y2Bastrong>测试</gydF4y2Bastrong>文件夹，单击省略号，然后单击<gydF4y2Bastrong>新文件</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">测试/ zzz_game_details_check_dates.sql</gydF4y2Baspan></code>并点击<gydF4y2Bastrong>创建</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details_check_dates.sql</gydF4y2Baspan></code>输入以下SQL语句，单击<gydF4y2Bastrong>保存</gydF4y2Bastrong>．该文件包括一个数据测试，以确定是否有任何比赛发生在常规赛之外。</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——本赛季的比赛发生在2020-12-12和2021-02-06之间。</gydF4y2Baspan><span class="c1">—要通过此测试，此查询必须不返回任何结果。</gydF4y2Baspan><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="nb">日期</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_details</gydF4y2Baspan><span class="w"></span><span class="k">在哪里</gydF4y2Baspan><span class="w"></span><span class="nb">日期</gydF4y2Baspan><span class="w"></span><span class="o"><</gydF4y2Baspan><span class="w"></span><span class="s1">“2020-12-12”</gydF4y2Baspan><span class="w"></span><span class="k">或</gydF4y2Baspan><span class="w"></span><span class="nb">日期</gydF4y2Baspan><span class="w"></span><span class="o">></gydF4y2Baspan><span class="w"></span><span class="s1">“2021-02-06”</gydF4y2Baspan><span class="w"></span></pre> </div> </div></li> <li><p>创建第二个数据测试:在<gydF4y2Bastrong>项目</gydF4y2Bastrong>窗格，单击<gydF4y2Bastrong>测试</gydF4y2Bastrong>文件夹，单击省略号，然后单击<gydF4y2Bastrong>新文件</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">测试/ zzz_game_details_check_scores.sql</gydF4y2Baspan></code>并点击<gydF4y2Bastrong>创建</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details_check_scores.sql</gydF4y2Baspan></code>输入以下SQL语句，单击<gydF4y2Bastrong>保存</gydF4y2Bastrong>．该文件包括一个数据测试，以确定是否有任何比分为负或任何比赛平局。</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">这项运动不允许负分或平局。</gydF4y2Baspan><span class="c1">—要通过此测试，此查询必须不返回任何结果。</gydF4y2Baspan><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="n">home_score</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">visitor_score</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_details</gydF4y2Baspan><span class="w"></span><span class="k">在哪里</gydF4y2Baspan><span class="w"></span><span class="n">home_score</gydF4y2Baspan><span class="w"></span><span class="o"><</gydF4y2Baspan><span class="w"></span><span class="mi">0</gydF4y2Baspan><span class="w"></span><span class="k">或</gydF4y2Baspan><span class="w"></span><span class="n">visitor_score</gydF4y2Baspan><span class="w"></span><span class="o"><</gydF4y2Baspan><span class="w"></span><span class="mi">0</gydF4y2Baspan><span class="w"></span><span class="k">或</gydF4y2Baspan><span class="w"></span><span class="n">home_score</gydF4y2Baspan><span class="w"></span><span class="o">＝</gydF4y2Baspan><span class="w"></span><span class="n">visitor_score</gydF4y2Baspan><span class="w"></span></pre> </div> </div></li> <li><p>创建第三个数据测试:在<gydF4y2Bastrong>项目</gydF4y2Bastrong>窗格，单击<gydF4y2Bastrong>测试</gydF4y2Bastrong>文件夹，单击省略号，然后单击<gydF4y2Bastrong>新文件</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">测试/ zzz_win_loss_records_check_records.sql</gydF4y2Baspan></code>并点击<gydF4y2Bastrong>创建</gydF4y2Bastrong>．</gydF4y2Bap></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_win_loss_records_check_records.sql</gydF4y2Baspan></code>输入以下SQL语句，单击<gydF4y2Bastrong>保存</gydF4y2Bastrong>．该文件包括一个数据测试，以确定是否有任何球队的输赢记录为负，输赢记录超过了比赛次数，或者比赛次数超过了允许的次数。</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——本赛季每队各参加4场比赛。</gydF4y2Baspan><span class="c1">—要通过此测试，此查询必须不返回任何结果。</gydF4y2Baspan><span class="k">选择</gydF4y2Baspan><span class="w"></span><span class="n">赢了</gydF4y2Baspan><span class="p">，</gydF4y2Baspan><span class="w"></span><span class="n">损失</gydF4y2Baspan><span class="w"></span><span class="k">从</gydF4y2Baspan><span class="w"></span><span class="n">zzz_win_loss_records</gydF4y2Baspan><span class="w"></span><span class="k">在哪里</gydF4y2Baspan><span class="w"></span><span class="n">赢了</gydF4y2Baspan><span class="w"></span><span class="o"><</gydF4y2Baspan><span class="w"></span><span class="mi">0</gydF4y2Baspan><span class="w"></span><span class="k">或</gydF4y2Baspan><span class="w"></span><span class="n">赢了</gydF4y2Baspan><span class="w"></span><span class="o">></gydF4y2Baspan><span class="w"></span><span class="mi">4</gydF4y2Baspan><span class="w"></span><span class="k">或</gydF4y2Baspan><span class="w"></span><span class="n">损失</gydF4y2Baspan><span class="w"></span><span class="o"><</gydF4y2Baspan><span class="w"></span><span class="mi">0</gydF4y2Baspan><span class="w"></span><span class="k">或</gydF4y2Baspan><span class="w"></span><span class="n">损失</gydF4y2Baspan><span class="w"></span><span class="o">></gydF4y2Baspan><span class="w"></span><span class="mi">4</gydF4y2Baspan><span class="w"></span><span class="k">或</gydF4y2Baspan><span class="w"></span><span class="p">（</gydF4y2Baspan><span class="n">赢了</gydF4y2Baspan><span class="w"></span><span class="o">+</gydF4y2Baspan><span class="w"></span><span class="n">损失</gydF4y2Baspan><span class="p">）</gydF4y2Baspan><span class="w"></span><span class="o">></gydF4y2Baspan><span class="w"></span><span class="mi">4</gydF4y2Baspan><span class="w"></span></pre> </div> </div></li> <li><p>中运行模式测试:<gydF4y2Bastrong>运行</gydF4y2Bastrong>方框，运行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技术部</gydF4y2Baspan><span class="pre">测验</gydF4y2Baspan></code>命令使用<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">——模式</gydF4y2Baspan></code>属性中的两个模型的名称<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ schema.yml</gydF4y2Baspan></code>文件运行为这些模型指定的测试。</gydF4y2Bap> <div class="highlight-bash notranslate"> <div class="highlight"> <pre><span></span>印度生物技术部<gydF4y2Baspan class="nb">测验</gydF4y2Baspan>——schema——models zzz_game_details zzz_win_loss_records</gydF4y2Bapre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">．.．</gydF4y2Baspan><span class="go">．.．| 1 of 15 START测试accepted_values_zzz_game_details_home__阿姆斯特丹__san_francisco__seattle [RUN]</gydF4y2Baspan><span class="go">．.．| 1 of 15 PASS accepted_values_zzz_game_details_home__Amsterdam__San_Francisco__Seattle [PASS…]</gydF4y2Baspan><span class="go">．.．</gydF4y2Baspan><span class="go">．.．|</gydF4y2Baspan><span class="go">．.．|完成15个测试…</gydF4y2Baspan><span class="go">成功完成</gydF4y2Baspan><span class="go">完成了。Pass =15 warn =0 error =0 skip =0 total =15</gydF4y2Baspan></pre> </div> </div></li> <li><p>运行数据测试:在<gydF4y2Bastrong>运行</gydF4y2Bastrong>方框，运行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技术部</gydF4y2Baspan><span class="pre">测验</gydF4y2Baspan></code>命令使用<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">——数据</gydF4y2Baspan></code>选项在项目中运行测试<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">测试</gydF4y2Baspan></code>目录中。</gydF4y2Bap> <div class="highlight-bash notranslate"> <div class="highlight"> <pre><span></span>印度生物技术部<gydF4y2Baspan class="nb">测验</gydF4y2Baspan>——数据</gydF4y2Bapre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">．.．</gydF4y2Baspan><span class="go">．.．1 | 3 zzz_game_details_check_dates开始测试 .......................(运行)</gydF4y2Baspan><span class="go">．.．1 | 3通过zzz_game_details_check_dates .............................(通过…)</gydF4y2Baspan><span class="go">．.．</gydF4y2Baspan><span class="go">．.．|</gydF4y2Baspan><span class="go">．.．|完成3个测试…</gydF4y2Baspan><span class="go">成功完成</gydF4y2Baspan><span class="go">完成了。Pass =3 warn =0 error =0 skip =0 total =3</gydF4y2Baspan></pre> </div> </div></li> </ol> </div> <div class="section" id="step-4-clean-up"> <h3>第四步:清理<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#step-4-clean-up" title=""></a></h3> <p>可以通过运行以下SQL代码删除为本例创建的表和视图。</gydF4y2Bap> <p>如果连接到集群，则可以从数据库运行此SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/notebooks/notebooks-manage.html"><span class="std std-ref">笔记本</gydF4y2Baspan></a>，并将SQL指定为笔记本的默认语言。如果连接到SQL仓库，则可以从数据库中运行此SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs/sql/user/queries/queries.html"><span class="std std-ref">查询</gydF4y2Baspan></a>．</gydF4y2Bap> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_opponents</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_scores</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">zzz_games</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">zzz_teams</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">zzz_game_details</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">视图</gydF4y2Baspan><span class="w"></span><span class="n">zzz_win_loss_records</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">钻石</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">表格</gydF4y2Baspan><span class="w"></span><span class="n">diamonds_four_cs</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">视图</gydF4y2Baspan><span class="w"></span><span class="n">diamonds_list_colors</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span><span class="k">下降</gydF4y2Baspan><span class="w"></span><span class="k">视图</gydF4y2Baspan><span class="w"></span><span class="n">diamonds_prices</gydF4y2Baspan><span class="p">；</gydF4y2Baspan><span class="w"></span></pre> </div> </div> </div> </div> <div class="section" id="next-steps"> <h2>下一个步骤<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#next-steps" title=""></a></h2> <ul class="simple"> <li><p>BOB低频彩了解更多关于dbt的知识<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/building-models">模型</gydF4y2Baa>．</gydF4y2Bap></li> <li><p>学习如何<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/tests">测验</gydF4y2Baa>你的DBT项目。</gydF4y2Bap></li> <li><p>学习如何使用<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/jinja-macros">金贾的</gydF4y2Baa>，一种模板语言，用于在dbt项目中编程SQL。</gydF4y2Bap></li> <li><p>了解dbt<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/guides/best-practices">最佳实践</gydF4y2Baa>．</gydF4y2Bap></li> </ul> </div> <div class="section" id="additional-resources"> <h2>额外的资源<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs/dev-tools/#additional-resources" title=""></a></h2> <ul class="simple"> <li><p><a class="reference external" href="https://blog.getdbt.com/what--exactly--is-dbt-/">dbt到底是什么?</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/introduction">dbt通用文档</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://github.com/dbt-labs/dbt">GitHub存储库</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/dbt-cli/cli-overview">印度生物技术部CLI</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://www.getdbt.com/pricing/">印度生物技术部的定价</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://blog.getdbt.com/analytics-engineering-for-everyone-databricks-in-dbt-cloud/">面向所有人的分析工程:dbt云中的数据</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-overview">dbt云概述</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-configuring-dbt-cloud/connecting-your-database">连接数据库</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://discourse.getdbt.com/">话语共同体</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://blog.getdbt.com/">印度生物技术部的博客</gydF4y2Baa></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-dbt-cloud-support">支持</gydF4y2Baa></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">bob下载地址©Databricks 2023。版权所有。Apache、Apache Spark、Spark和Spark标志均为<gydF4y2Baa href="http://www.apache.org/">Apache软件基金会</gydF4y2Baa>．</gydF4y2Bap> <p><a id="feedbacklink" href="mailto:doc-feedback@www.neidfyre.com?subject=Documentation Feedback">给我们反馈</gydF4y2Baa>|<gydF4y2Baa href="//www.neidfyre.com/docs/privacy-policy">隐私政策</gydF4y2Baa>|<gydF4y2Baa href="//www.neidfyre.com/docs/terms-of-use">使用条款</gydF4y2Baa></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">  </body> </html>