连接到印度生物技术部云|砖在谷歌的云<gydF4y2Ba/title> <link href="https://agao00.github.io/static/css/2.fb64e31e.chunk.css" rel="stylesheet"> <link href="https://agao00.github.io/static/css/main.06d416f3.chunk.css" rel="stylesheet"> <link rel="stylesheet" href="//www.neidfyre.com/docs.gcp/_static/css/theme.css" type="text/css"> <link rel="stylesheet" href="//www.neidfyre.com/docs.gcp/_static/css/custom.css" type="text/css"> <link rel="stylesheet" href="//www.neidfyre.com/docs.gcp/_static/css/algolia.css" type="text/css"> <link rel="stylesheet" href="//www.neidfyre.com/docs.gcp/_static/css/cloud-provider-selector.css" type="text/css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/80c8c516-6f89-11eb-883d-06d762ad9a62/searchbox.css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/80c8c516-6f89-11eb-883d-06d762ad9a62/external_styles.css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/80c8c516-6f89-11eb-883d-06d762ad9a62/feedback.css"> </head> <body class="wy-body-for-nav Connect to dbt Cloud" role="document">  <noscript> <iframe src="https://www.neidfyre.com/ns.html?id=GTM-T85FQ33" height="0" width="0" style="display:none;visibility:hidden"></iframe> </noscript> <noscript> <iframe src="https://www.neidfyre.com/ns.html?id=GTM-TWTKQQ" height="0" width="0" style="display:none;visibility:hidden"></iframe> </noscript>  <nav class="wy-nav-top header su_header" role="navigation" aria-label="top navigation"> <nav class="wy-nav-top header su_header" role="navigation" aria-label="top navigation"> <div class="container-logo"> <ul class="mobile-menu-toggle"> <li class="menu-toggle"><i data-toggle="wy-nav-top" class="wy-nav-top-menu-button db-icon db-icon-menu pull-left"></i><a href="//www.neidfyre.com/" class="wy-nav-top-logo"><img src="//www.neidfyre.com/docs.gcp/_static/databricks-logo-mobile.png" width="137" height="21" alt="砖gydF4y2Ba"></a></li> </ul> <ul class="su_nav-menu"> <li class="menu-toggle"><i data-toggle="wy-nav-top" class="wy-nav-top-menu-button db-icon db-icon-menu pull-left"></i><a href="//www.neidfyre.com/" class="wy-nav-top-logo"><img src="//www.neidfyre.com/docs.gcp/_static/databricks-logo-mobile.png" width="137" height="21" alt="砖gydF4y2Ba"></a></li> </ul> </div> <div class="su_nav-right"> <ul class="su_link-mobile">  </ul> <ul class="right-try-list"> <li><a href="//www.neidfyre.com/help">支持<gydF4y2Ba/a></li> <li><a href="mailto:doc-feedback@www.neidfyre.com?subject=Documentation Feedback">反馈<gydF4y2Ba/a></li> <li class="try-databrick-item"><a href="//www.neidfyre.com/docs.gcp/try-databricks">试着砖<gydF4y2Ba/a></li> </ul> </div> </nav> </nav> <div class="su_sub-header"> <div class="container"> <div class="su_sub-header-inner"> <div class="su_subnav-menu"> <ul> <li><a href="//www.neidfyre.com/help/s/">帮助中心<gydF4y2Ba/a></li> <li class="active"><a href="//www.neidfyre.com/docs.gcp/">文档<gydF4y2Ba/a></li> <li><a href="//www.neidfyre.com/kb.gcp/">知识库<gydF4y2Ba/a></li> </ul> </div> <div class="su_subnav-menu-right"> <div id="auto" style="width: 100%"> <div ng-controller="SearchautoController"> <div bind-html-compile="autocompleteHtml"> <form class="su__search-box-1"> <input class="su__search-input" type="search" name="Search box" id="su__search-b" placeholder="Search here"> <button class="button button-success" type="submit" on> <svg width="20" height="20" viewbox="0 0 28 28"> <path fill="#fff" d="M1688.27,61.271a1.327,1.327,0,0,1,0,1.859l-1.54,1.531a1.25,1.25,0,0,1-.93.383,1.282,1.282,0,0,1-.93-0.383l-5.46-5.469a1.254,1.254,0,0,1-.39-0.93V57.388a11.4,11.4,0,0,1-12.71.875,11.5,11.5,0,0,1-4.13-4.129,11.438,11.438,0,0,1,0-11.43,11.5,11.5,0,0,1,4.13-4.129,11.431,11.431,0,0,1,11.43,0,11.5,11.5,0,0,1,4.13,4.129,11.4,11.4,0,0,1-.88,12.715h0.88a1.282,1.282,0,0,1,.93.383Zm-16.25-5.852a6.952,6.952,0,0,0,3.53-.93,6.772,6.772,0,0,0,2.54-2.543,7.154,7.154,0,0,0,0-7.055,6.772,6.772,0,0,0-2.54-2.543,7.147,7.147,0,0,0-7.05,0,6.8,6.8,0,0,0-2.55,2.543,7.154,7.154,0,0,0,0,7.055,6.8,6.8,0,0,0,2.55,2.543A6.916,6.916,0,0,0,1672.02,55.419Z" transform="translate(-1660.66 -37.031)"></path> </svg></button> </form> </div> </div> </div> </div> <div> <select name="cloud provider selector" id="cloud-provider-selector"><option value="awsgydF4y2Ba">亚马逊网络服务<gydF4y2Ba/option><option value="azuregydF4y2Ba">微软Azure<gydF4y2Ba/option><option value="gcpgydF4y2Ba" selected>谷歌云平台bob体育客户端下载<gydF4y2Ba/option></select> </div> </div> </div> </div> <page class="js-page-container"> <nav data-toggle="wy-nav-shift" class="wy-nav-side su_nav-side"> <div class="wy-side-scroll"> <div class="wy-side-nav-search"></div> <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation"> <a href="//www.neidfyre.com/docs.gcp/index.html" class="main-navigation-home">砖在谷歌的云<gydF4y2Ba/a> <p class="caption"><span class="caption-text">开始<gydF4y2Ba/span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/getting-started/index.html">开始<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/introduction/index.html">砖是什么?<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/getting-started/tutorials/index.html">教程和最佳实践<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/release-notes/index.html">发布说明<gydF4y2Ba/a></li> </ul> <p class="caption"><span class="caption-text">加载和管理数据<gydF4y2Ba/span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/ingestion/index.html">加载数据<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/exploratory-data-analysis/index.html">探索数据<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/data-preparation/index.html">准备数据<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/data-sharing/index.html">共享数据(δ共享)<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/marketplace/index.html">砖的市场<gydF4y2Ba/a></li> </ul> <p class="caption"><span class="caption-text">处理数据<gydF4y2Ba/span></p> <ul class="current"> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/workspace-index.html">工程数据<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/machine-learning/index.html">机器学习<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/sql/index.html">数据仓库<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/delta/index.html">三角洲湖<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/dev-tools/index.html">开发人员工具<gydF4y2Ba/a></li> <li class="toctree-l1 current"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/integrations/index.html">技术合作伙伴bob体育外网下载<gydF4y2Ba/a> <ul class="current"> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/index.html">合作伙伴联系<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/integrations/jdbc-odbc-bi.html">配置ODBC、JDBC驱动程序<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/ingestion.html">摄入<gydF4y2Ba/a></li> <li class="toctree-l2 current"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/prep.html">数据准备和转换<gydF4y2Ba/a> <ul class="current"> <li class="toctree-l3 current"><a class="current reference internal" href="//www.neidfyre.com/docs.gcp/partners/prep/#">印度生物技术部的云<gydF4y2Ba/a></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partners/prep/dbt.html">印度生物技术部核心<gydF4y2Ba/a></li> <li class="toctree-l3"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partners/prep/prophecy.html">预言<gydF4y2Ba/a></li> </ul></li> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/ml.html">机器学习<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/bi.html">BI和可视化<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/reverse-etl.html">反向ETL<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/semantic-layer.html">语义层<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/data-governance.html">数据治理<gydF4y2Ba/a></li> <li class="toctree-l2"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/integrations/excel.html">连接到数据砖从Microsoft Excel<gydF4y2Ba/a></li> </ul></li> </ul> <p class="caption"><span class="caption-text">政府<gydF4y2Ba/span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/administration-guide/index.html">账户和工作区管理<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/security/index.html">安全性和遵从性<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/data-governance/index.html">数据治理<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/lakehouse-architecture/index.html">Lakehouse架构<gydF4y2Ba/a></li> </ul> <p class="caption"><span class="caption-text">引用和资源<gydF4y2Ba/span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/reference/api.html">参考<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/resources/index.html">资源<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/whats-coming.html">未来是什么?<gydF4y2Ba/a></li> <li class="toctree-l1"><a class="reference internal" href="//www.neidfyre.com/docs.gcp/archive/index.html">文档归档<gydF4y2Ba/a></li> </ul> </div> <div role="contentinfo"> <p class="build_info" data-last-edit="July 18, 2023">2023年8月2日更新<gydF4y2Ba/p> <p><a id="feedbacklink" href="mailto:doc-feedback@www.neidfyre.com?subject=Documentation Feedback">给我们反馈<gydF4y2Ba/a></p> </div> </div> </nav> <main class="wy-grid-for-nav su_nav-grid"> <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap"> <div class="wy-nav-content su__nav_content"> <div class="rst-content"> <div role="navigation" aria-label="breadcrumbs navigation" class="wy-breadcrumbs-wrapper"> <ul class="wy-breadcrumbs"> <li><a href="//www.neidfyre.com/docs.gcp/index.html">文档<gydF4y2Ba/a><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.neidfyre.com/docs.gcp/integrations/index.html">技术合作伙伴bob体育外网下载<gydF4y2Ba/a><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.neidfyre.com/docs.gcp/partner-connect/prep.html">连接到数据准备合作伙伴使用合作伙伴连接bob体育外网下载<gydF4y2Ba/a><span class="db-icon db-icon-chevron-right"></span></li> <li>连接到印度生物技术部云<gydF4y2Ba/li> <li class="wy-breadcrumbs-aside"></li> </ul> </div> <div role="main" class="document" itemscope itemtype="http://schema.org/Article"> <div itemprop="articleBody"> <div class="section" id="connect-to-dbt-cloud"> <h1>连接到印度生物技术部云<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#connect-to-dbt-cloud" title=""></a></h1> <p>印度生物技术部(数据构建工具)是一个开发环境,使数据分析师和数据工程师将数据通过简单的select语句。印度生物技术部处理这些select语句表和视图。印度生物技术部将代码编译为原始SQL,然后运行该代码指定的数据库中数据砖。印度生物技术部支持协作编码模式和最佳实践,如版本控制、文档和模块化。<gydF4y2Ba/p> <p>印度生物技术部不提取或加载数据。印度生物技术部只专注于转换步骤,使用“转换后加载”架构。印度生物技术部假设您已经有一个复制数据库中的数据。<gydF4y2Ba/p> <p>本文主要关注印度生物技术部云。印度生物技术部云配有交钥匙支持调度工作,CI / CD,服务文档,监控和警报,以及一个集成开发环境(IDE)。<gydF4y2Ba/p> <p>印度生物技术部的本地版本称为印度生物技术部核心也是可用的。印度生物技术部核心使您能够编写印度生物技术部代码在您所选的文本编辑器或IDE本地开发机器上,然后从命令行运行印度生物技术部。印度生物技术部核心包括印度生物技术部命令行接口(CLI)。印度生物技术部CLI是免费使用的,开源的。bob下载地址有关更多信息,请参见<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/partners/prep/dbt.html"><span class="doc">连接到印度生物技术部核心<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <p>因为印度生物技术部云和印度生物技术部核心可以使用托管git存储库(例如,在GitHub, GitLab或BitBucket都),您可以使用印度生物技术部云来创建一个印度生物技术部项目,然后提供给你的印度生物技术部云和印度生物技术部核心用户。有关更多信息,请参见<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/projects">创建一个印度生物技术部项目<gydF4y2Ba/a>和<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/projects">使用现有的项目<gydF4y2Ba/a>印度生物技术部的网站上。<gydF4y2Ba/p> <p>印度生物技术部的一般概述,请看下面的YouTube视频(26分钟)。<gydF4y2Ba/p> <p></p> <iframe width="640" height="360" style="margin-bottom: 25px" src="https://www.youtube.com/embed/zoHoIGE6tPc?rel=0" frameborder="0" allowfullscreen="1"> </iframe> <p></p> <div class="section" id="connect-to-dbt-cloud-using-partner-connect"> <span id="connect-to-dbt-cloud-using-pc"></span> <span id="partner-connect"></span> <h2>使用合作伙伴连接连接到印度生物技术部云<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#connect-to-dbt-cloud-using-partner-connect" title=""></a></h2> <p>本节描述如何连接砖SQL的仓库使用合作伙伴连接印度生物技术部云,然后给印度生物技术部云读访问你的数据。<gydF4y2Ba/p> <div class="section" id="differences-between-standard-connections-and-dbt-cloud"> <span id="differences"></span> <h3>标准连接和印度生物技术部云之间的区别<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#differences-between-standard-connections-and-dbt-cloud" title=""></a></h3> <p>使用合作伙伴连接连接到印度生物技术部云,你遵循的步骤<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/prep.html"><span class="doc">连接到数据准备合作伙伴使用合作伙伴连接bob体育外网下载<gydF4y2Ba/span></a>。印度生物技术部云连接是不同于标准的数据准备和转换连接在以下方式:<gydF4y2Ba/p> <ul class="simple"> <li><p>除了一个服务主体和个人访问令牌,合作伙伴连接创建一个SQL仓库(原SQL端点)命名<gydF4y2Bastrong>DBT_CLOUD_ENDPOINT<gydF4y2Ba/strong>默认情况下。<gydF4y2Ba/p></li> </ul> </div> <div class="section" id="steps-to-connect"> <span id="partner-connect-steps"></span> <h3>步骤来连接<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#steps-to-connect" title=""></a></h3> <p>使用合作伙伴连接连接到印度生物技术部云,做到以下几点:<gydF4y2Ba/p> <ol class="arabic"> <li><p><a class="reference internal" href="//www.neidfyre.com/docs.gcp/partner-connect/prep.html"><span class="doc">连接到数据准备合作伙伴使用合作伙伴连接bob体育外网下载<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> <li><p>在您连接到印度生物技术部云,印度生物技术部云仪表板出现。探索印度生物技术部云项目,在菜单栏中,印度生物技术部标志旁边,从第一个下拉选择你的印度生物技术部账户名称如果不显示出来,然后选择<gydF4y2Bastrong>砖伙伴连接试验<gydF4y2Ba/strong>项目从第二个下拉菜单如果不显示。<gydF4y2Ba/p> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>查看项目的设置,单击“三条纹”或“汉堡包”菜单,点击<gydF4y2Bastrong>帐户设置>项目<gydF4y2Ba/strong>项目的名称,然后单击。查看连接设置,点击旁边的链接<gydF4y2Bastrong>连接<gydF4y2Ba/strong>。要更改任何设置,点击<gydF4y2Bastrong>编辑<gydF4y2Ba/strong>。<gydF4y2Ba/p> <p>把砖个人访问令牌信息对于这个项目,单击菜单栏上的“人”图标,点击<gydF4y2Bastrong>概要文件>凭证>砖伙伴连接试验<gydF4y2Ba/strong>项目的名称,然后单击。要做出改变,单击<gydF4y2Bastrong>编辑<gydF4y2Ba/strong>。<gydF4y2Ba/p> </div></li> </ol> </div> <div class="section" id="steps-to-give-dbt-cloud-read-access-to-your-data"> <span id="read-access"></span> <h3>步骤给印度生物技术部云读访问您的数据<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#steps-to-give-dbt-cloud-read-access-to-your-data" title=""></a></h3> <p>合作伙伴将允许只创建连接到<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>只在默认目录服务主体。按照以下步骤在您的砖工作区给<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>服务主体读访问权你选择的数据。<gydF4y2Ba/p> <div class="admonition warning"> <p class="admonition-title">警告<gydF4y2Ba/p> <p>您可以调整这些步骤给印度生物技术部云额外的访问在目录、数据库和表在你的工作区。然而,作为一个安全最佳实践,砖强烈建议你给访问单独的表,你需要<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>服务主体与和只读访问这些表。<gydF4y2Ba/p> </div> <ol class="arabic"> <li><p>您的工作区切换到<gydF4y2Bastrong>SQL<gydF4y2Ba/strong>的角色。要做到这一点,在你的工作空间的侧边栏,单击图标下面砖的标志<gydF4y2Baimg alt="砖的标志gydF4y2Ba" src="//www.neidfyre.com/docs.gcp/_images/databricks-logo.png">,然后选择<gydF4y2Bastrong>SQL<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>点击<gydF4y2Baimg alt="数据图标gydF4y2Ba" src="//www.neidfyre.com/docs.gcp/_images/data-icon.png"><strong>数据<gydF4y2Ba/strong>在侧边栏。<gydF4y2Ba/p></li> <li><p>选择SQL仓库(<gydF4y2Bastrong>DBT_CLOUD_ENDPOINT<gydF4y2Ba/strong>顶部的下拉列表)。<gydF4y2Ba/p> <div class="figure align-default"> <img alt="选择仓库gydF4y2Ba" src="//www.neidfyre.com/docs.gcp/_images/select-endpoint.png"> </div> <ol class="loweralpha simple"> <li><p>下<gydF4y2Bastrong>数据浏览<gydF4y2Ba/strong>,选择的目录,其中包含数据库表。<gydF4y2Ba/p></li> <li><p>选择包含您的数据库表。<gydF4y2Ba/p></li> <li><p>选择您的表。<gydF4y2Ba/p></li> </ol> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>如果您没有看到您的目录、数据库或表列出,输入名称的任何部分<gydF4y2Bastrong>选择目录<gydF4y2Ba/strong>,<gydF4y2Bastrong>选择数据库<gydF4y2Ba/strong>,或<gydF4y2Bastrong>过滤表<gydF4y2Ba/strong>列表框,分别来缩小。<gydF4y2Ba/p> <div class="figure align-default"> <img alt="过滤表gydF4y2Ba" src="//www.neidfyre.com/docs.gcp/_images/filter-tables.png"> </div> </div></li> <li><p>点击<gydF4y2Bastrong>权限<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>点击<gydF4y2Bastrong>格兰特<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>为<gydF4y2Bastrong>类型添加多个用户或组<gydF4y2Ba/strong>中,选择<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>。这个砖服务主体的合作伙伴为你在前一节中创建连接。<gydF4y2Ba/p> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>如果您没有看到<gydF4y2Bastrong>DBT_CLOUD_USER<gydF4y2Ba/strong>,开始打字<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">DBT_CLOUD_USER<gydF4y2Ba/span></code>在<gydF4y2Bastrong>类型添加多个用户或组<gydF4y2Ba/strong>盒子,直到它出现在列表中,然后选择它。<gydF4y2Ba/p> </div></li> <li><p>只有选择授予读访问<gydF4y2Bastrong>选择<gydF4y2Ba/strong>和<gydF4y2Bastrong>READ_METADATA<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>点击<gydF4y2Bastrong>好吧<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> </ol> <p>重复步骤4 - 9日为每个额外的表,你想给印度生物技术部云读访问权。<gydF4y2Ba/p> </div> <div class="section" id="troubleshoot-the-dbt-cloud-connection"> <span id="troubleshoot-partner-connect"></span> <h3>排除印度生物技术部云连接<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#troubleshoot-the-dbt-cloud-connection" title=""></a></h3> <p>如果有人删除的项目在印度生物技术部云账户,你点击<gydF4y2Bastrong>印度生物技术部<gydF4y2Ba/strong>瓷砖,则会出现一条错误消息,指出项目无法找到。为了解决这个问题,点击<gydF4y2Bastrong>删除连接<gydF4y2Ba/strong>这个过程,然后从头开始再次创建连接。<gydF4y2Ba/p> </div> </div> <div class="section" id="connect-to-dbt-cloud-manually"> <span id="manual-connection"></span> <h2>手动连接到印度生物技术部云<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#connect-to-dbt-cloud-manually" title=""></a></h2> <p>本节描述如何连接砖集群或砖SQL仓库砖工作区印度生物技术部云。<gydF4y2Ba/p> <div class="admonition important"> <p class="admonition-title">重要的<gydF4y2Ba/p> <p>砖建议连接到SQL的仓库。如果你没有砖的SQL访问权利,或者如果你想运行Python模型,您可以连接到一个集群。<gydF4y2Ba/p> </div> <div class="section" id="requirements"> <span id="manual-requirements"></span> <h3>需求<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#requirements" title=""></a></h3> <ul> <li><p>一个集群或SQL仓库在砖工作区。<gydF4y2Ba/p> <ul class="simple"> <li><p><a class="reference internal" href="//www.neidfyre.com/docs.gcp/clusters/configure.html"><span class="doc">创建一个集群<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> <li><p><a class="reference internal" href="//www.neidfyre.com/docs.gcp/sql/admin/create-sql-warehouse.html"><span class="doc">配置SQL仓库<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> </ul></li> <li><p>集群或SQL的连接细节仓库,专门的<gydF4y2Bastrong>服务器主机名<gydF4y2Ba/strong>,<gydF4y2Bastrong>港口<gydF4y2Ba/strong>,<gydF4y2Bastrong>HTTP路径<gydF4y2Ba/strong>值。<gydF4y2Ba/p> <ul class="simple"> <li><p><a class="reference internal" href="//www.neidfyre.com/docs.gcp/integrations/jdbc-odbc-bi.html"><span class="std std-ref">获得一个集群的连接细节<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> <li><p><a class="reference internal" href="//www.neidfyre.com/docs.gcp/integrations/jdbc-odbc-bi.html"><span class="std std-ref">得到一个SQL的连接细节,仓库<gydF4y2Ba/span></a>。<gydF4y2Ba/p></li> </ul></li> <li><p>一个砖<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/dev-tools/auth.html"><span class="std std-ref">个人访问令牌<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <div class="admonition note"> <p class="admonition-title">请注意<gydF4y2Ba/p> <p>安全最佳实践,当您使用自动化工具进行身份验证,系统中,脚本和应用程序,砖属于建议您使用个人访问令牌<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/administration-guide/users-groups/service-principals.html"><span class="doc">服务主体<gydF4y2Ba/span></a>而不是用户工作区。为服务主体,创建令牌<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/administration-guide/users-groups/service-principals.html"><span class="std std-ref">服务主体的管理令牌<gydF4y2Ba/span></a>。<gydF4y2Ba/p> </div></li> </ul> <ul> <li><p>连接印度生物技术部云数据管理的统一目录,印度生物技术部版本1.1或更高版本。<gydF4y2Ba/p><p>本文中的步骤创建一个新的环境,印度生物技术部使用最新版本。印度生物技术部版本升级现有的信息环境,明白了<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-versions/upgrade-core-in-cloud">升级到最新版本的印度生物技术部在云<gydF4y2Ba/a>印度生物技术部的文档。<gydF4y2Ba/p></li> </ul> </div> <div class="section" id="step-1-sign-up-for-dbt-cloud"> <span id="sign-up"></span> <h3>第一步:注册印度生物技术部云<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#step-1-sign-up-for-dbt-cloud" title=""></a></h3> <p>去<gydF4y2Baa class="reference external" href="https://www.getdbt.com/signup/">印度生物技术部云-注册<gydF4y2Ba/a>输入您的电子邮件,姓名和公司信息。创建一个密码,然后单击<gydF4y2Bastrong>创建我的帐户<gydF4y2Ba/strong>。<gydF4y2Ba/p> </div> <div class="section" id="step-2-create-a-dbt-project"> <span id="create-project"></span> <h3>步骤2:创建一个印度生物技术部项目<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#step-2-create-a-dbt-project" title=""></a></h3> <p>在这个步骤中,您创建一个印度生物技术部<gydF4y2Baem>项目<gydF4y2Ba/em>,其中包含一个连接到一个砖集群或SQL的仓库,一个存储库,其中包含源代码,和一个或多个环境(如测试和生产环境)。<gydF4y2Ba/p> <ol class="arabic"> <li><p><a class="reference external" href="https://cloud.getdbt.com/login/">在印度生物技术部云迹象<gydF4y2Ba/a>。<gydF4y2Ba/p></li> <li><p>点击设置图标,然后单击<gydF4y2Bastrong>帐户设置<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>点击<gydF4y2Bastrong>新项目<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>为<gydF4y2Bastrong>的名字<gydF4y2Ba/strong>输入惟一名称为您的项目,然后单击<gydF4y2Bastrong>继续<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>为<gydF4y2Bastrong>选择一个仓库<gydF4y2Ba/strong>,点击<gydF4y2Bastrong>砖<gydF4y2Ba/strong>,然后单击<gydF4y2Bastrong>下一个<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>为<gydF4y2Bastrong>的名字<gydF4y2Ba/strong>这个连接,输入一个唯一的名称。<gydF4y2Ba/p></li> <li><p>为<gydF4y2Bastrong>选择适配器<gydF4y2Ba/strong>中,选择<gydF4y2Bastrong>砖(dbt-databricks)<gydF4y2Ba/strong>。<gydF4y2Ba/p> <div class="admonition note"> <p class="admonition-title">请注意<gydF4y2Ba/p> <p>默认情况下,新项目使用砖(dbt-databricks)的适配器,它支持统一目录。现有项目迁移到砖(dbt-databricks),看到的<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/guides/migration/tools/migrating-from-spark-to-databricks">从dbt-spark迁移到dbt-databricks<gydF4y2Ba/a>印度生物技术部的文档。<gydF4y2Ba/p> </div></li> <li><p>为<gydF4y2Bastrong>服务器主机名<gydF4y2Ba/strong>中,输入服务器主机名的价值需求。<gydF4y2Ba/p></li> <li><p>为<gydF4y2Bastrong>HTTP路径<gydF4y2Ba/strong>,输入HTTP路径值的要求。<gydF4y2Ba/p></li> <li><p>如果你的工作区Catalog-enabled统一,<gydF4y2Bastrong>可选设置<gydF4y2Ba/strong>,为印度生物技术部云输入目录的名称使用。<gydF4y2Ba/p></li> <li><p>为<gydF4y2Bastrong>令牌<gydF4y2Ba/strong>从需求,输入个人访问令牌。<gydF4y2Ba/p></li> <li><p>为<gydF4y2Bastrong>模式<gydF4y2Ba/strong>输入模式的名称,你想要印度生物技术部云创建表和视图(例如,<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默认的<gydF4y2Ba/span></code>)。<gydF4y2Ba/p></li> <li><p>点击<gydF4y2Bastrong>测试连接<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>如果测试成功,单击<gydF4y2Bastrong>继续<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> </ol> <p></p> <p></p> <p>有关更多信息,请参见<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-configuring-dbt-cloud/connecting-your-database">连接到数据砖ODBC<gydF4y2Ba/a>印度生物技术部的网站上。<gydF4y2Ba/p> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>为这个项目查看或更改设置,或删除项目,点击设置图标,点击<gydF4y2Bastrong>帐户设置>项目<gydF4y2Ba/strong>项目的名称,然后单击。要更改设置,请单击<gydF4y2Bastrong>编辑<gydF4y2Ba/strong>。删除该项目,点击<gydF4y2Bastrong>编辑>删除项目<gydF4y2Ba/strong>。<gydF4y2Ba/p> <p>查看或改变你的砖个人访问令牌的值对于这个项目,单击“人”图标,点击<gydF4y2Bastrong>概要文件>凭证<gydF4y2Ba/strong>项目的名称,然后单击。要做出改变,单击<gydF4y2Bastrong>编辑<gydF4y2Ba/strong>。<gydF4y2Ba/p> </div> <p>后连接到一个砖集群或砖SQL仓库,按照屏幕上的指示<gydF4y2Bastrong>建立一个库<gydF4y2Ba/strong>然后点击<gydF4y2Bastrong>继续<gydF4y2Ba/strong>。<gydF4y2Ba/p> <p>设置存储库之后,按照屏幕上的指示邀请用户,然后单击<gydF4y2Bastrong>完整的<gydF4y2Ba/strong>。或者点击<gydF4y2Bastrong>跳过&完成<gydF4y2Ba/strong>。<gydF4y2Ba/p> <p>继续本教程或下一个步骤。<gydF4y2Ba/p> </div> </div> <div class="section" id="tutorial"> <h2>教程<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#tutorial" title=""></a></h2> <p>在本节中,您使用您的印度生物技术部云项目使用一些样例数据。本节假设您已经创建了您的项目,印度生物技术部云IDE打开该项目。<gydF4y2Ba/p> <div class="section" id="step-1-create-and-run-models"> <span id="create-model"></span> <h3>步骤1:创建和运行模式<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#step-1-create-and-run-models" title=""></a></h3> <p>在这个步骤中,您使用印度生物技术部云IDE创建和运行<gydF4y2Baem>模型<gydF4y2Ba/em>,这是<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">选择<gydF4y2Ba/span></code>语句创建一个新视图(默认)或一个新表在数据库中,基于现有的数据在同一数据库中。这个程序创建一个模型基于样本<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">钻石<gydF4y2Ba/span></code>表的<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/dbfs/databricks-datasets.html"><span class="doc">样本数据集<gydF4y2Ba/span></a>,如所描述的<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/getting-started/quick-start.html"><span class="std std-ref">创建一个表<gydF4y2Ba/span></a>的部分<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/getting-started/quick-start.html"><span class="doc">与笔记本电脑教程:查询数据<gydF4y2Ba/span></a>。这个过程假定这个表已经在工作区中创建的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默认的<gydF4y2Ba/span></code>数据库。<gydF4y2Ba/p> <ol class="arabic"> <li><p>与项目打开,点击<gydF4y2Bastrong>开始开发<gydF4y2Ba/strong>。<gydF4y2Ba/p> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>如果<gydF4y2Bastrong>开始开发<gydF4y2Ba/strong>按钮不显示,点击<gydF4y2Bastrong>开发<gydF4y2Ba/strong>在“三条纹”或“汉堡包”菜单。<gydF4y2Ba/p> </div></li> <li><p>在<gydF4y2Bastrong>项目<gydF4y2Ba/strong>窗格中,单击<gydF4y2Bastrong>初始化您的项目<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>创建第一个模型:单击<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夹,单击省略号,然后单击<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ diamonds_four_cs.sql<gydF4y2Ba/span></code>并点击<gydF4y2Bastrong>创建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_four_cs.sql<gydF4y2Ba/span></code>文件,输入下面的SQL语句,然后单击<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。这种说法只选择克拉,切割、颜色和清晰的细节为每个钻石<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">钻石<gydF4y2Ba/span></code>表。的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置<gydF4y2Ba/span></code>块指示印度生物技术部在数据库中创建一个表基于此声明。<gydF4y2Ba/p> <div class="highlight-default notranslate"> <div class="highlight"> <pre><span></span><span class="p">{{<gydF4y2Ba/span><span class="n">配置<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">物化<gydF4y2Ba/span><span class="o">=<gydF4y2Ba/span><span class="s1">“表”<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="n">file_format<gydF4y2Ba/span><span class="o">=<gydF4y2Ba/span><span class="s1">“δ”<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="p">}}<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="n">克拉<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">减少<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">颜色<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">清晰<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">钻石<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="admonition tip"> <p class="admonition-title">提示<gydF4y2Ba/p> <p>额外的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置<gydF4y2Ba/span></code>选项,如<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">合并<gydF4y2Ba/span></code>增量策略,看到<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/reference/resource-configs/databricks-configs">砖的配置<gydF4y2Ba/a>印度生物技术部的文档。<gydF4y2Ba/p> </div></li> <li><p>创建第二个模型:在<gydF4y2Bastrong>项目<gydF4y2Ba/strong>窗格中,单击<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夹,单击省略号,然后单击<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ diamonds_list_colors.sql<gydF4y2Ba/span></code>并点击<gydF4y2Bastrong>创建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_list_colors.sql<gydF4y2Ba/span></code>文件,输入下面的SQL语句,然后单击<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。这个语句选择独特的值<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">颜色<gydF4y2Ba/span></code>列<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_four_cs<gydF4y2Ba/span></code>表,首先按字母顺序排序的结果。因为没有<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置<gydF4y2Ba/span></code>块,该模型指导印度生物技术部在数据库中创建一个视图基于此声明。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="k">截然不同的<gydF4y2Ba/span><span class="w"></span><span class="n">颜色<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_four_cs<gydF4y2Ba/span><span class="w"></span><span class="n">排序<gydF4y2Ba/span><span class="w"></span><span class="k">通过<gydF4y2Ba/span><span class="w"></span><span class="n">颜色<gydF4y2Ba/span><span class="w"></span><span class="k">asc<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>创建第三个模型:在<gydF4y2Bastrong>项目<gydF4y2Ba/strong>窗格中,单击<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夹,单击省略号,然后单击<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ diamonds_prices.sql<gydF4y2Ba/span></code>并点击<gydF4y2Bastrong>创建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_prices.sql<gydF4y2Ba/span></code>文件,输入下面的SQL语句,然后单击<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。这个语句平均钻石价格的颜色,排序结果的平均价格从最高到最低。该模型指导印度生物技术部在数据库中创建一个视图基于此声明。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="n">颜色<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="k">avg<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">价格<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">价格<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">钻石<gydF4y2Ba/span><span class="w"></span><span class="k">集团<gydF4y2Ba/span><span class="w"></span><span class="k">通过<gydF4y2Ba/span><span class="w"></span><span class="n">颜色<gydF4y2Ba/span><span class="w"></span><span class="k">订单<gydF4y2Ba/span><span class="w"></span><span class="k">通过<gydF4y2Ba/span><span class="w"></span><span class="n">价格<gydF4y2Ba/span><span class="w"></span><span class="k">desc<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>运行模式:在<gydF4y2Bastrong>运行<gydF4y2Ba/strong>盒子,运行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技术部<gydF4y2Ba/span><span class="pre">运行<gydF4y2Ba/span></code>与前三个文件路径的命令。在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默认的<gydF4y2Ba/span></code>创建一个数据库,辩证行为疗法表命名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_four_cs<gydF4y2Ba/span></code>和两个视图命名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_list_colors<gydF4y2Ba/span></code>和<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">diamonds_prices<gydF4y2Ba/span></code>。印度生物技术部得到这些相关的视图和表名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">. sql<gydF4y2Ba/span></code>文件的名字。<gydF4y2Ba/p> <div class="highlight-bash notranslate"> <div class="highlight"> <pre><span></span>印度生物技术部/ diamonds_four_cs运行——模型模型。sql / diamonds_list_colors模型。sql模型/ diamonds_prices.sql<gydF4y2Ba/pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">…<gydF4y2Ba/span><span class="go">…| 1 3开始表模型default.diamonds_four_cs ....................(运行)<gydF4y2Ba/span><span class="go">…| 1 3创建好表模型default.diamonds_four_cs ...............(好吧…)<gydF4y2Ba/span><span class="go">…| 2 3开始视图模型default.diamonds_list_colors .................(运行)<gydF4y2Ba/span><span class="go">…| 2 3好创建视图模型default.diamonds_list_colors ............(好吧…)<gydF4y2Ba/span><span class="go">…| 3的3开始视图模型default.diamonds_prices ......................(运行)<gydF4y2Ba/span><span class="go">…| 3的3好创建视图模型default.diamonds_prices .................(好吧…)<gydF4y2Ba/span><span class="go">…|<gydF4y2Ba/span><span class="go">…|运行结束之后1表格模型,2视图模型……<gydF4y2Ba/span><span class="go">成功完成<gydF4y2Ba/span><span class="go">完成了。通过= 3 = 0 = 0跳过错误警告总= 3 = 0<gydF4y2Ba/span></pre> </div> </div></li> <li><p>运行以下SQL代码列表信息的新观点和选择从表中所有行和视图。<gydF4y2Ba/p><p>如果你连接到一个集群,您可以运行这个SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/notebooks/notebooks-manage.html"><span class="std std-ref">笔记本<gydF4y2Ba/span></a>附加到集群中,指定SQL作为默认语言的笔记本。如果你连接到SQL的仓库,你可以运行这个SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/sql/user/queries/queries.html"><span class="std std-ref">查询<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">显示<gydF4y2Ba/span><span class="w"></span><span class="n">的观点<gydF4y2Ba/span><span class="w"></span><span class="k">在<gydF4y2Ba/span><span class="w"></span><span class="k">默认的<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">| |名称空间viewName | isTemporary |<gydF4y2Ba/span><span class="go">+ = = = = = = = = = = = + = = = = = = = = = = = = = = = = = = = = = = + = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="go">| |违约diamonds_list_colors假| |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">| |违约diamonds_prices假| |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_four_cs<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">|克拉| |清晰| |颜色<gydF4y2Ba/span><span class="go">+ = = = = = = = + = = = = = = = = = + = = = = = = = + = = = = = = = = = +<gydF4y2Ba/span><span class="go">理想| 0.23 | | | E SI2 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">溢价| 0.21 | | | E SI1 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">…<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_list_colors<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - +<gydF4y2Ba/span><span class="go">| |颜色<gydF4y2Ba/span><span class="go">+ = = = = = = = +<gydF4y2Ba/span><span class="go">D | |<gydF4y2Ba/span><span class="go">+ - - - - - - - +<gydF4y2Ba/span><span class="go">| E |<gydF4y2Ba/span><span class="go">+ - - - - - - - +<gydF4y2Ba/span><span class="go">…<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_prices<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">| | |颜色价格<gydF4y2Ba/span><span class="go">+ = = = = = = = + = = = = = = = = = +<gydF4y2Ba/span><span class="go">J | | 5323.82 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">我| | 5091.87 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">…<gydF4y2Ba/span></pre> </div> </div></li> </ol> </div> <div class="section" id="step-2-create-and-run-more-complex-models"> <span id="complex-models"></span> <h3>步骤2:创建和运行更复杂的模型<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#step-2-create-and-run-more-complex-models" title=""></a></h3> <p>在这个步骤中,您创建更复杂的模型为一组相关的数据表。这些数据表包含的信息一个虚构的体育联盟的三支球队打一个赛季6场比赛。这个过程创建数据表,创建模型和运行模式。<gydF4y2Ba/p> <ol class="arabic"> <li><p>运行以下SQL代码创建必要的数据表。<gydF4y2Ba/p><p>如果你连接到一个集群,您可以运行这个SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/notebooks/notebooks-manage.html"><span class="std std-ref">笔记本<gydF4y2Ba/span></a>附加到集群中,指定SQL作为默认语言的笔记本。如果你连接到SQL的仓库,你可以运行这个SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/sql/user/queries/queries.html"><span class="std std-ref">查询<gydF4y2Ba/span></a>。<gydF4y2Ba/p><p>这一步开始的表和视图<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_<gydF4y2Ba/span></code>帮助确定他们作为这个示例的一部分。你不需要为自己的表和视图遵循这种模式。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="k">如果<gydF4y2Ba/span><span class="w"></span><span class="k">存在<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="k">如果<gydF4y2Ba/span><span class="w"></span><span class="k">存在<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="k">如果<gydF4y2Ba/span><span class="w"></span><span class="k">存在<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="k">如果<gydF4y2Ba/span><span class="w"></span><span class="k">存在<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">创建<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">home_team_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_team_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">使用<gydF4y2Ba/span><span class="w"></span><span class="n">δ<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">4<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">5<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">6<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="c1">——结果:<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| game_id | home_team_id | visitor_team_id |<gydF4y2Ba/span><span class="c1">- + = = = = = = = = = + = = = = = = = = = = = = = = + = = = = = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="c1">——| 1 | 1 | 2 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 2 | 1 | 3 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 3 | 2 | 1 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 4 | 2 | 3 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 5 | 3 | 1 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 6 | 3 | 2 |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="k">创建<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">home_team_score<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_team_score<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">使用<gydF4y2Ba/span><span class="w"></span><span class="n">δ<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">4<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">4<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">2<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">5<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">6<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="mi">1<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="c1">——结果:<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| game_id | home_team_score | visitor_team_score |<gydF4y2Ba/span><span class="c1">- + = = = = = = = = = + = = = = = = = = = = = = = = = = = + = = = = = = = = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="c1">——| 1 | 4 | 2 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 2 | 0 | 1 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 3 | 1 | 2 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 4 | 3 | 2 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 5 | 3 | 0 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 6 | 3 | 1 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="k">创建<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">使用<gydF4y2Ba/span><span class="w"></span><span class="n">δ<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2020-12-12”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-01-09”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2020-12-19”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">4<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-01-16”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">5<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-01-23”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">6<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-02-06”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="c1">——结果:<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| game_id | game_date |<gydF4y2Ba/span><span class="c1">- + = = = = = = = = = + = = = = = = = = = = = = +<gydF4y2Ba/span><span class="c1">——| 1 | 2020-12-12 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 2 | 2021-01-09 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 3 | 2020-12-19 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 4 | 2021-01-16 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 5 | 2021-01-23 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| 6 | 2021-02-06 |<gydF4y2Ba/span><span class="c1">- + - + - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="k">创建<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="n">team_id<gydF4y2Ba/span><span class="w"></span><span class="nb">INT<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">team_city<gydF4y2Ba/span><span class="w"></span><span class="nb">VARCHAR<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="mi">15<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">使用<gydF4y2Ba/span><span class="w"></span><span class="n">δ<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">1<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="ss">“旧金山”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">2<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="ss">“西雅图”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="k">插入<gydF4y2Ba/span><span class="w"></span><span class="k">成<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">值<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">3<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="ss">“阿姆斯特丹”<gydF4y2Ba/span><span class="p">);<gydF4y2Ba/span><span class="w"></span><span class="c1">——结果:<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">——| team_id | team_city |<gydF4y2Ba/span><span class="c1">- + = = = = = = = = = + = = = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="c1">旧金山——| 1 | |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">西雅图——| 2 | |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="c1">阿姆斯特丹- | 3 | |<gydF4y2Ba/span><span class="c1">- + - - - - - - - - - - - - - - - - - - - - - - - - - - +<gydF4y2Ba/span></pre> </div> </div></li> <li><p>创建第一个模型:在<gydF4y2Bastrong>项目<gydF4y2Ba/strong>窗格中,单击<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夹,单击省略号,然后单击<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ zzz_game_details.sql<gydF4y2Ba/span></code>并点击<gydF4y2Bastrong>创建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details.sql<gydF4y2Ba/span></code>文件,输入下面的SQL语句,然后单击<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。这条语句创建一个表,提供每个游戏的细节,比如团队的名字和分数。的<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">配置<gydF4y2Ba/span></code>块指示印度生物技术部在数据库中创建一个表基于此声明。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——创建一个表,提供全部细节为每个游戏,包括<gydF4y2Ba/span><span class="c1">——游戏ID,家里来访团队的城市名称和成绩,<gydF4y2Ba/span><span class="c1">——游戏的赢家的城市名称,比赛日期。<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-default notranslate"> <div class="highlight"> <pre><span></span><span class="p">{{<gydF4y2Ba/span><span class="n">配置<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">物化<gydF4y2Ba/span><span class="o">=<gydF4y2Ba/span><span class="s1">“表”<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="n">file_format<gydF4y2Ba/span><span class="o">=<gydF4y2Ba/span><span class="s1">“δ”<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="p">}}<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">步骤4的4:游客团队id替换为他们的城市的名字。<gydF4y2Ba/span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_city<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">游客<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">步骤3——4:显示城市名称为每个游戏的赢家。<gydF4y2Ba/span><span class="w"></span><span class="k">情况下<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">当<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">然后<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">当<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">然后<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_city<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">结束<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">赢家<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">步骤2 - 4:主队id替换为实际的城市名字。<gydF4y2Ba/span><span class="w"></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_city<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_team_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">步骤1 - 4:把数据从各种各样的表(例如,游戏和团队id、分数、日期)。<gydF4y2Ba/span><span class="w"></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">去<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">home_team_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">gs<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">home_team_score<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">去<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">visitor_team_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">gs<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">visitor_team_score<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="k">去<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">gs<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">在哪里<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="k">去<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="k">和<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">g<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">gs<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">game_id<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">all_ids<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">在哪里<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">all_ids<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">home_team_id<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_id<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_ids<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="w"></span><span class="k">在哪里<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">visitor_ids<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">visitor_team_id<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">t<gydF4y2Ba/span><span class="p">。<gydF4y2Ba/span><span class="n">team_id<gydF4y2Ba/span><span class="w"></span><span class="k">订单<gydF4y2Ba/span><span class="w"></span><span class="k">通过<gydF4y2Ba/span><span class="w"></span><span class="n">game_date<gydF4y2Ba/span><span class="w"></span><span class="k">desc<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>创建第二个模型:在<gydF4y2Bastrong>项目<gydF4y2Ba/strong>窗格中,单击<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夹,单击省略号,然后单击<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ zzz_win_loss_records.sql<gydF4y2Ba/span></code>并点击<gydF4y2Bastrong>创建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_win_loss_records.sql<gydF4y2Ba/span></code>文件,输入下面的SQL语句,然后单击<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。这个语句创建一个视图列出了本赛季球队输赢记录。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">创建一个视图,总结本赛季的胜利和损失记录团队。<gydF4y2Ba/span><span class="c1">——2:步骤2计算的数量为每个团队成功与失败。<gydF4y2Ba/span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">赢家<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">团队<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">数<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">赢家<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">赢了<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">——每个团队打了4场比赛。<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="mi">4<gydF4y2Ba/span><span class="w"></span><span class="o">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="k">数<gydF4y2Ba/span><span class="p">(<gydF4y2Ba/span><span class="n">赢家<gydF4y2Ba/span><span class="p">))<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">损失<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="c1">步骤1——2:确定每个游戏的赢家和输家。<gydF4y2Ba/span><span class="w"></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">game_id<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">赢家<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">情况下<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">当<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">赢家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">然后<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">游客<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">其他的<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="n">家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">结束<gydF4y2Ba/span><span class="w"></span><span class="k">作为<gydF4y2Ba/span><span class="w"></span><span class="n">失败者<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="w"></span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="k">集团<gydF4y2Ba/span><span class="w"></span><span class="k">通过<gydF4y2Ba/span><span class="w"></span><span class="n">赢家<gydF4y2Ba/span><span class="w"></span><span class="k">订单<gydF4y2Ba/span><span class="w"></span><span class="k">通过<gydF4y2Ba/span><span class="w"></span><span class="n">赢了<gydF4y2Ba/span><span class="w"></span><span class="k">desc<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>运行模式:在<gydF4y2Bastrong>运行<gydF4y2Ba/strong>盒子,运行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技术部<gydF4y2Ba/span><span class="pre">运行<gydF4y2Ba/span></code>前两个文件命令的路径。在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">默认的<gydF4y2Ba/span></code>数据库(如项目设置中指定),印度生物技术部创建一个表命名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details<gydF4y2Ba/span></code>和一个视图命名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_win_loss_records<gydF4y2Ba/span></code>。印度生物技术部得到这些相关的视图和表名<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">. sql<gydF4y2Ba/span></code>文件的名字。<gydF4y2Ba/p> <div class="highlight-bash notranslate"> <div class="highlight"> <pre><span></span>印度生物技术部/ zzz_game_details运行——模型模型。sql模型/ zzz_win_loss_records.sql<gydF4y2Ba/pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">…<gydF4y2Ba/span><span class="go">…| 1 2开始表模型default.zzz_game_details ....................(运行)<gydF4y2Ba/span><span class="go">…| 1 2创建好表模型default.zzz_game_details ...............(好吧…)<gydF4y2Ba/span><span class="go">…| 2 2开始视图模型default.zzz_win_loss_records .................(运行)<gydF4y2Ba/span><span class="go">…| 2的2好创建视图模型default.zzz_win_loss_records ............(好吧…)<gydF4y2Ba/span><span class="go">…|<gydF4y2Ba/span><span class="go">…|运行1表模型,完成1视图模型…<gydF4y2Ba/span><span class="go">成功完成<gydF4y2Ba/span><span class="go">完成了。通过= 2警告= 0 = 0跳过错误= 0 = 2<gydF4y2Ba/span></pre> </div> </div></li> <li><p>运行以下SQL代码信息新的视图和列表选择表和视图的所有行。<gydF4y2Ba/p><p>如果你连接到一个集群,您可以运行这个SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/notebooks/notebooks-manage.html"><span class="std std-ref">笔记本<gydF4y2Ba/span></a>附加到集群中,指定SQL作为默认语言的笔记本。如果你连接到SQL的仓库,你可以运行这个SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/sql/user/queries/queries.html"><span class="std std-ref">查询<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">显示<gydF4y2Ba/span><span class="w"></span><span class="n">的观点<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="k">默认的<gydF4y2Ba/span><span class="w"></span><span class="k">就像<gydF4y2Ba/span><span class="w"></span><span class="s1">“zzz_win_loss_records”<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span><span class="go">| |名称空间viewName | isTemporary |<gydF4y2Ba/span><span class="go">+ = = = = = = = = = = = + = = = = = = = = = = = = = = = = = = = = = = + = = = = = = = = = = = = = +<gydF4y2Ba/span><span class="go">| |违约zzz_win_loss_records假| |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - +<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">| | game_id |回家访客| home_score | visitor_score | | |赢家日期<gydF4y2Ba/span><span class="go">+ = = = = = = = = = + = = = = = = = = = = = = = = = + = = = = = = = = = = = = = = = + = = = = = = = = = = = = + = = = = = = = = = = = = = = = + = = = = = = = = = = = = = = = + = = = = = = = = = = = = +<gydF4y2Ba/span><span class="go">西雅图旧金山| 1 | | | 4 | 2 |旧金山| 2020-12-12 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">阿姆斯特丹旧金山| 2 | | | 0 | 1 | 2021-01-09 | |阿姆斯特丹<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">旧金山西雅图| 3 | | | 1 | 2 |旧金山| 2020-12-19 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">阿姆斯特丹西雅图| 4 | | | 3 | 2 | 2021-01-16 | |西雅图<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">旧金山阿姆斯特丹| 5 | | | 3 | 0 | 2021-01-23 | |阿姆斯特丹<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">西雅图阿姆斯特丹| 6 | | | 3 | 1 | 2021-02-06 | |阿姆斯特丹<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span></pre> </div> </div> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="o">*<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_win_loss_records<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> <div class="highlight-console notranslate"> <div class="highlight"> <pre><span></span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">| | |团队赢得|损失<gydF4y2Ba/span><span class="go">+ = = = = = = = = = = = = = = = + = = = = = = + = = = = = = = = +<gydF4y2Ba/span><span class="go">阿姆斯特丹| | 3 | 1 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">旧金山| | 2 | 2 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span><span class="go">西雅图| | 1 | 3 |<gydF4y2Ba/span><span class="go">+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +<gydF4y2Ba/span></pre> </div> </div></li> </ol> </div> <div class="section" id="step-3-create-and-run-tests"> <span id="tests"></span> <h3>步骤3:创建和运行测试<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#step-3-create-and-run-tests" title=""></a></h3> <p>在这个步骤中,您将创建<gydF4y2Baem>测试<gydF4y2Ba/em>你对模型做出的断言。当您运行这些测试,印度生物技术部告诉你如果在您的项目中每个测试通过或失败。<gydF4y2Ba/p> <p>有两种类型的测试。<gydF4y2Baem>模式测试<gydF4y2Ba/em>写在YAML,返回的记录数不通过断言。当这个数字是零,所有记录,因此测试通过。<gydF4y2Baem>数据测试<gydF4y2Ba/em>特定的查询必须返回零记录。<gydF4y2Ba/p> <ol class="arabic"> <li><p>创建模式测试:在<gydF4y2Bastrong>项目<gydF4y2Ba/strong>窗格中,单击<gydF4y2Bastrong>模型<gydF4y2Ba/strong>文件夹,单击省略号,然后单击<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">模型/ schema.yml<gydF4y2Ba/span></code>并点击<gydF4y2Bastrong>创建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">schema.yml<gydF4y2Ba/span></code>文件,输入以下内容,然后单击<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。这个文件包括模式测试,确定指定的列有独特的价值观,不是零,只有指定的值,或组合。<gydF4y2Ba/p> <div class="highlight-yaml notranslate"> <div class="highlight"> <pre><span></span><span class="nt">版本<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">2<gydF4y2Ba/span><span class="w"></span><span class="nt">模型<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">zzz_game_details<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">列<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">game_id<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">独特的<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">accepted_values<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">值<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="p p-Indicator">(<gydF4y2Ba/span><span class="s">“阿姆斯特丹”<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“圣<gydF4y2Ba/span><span class="nv"></span><span class="s">旧金山的<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“西雅图”<gydF4y2Ba/span><span class="p p-Indicator">]<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">游客<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">accepted_values<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">值<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="p p-Indicator">(<gydF4y2Ba/span><span class="s">“阿姆斯特丹”<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“圣<gydF4y2Ba/span><span class="nv"></span><span class="s">旧金山的<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“西雅图”<gydF4y2Ba/span><span class="p p-Indicator">]<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">home_score<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">赢家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">accepted_values<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">值<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="p p-Indicator">(<gydF4y2Ba/span><span class="s">“阿姆斯特丹”<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“圣<gydF4y2Ba/span><span class="nv"></span><span class="s">旧金山的<gydF4y2Ba/span><span class="p p-Indicator">,<gydF4y2Ba/span><span class="w"></span><span class="s">“西雅图”<gydF4y2Ba/span><span class="p p-Indicator">]<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">日期<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">zzz_win_loss_records<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">列<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">团队<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">独特的<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的关系<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">来<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">裁判(“zzz_game_details”)<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">场<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">家<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">赢了<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="nt">的名字<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">损失<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="nt">测试<gydF4y2Ba/span><span class="p">:<gydF4y2Ba/span><span class="w"></span><span class="w"></span><span class="p p-Indicator">- - - - - -<gydF4y2Ba/span><span class="w"></span><span class="l l-Scalar l-Scalar-Plain">not_null<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>创建第一个数据测试:在<gydF4y2Bastrong>项目<gydF4y2Ba/strong>窗格中,单击<gydF4y2Bastrong>测试<gydF4y2Ba/strong>文件夹,单击省略号,然后单击<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">测试/ zzz_game_details_check_dates.sql<gydF4y2Ba/span></code>并点击<gydF4y2Bastrong>创建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details_check_dates.sql<gydF4y2Ba/span></code>文件,输入下面的SQL语句,然后单击<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。这个文件包含一个数据测试来决定游戏是否发生以外的常规赛。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——本赛季的比赛发生在2020-12-12和2020-12-12之间。<gydF4y2Ba/span><span class="c1">对于这个测试通过,这个查询必须返回任何结果。<gydF4y2Ba/span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="w"></span><span class="k">在哪里<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="s1">“2020-12-12”<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="nb">日期<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="s1">“2021-02-06”<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>创建第二个数据测试:<gydF4y2Bastrong>项目<gydF4y2Ba/strong>窗格中,单击<gydF4y2Bastrong>测试<gydF4y2Ba/strong>文件夹,单击省略号,然后单击<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">测试/ zzz_game_details_check_scores.sql<gydF4y2Ba/span></code>并点击<gydF4y2Bastrong>创建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_game_details_check_scores.sql<gydF4y2Ba/span></code>文件,输入下面的SQL语句,然后单击<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。这个文件包含一个数据测试,以确定是否有任何分数-或任何相关的游戏。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——这项运动不允许负成绩或领带游戏。<gydF4y2Ba/span><span class="c1">对于这个测试通过,这个查询必须返回任何结果。<gydF4y2Ba/span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="w"></span><span class="k">在哪里<gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">home_score<gydF4y2Ba/span><span class="w"></span><span class="o">=<gydF4y2Ba/span><span class="w"></span><span class="n">visitor_score<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>创建第三个数据测试:在<gydF4y2Bastrong>项目<gydF4y2Ba/strong>窗格中,单击<gydF4y2Bastrong>测试<gydF4y2Ba/strong>文件夹,单击省略号,然后单击<gydF4y2Bastrong>新文件<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>输入<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">测试/ zzz_win_loss_records_check_records.sql<gydF4y2Ba/span></code>并点击<gydF4y2Bastrong>创建<gydF4y2Ba/strong>。<gydF4y2Ba/p></li> <li><p>在<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">zzz_win_loss_records_check_records.sql<gydF4y2Ba/span></code>文件,输入下面的SQL语句,然后单击<gydF4y2Bastrong>保存<gydF4y2Ba/strong>。这个文件包含一个数据测试来确定团队是否成功或失败有负面记录,有更多的成功或失败比比赛记录,或者比被允许玩更多的游戏。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">本赛季,每个团队参加了4场比赛。<gydF4y2Ba/span><span class="c1">对于这个测试通过,这个查询必须返回任何结果。<gydF4y2Ba/span><span class="k">选择<gydF4y2Ba/span><span class="w"></span><span class="n">赢了<gydF4y2Ba/span><span class="p">,<gydF4y2Ba/span><span class="w"></span><span class="n">损失<gydF4y2Ba/span><span class="w"></span><span class="k">从<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_win_loss_records<gydF4y2Ba/span><span class="w"></span><span class="k">在哪里<gydF4y2Ba/span><span class="w"></span><span class="n">赢了<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">赢了<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="mi">4<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">损失<gydF4y2Ba/span><span class="w"></span><span class="o"><<gydF4y2Ba/span><span class="w"></span><span class="mi">0<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="n">损失<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="mi">4<gydF4y2Ba/span><span class="w"></span><span class="k">或<gydF4y2Ba/span><span class="w"></span><span class="p">(<gydF4y2Ba/span><span class="n">赢了<gydF4y2Ba/span><span class="w"></span><span class="o">+<gydF4y2Ba/span><span class="w"></span><span class="n">损失<gydF4y2Ba/span><span class="p">)<gydF4y2Ba/span><span class="w"></span><span class="o">><gydF4y2Ba/span><span class="w"></span><span class="mi">4<gydF4y2Ba/span><span class="w"></span></pre> </div> </div></li> <li><p>运行测试:在<gydF4y2Bastrong>运行<gydF4y2Ba/strong>盒子,运行<gydF4y2Bacode class="docutils literal notranslate"><span class="pre">印度生物技术部<gydF4y2Ba/span><span class="pre">测试<gydF4y2Ba/span></code>命令。<gydF4y2Ba/p></li> </ol> </div> <div class="section" id="step-4-clean-up"> <span id="clean-up"></span> <h3>第四步:清理<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#step-4-clean-up" title=""></a></h3> <p>您可以删除您对于这个例子创建的表和视图通过运行以下SQL代码。<gydF4y2Ba/p> <p>如果你连接到一个集群,您可以运行这个SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/notebooks/notebooks-manage.html"><span class="std std-ref">笔记本<gydF4y2Ba/span></a>附加到集群中,指定SQL作为默认语言的笔记本。如果你连接到SQL的仓库,你可以运行这个SQL代码<gydF4y2Baa class="reference internal" href="//www.neidfyre.com/docs.gcp/sql/user/queries/queries.html"><span class="std std-ref">查询<gydF4y2Ba/span></a>。<gydF4y2Ba/p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_opponents<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_scores<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_games<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_teams<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_game_details<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">视图<gydF4y2Ba/span><span class="w"></span><span class="n">zzz_win_loss_records<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">钻石<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">表<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_four_cs<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">视图<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_list_colors<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span><span class="k">下降<gydF4y2Ba/span><span class="w"></span><span class="k">视图<gydF4y2Ba/span><span class="w"></span><span class="n">diamonds_prices<gydF4y2Ba/span><span class="p">;<gydF4y2Ba/span><span class="w"></span></pre> </div> </div> </div> </div> <div class="section" id="next-steps"> <h2>下一个步骤<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#next-steps" title=""></a></h2> <ul class="simple"> <li><p>BOB低频彩了解更多关于印度生物技术部<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/building-models">模型<gydF4y2Ba/a>。<gydF4y2Ba/p></li> <li><p>学习如何<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/tests">测试<gydF4y2Ba/a>你的印度生物技术部项目。<gydF4y2Ba/p></li> <li><p>学习如何使用<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/building-a-dbt-project/jinja-macros">金贾的<gydF4y2Ba/a>模板语言,编程SQL在印度生物技术部项目中。<gydF4y2Ba/p></li> <li><p>了解印度生物技术部<gydF4y2Baa class="reference external" href="https://docs.getdbt.com/docs/guides/best-practices">最佳实践<gydF4y2Ba/a>。<gydF4y2Ba/p></li> </ul> </div> <div class="section" id="additional-resources"> <h2>额外的资源<gydF4y2Baa class="headerlink" href="//www.neidfyre.com/docs.gcp/partners/prep/#additional-resources" title=""></a></h2> <ul class="simple"> <li><p><a class="reference external" href="https://blog.getdbt.com/what--exactly--is-dbt-/">究竟什么是印度生物技术部吗?<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/introduction">一般印度生物技术部文档<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://github.com/dbt-labs/dbt">dbt-core GitHub库<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/dbt-cli/cli-overview">印度生物技术部CLI<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://www.getdbt.com/pricing/">印度生物技术部的定价<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://blog.getdbt.com/analytics-engineering-for-everyone-databricks-in-dbt-cloud/">分析工程对所有人:砖在印度生物技术部的云<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-overview">印度生物技术部的云计算概述<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-configuring-dbt-cloud/connecting-your-database">连接到数据砖<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://discourse.getdbt.com/">印度生物技术部话语社区<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://blog.getdbt.com/">印度生物技术部的博客<gydF4y2Ba/a></p></li> <li><p><a class="reference external" href="https://docs.getdbt.com/docs/dbt-cloud/cloud-dbt-cloud-support">支持<gydF4y2Ba/a></p></li> </ul> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> </div> </div> </div> </div> <div class="suapp-rating"> <div id="suPageRateApp"> <su-app></su-app> </div> </div> <hr> <footer> <div role="contentinfo"> <p class="copyright">bob下载地址©2023砖。保留所有权利。Apache, Apache火花,火花,火花标志的商标<gydF4y2Baa href="http://www.apache.org/">Apache软件基金会<gydF4y2Ba/a>。<gydF4y2Ba/p> <p><a id="feedbacklink" href="mailto:doc-feedback@www.neidfyre.com?subject=Documentation Feedback">给我们反馈<gydF4y2Ba/a>|<gydF4y2Baa href="//www.neidfyre.com/docs.gcp/privacy-policy">隐私政策<gydF4y2Ba/a>|<gydF4y2Baa href="//www.neidfyre.com/docs.gcp/terms-of-use">使用条款<gydF4y2Ba/a></p> </div> </footer> </div> </div> </section> </main> </page>  <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet">  </body> </html>