
  



  
  <section id="common-setup-for-snowpark-container-services-tutorials">
<h1>Configuration commune pour les tutoriels Snowpark Container Services<a class="headerlink" href="#common-setup-for-snowpark-container-services-tutorials" title="Lien vers cette rubrique" data-nosnippet="">¶</a></h1>
<aside class="newfeat sidebar">
<p class="sidebar-title">Fonction <a class="image-small reference internal" href="../../../_images/logo-snowflake-black.png"><img alt="Logo Snowflake en noir (sans texte)" class="image-small" src="../../../_images/logo-snowflake-black.png" style="width: 15px; height: 15px;"></a> — Généralement disponible</p>
<p>Snowpark Container Services est disponible pour les comptes dans les <a class="reference internal" href="../../../user-guide/intro-regions.html#label-na-general-regions"><span class="std std-ref">régions commerciales AWS, Microsoft Azure et Google Cloud Platform</span></a>, avec quelques exceptions. Pour plus d’informations, voir <a class="reference internal" href="../overview.html#label-snowpark-containers-overview-available-regions"><span class="std std-ref">Régions disponibles et considérations</span></a>.</p>
</aside>

<section id="introduction">
<h2>Introduction<a class="headerlink" href="#introduction" title="Lien vers cette rubrique" data-nosnippet="">¶</a></h2>
<p>Cette rubrique fournit des instructions pour la configuration commune requise pour tous les tutoriels de Snowpark Container Services fournis dans cette documentation.</p>
</section>
<section id="configure-prerequisites">
<h2>Configurer les conditions préalables<a class="headerlink" href="#configure-prerequisites" title="Lien vers cette rubrique" data-nosnippet="">¶</a></h2>
<p>Passez en revue les conditions préalables suivantes pour vous assurer que vous pouvez suivre les tutoriels&nbsp;:</p>
<ul class="simple">
<li><p><strong>Un compte Snowflake&nbsp;:</strong> notez que les comptes d’essai ne sont pas pris en charge.</p></li>
<li><p><strong>SnowSQL, le client de ligne de commande pour l’exécution des commandes SQL (facultatif)&nbsp;:</strong> vous pouvez utiliser n’importe quel client Snowflake qui prend en charge l’exécution des commandes SQL et le chargement de fichiers vers une zone de préparation Snowflake. Les tutoriels sont testés en utilisant le SnowSQL et l’interface Web <a class="reference internal" href="../../../user-guide/ui-snowsight-gs.html#label-snowsight-getting-started-sign-in"><span class="std std-ref">Snowsight</span></a>. Pour savoir comment installer ce client de ligne de commande, voir <a class="reference internal" href="../../../user-guide/snowsql-install-config"><span class="doc">Installation de SnowSQL</span></a>.</p></li>
<li><p><strong>Docker Desktop&nbsp;:</strong> ces tutoriels fournissent des instructions pour l’utilisation de Docker Desktop. Pour des instructions d’installation, voir <a class="reference external" href="https://docs.docker.com/get-docker/">https://docs.docker.com/get-docker/</a>.  Notez que vous pouvez utiliser n’importe quel client compatible OCI pour créer des images, comme Docker, Podman ou Nerdctl.</p></li>
</ul>
</section>
<section id="create-snowflake-objects">
<span id="label-snowpark-containers-common-setup-create-objects"></span><h2>Créer des objets Snowflake<a class="headerlink" href="#create-snowflake-objects" title="Lien vers cette rubrique" data-nosnippet="">¶</a></h2>
<p>Exécutez le SQL fourni en utilisant soit le SnowSQL soit Snowsight.</p>
<ol class="arabic">
<li><p>Connectez-vous à Snowflake en tant qu’utilisateur ayant le rôle ACCOUNTADMIN.</p></li>
<li><p>En utilisant le rôle ACCOUNTADMIN, exécutez le script suivant, en remplaçant <code class="samp docutils literal notranslate"><em><span class="pre">user_name</span></em></code> par le nom de votre utilisateur Snowflake qui testera les tutoriels. Pour ces tutoriels, vous pouvez choisir le même utilisateur que celui qui exécute ce script ou un autre utilisateur de votre compte Snowflake. Le script fait ce qui suit&nbsp;:</p>
<ul class="simple">
<li><p>Crée un rôle (<code class="docutils literal notranslate"><span class="pre">test_role</span></code>) et d’autres objets Snowflake. Pour créer le rôle et les objets, vous devez utiliser le rôle ACCOUNTADMIN. (Cette restriction permet de contrôler les coûts et de gérer les risques liés aux informations commerciales). Le script accorde également au rôle <code class="docutils literal notranslate"><span class="pre">test_role</span></code> les privilèges nécessaires pour gérer les objets nouvellement créés.</p></li>
<li><p>Attribue le rôle à l’utilisateur Snowflake spécifié, qui l’utilise ensuite pour explorer les tutoriels.</p></li>
</ul>
<div class="relative group text-sm"><div class="highlight-sqlexample notranslate"><div class="highlight"><pre><span></span><span class="ni">USE</span> <span class="ni">ROLE</span> <span class="ni">ACCOUNTADMIN</span><span class="p">;</span>

<span class="ni">CREATE</span> <span class="ni">ROLE</span> <span class="gi">test_role</span><span class="p">;</span>

<span class="ni">CREATE</span> <span class="ni">DATABASE</span> <span class="ni">IF</span> <span class="ni">NOT</span> <span class="ni">EXISTS</span> <span class="gi">tutorial_db</span><span class="p">;</span>
<span class="ni">GRANT</span> <span class="ni">OWNERSHIP</span> <span class="ni">ON</span> <span class="ni">DATABASE</span> <span class="gi">tutorial_db</span> <span class="ni">TO</span> <span class="ni">ROLE</span> <span class="gi">test_role</span> <span class="ni">COPY</span> <span class="ni">CURRENT</span> <span class="ni">GRANTS</span><span class="p">;</span>

<span class="ni">CREATE</span> <span class="ni">OR</span> <span class="ni">REPLACE</span> <span class="ni">WAREHOUSE</span> <span class="gi">tutorial_warehouse</span> <span class="ni">WITH</span>
  <span class="ni">WAREHOUSE_SIZE</span><span class="p">=</span><span class="nc">'X-SMALL'</span><span class="p">;</span>
<span class="ni">GRANT</span> <span class="ni">USAGE</span> <span class="ni">ON</span> <span class="ni">WAREHOUSE</span> <span class="gi">tutorial_warehouse</span> <span class="ni">TO</span> <span class="ni">ROLE</span> <span class="gi">test_role</span><span class="p">;</span>

<span class="ni">GRANT</span> <span class="ni">BIND SERVICE ENDPOINT</span> <span class="ni">ON</span> <span class="ni">ACCOUNT</span> <span class="ni">TO</span> <span class="ni">ROLE</span> <span class="gi">test_role</span><span class="p">;</span>

<span class="ni">CREATE</span> <span class="ni">COMPUTE POOL</span> <span class="gi">tutorial_compute_pool</span>
  <span class="ni">MIN_NODES</span> <span class="p">=</span> <span class="nf">1</span>
  <span class="ni">MAX_NODES</span> <span class="p">=</span> <span class="nf">1</span>
  <span class="ni">INSTANCE_FAMILY</span> <span class="p">=</span> <span class="gi">CPU_X64_XS</span><span class="p">;</span>
<span class="ni">GRANT</span> <span class="ni">USAGE</span><span class="p">,</span> <span class="ni">MONITOR</span> <span class="ni">ON</span> <span class="ni">COMPUTE POOL</span> <span class="gi">tutorial_compute_pool</span> <span class="ni">TO</span> <span class="ni">ROLE</span> <span class="gi">test_role</span><span class="p">;</span>

<span class="ni">GRANT</span> <span class="ni">ROLE</span> <span class="gi">test_role</span> <span class="ni">TO</span> <span class="ni">USER</span> <span class="p">&lt;</span><span class="ni">user_name</span><span class="p">&gt;</span>
</pre></div>
</div><div data-codeblock-index="0" class="copybutton"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 384 512" class="copybutton-icon icon-copy"><path d="M192 0c-41.8 0-77.4 26.7-90.5 64H64C28.7 64 0 92.7 0 128V448c0 35.3 28.7 64 64 64H320c35.3 0 64-28.7 64-64V128c0-35.3-28.7-64-64-64H282.5C269.4 26.7 233.8 0 192 0zm0 64a32 32 0 1 1 0 64 32 32 0 1 1 0-64zM112 192H272c8.8 0 16 7.2 16 16s-7.2 16-16 16H112c-8.8 0-16-7.2-16-16s7.2-16 16-16z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" class="copybutton-icon icon-copied hidden"><path d="M470.6 105.4c12.5 12.5 12.5 32.8 0 45.3l-256 256c-12.5 12.5-32.8 12.5-45.3 0l-128-128c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0L192 338.7 425.4 105.4c12.5-12.5 32.8-12.5 45.3 0z"></path></svg><span>Copy</span></div></div>
<p>Remarques importantes&nbsp;:</p>
<ul class="simple">
<li><p>Vous créez un entrepôt parce que les services (y compris les services de tâches) peuvent exécuter des instructions DML SQL (telles que SELECT et INSERT). Snowflake exécute ces instructions dans l’entrepôt.</p></li>
<li><p>Dans le tutoriel&nbsp;1, vous créez un service qui expose un point de terminaison en tant que public pour permettre aux utilisateurs d’accéder au service à partir du Web public (entrée). Pour créer ce service&nbsp;:</p>
<ul>
<li><p>Le rôle <code class="code docutils literal notranslate"><span class="pre">test_role</span></code> doit avoir le privilège BIND SERVICE ENDPOINT sur le compte.</p></li>
<li><p>La mise en œuvre actuelle nécessite une intégration de sécurité, que le script crée.</p></li>
</ul>
</li>
<li><p>Un <a class="reference internal" href="../working-with-compute-pool"><span class="doc">pool de calcul</span></a> est un ensemble d’un ou plusieurs nœuds de machines virtuelles (VM) sur lesquels Snowflake exécute vos services.</p></li>
</ul>
</li>
<li><p>Assurez-vous d’être connecté à Snowflake en tant qu’utilisateur spécifié dans le script précédent.</p></li>
<li><p>En utilisant le rôle <code class="code docutils literal notranslate"><span class="pre">test_role</span></code> , exécutez le script suivant pour créer des objets de base de données communs à tous les tutoriels.</p>
<div class="relative group text-sm"><div class="highlight-sqlexample notranslate"><div class="highlight"><pre><span></span><span class="ni">USE</span> <span class="ni">ROLE</span> <span class="gi">test_role</span><span class="p">;</span>
<span class="ni">USE</span> <span class="ni">DATABASE</span> <span class="gi">tutorial_db</span><span class="p">;</span>
<span class="ni">USE</span> <span class="ni">WAREHOUSE</span> <span class="gi">tutorial_warehouse</span><span class="p">;</span>

<span class="ni">CREATE</span> <span class="ni">SCHEMA</span> <span class="ni">IF</span> <span class="ni">NOT</span> <span class="ni">EXISTS</span> <span class="gi">data_schema</span><span class="p">;</span>
<span class="ni">CREATE</span> <span class="ni">IMAGE REPOSITORY</span> <span class="ni">IF</span> <span class="ni">NOT</span> <span class="ni">EXISTS</span> <span class="gi">tutorial_repository</span><span class="p">;</span>
<span class="ni">CREATE</span> <span class="ni">STAGE</span> <span class="ni">IF</span> <span class="ni">NOT</span> <span class="ni">EXISTS</span> <span class="gi">tutorial_stage</span>
  <span class="ni">DIRECTORY</span> <span class="p">=</span> <span class="p">(</span> <span class="ni">ENABLE</span> <span class="p">=</span> <span class="ni">true</span> <span class="p">);</span>
</pre></div>
</div><div data-codeblock-index="1" class="copybutton"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 384 512" class="copybutton-icon icon-copy"><path d="M192 0c-41.8 0-77.4 26.7-90.5 64H64C28.7 64 0 92.7 0 128V448c0 35.3 28.7 64 64 64H320c35.3 0 64-28.7 64-64V128c0-35.3-28.7-64-64-64H282.5C269.4 26.7 233.8 0 192 0zm0 64a32 32 0 1 1 0 64 32 32 0 1 1 0-64zM112 192H272c8.8 0 16 7.2 16 16s-7.2 16-16 16H112c-8.8 0-16-7.2-16-16s7.2-16 16-16z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" class="copybutton-icon icon-copied hidden"><path d="M470.6 105.4c12.5 12.5 12.5 32.8 0 45.3l-256 256c-12.5 12.5-32.8 12.5-45.3 0l-128-128c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0L192 338.7 425.4 105.4c12.5-12.5 32.8-12.5 45.3 0z"></path></svg><span>Copy</span></div></div>
<p>Remarques importantes&nbsp;:</p>
<ul class="simple">
<li><p>Vous créez un référentiel d’images pour stocker votre code de service (images du conteneur).</p></li>
<li><p>Vous créez une zone de préparation Snowflake pour stocker vos fichiers de spécification de service dans les tutoriels&nbsp;2 et&nbsp;3.</p></li>
</ul>
</li>
</ol>
</section>
<section id="verify-that-you-are-ready-to-continue">
<span id="label-snowpark-containers-common-setup-verify-ready"></span><h2>Vérifiez que vous êtes prêt à continuer<a class="headerlink" href="#verify-that-you-are-ready-to-continue" title="Lien vers cette rubrique" data-nosnippet="">¶</a></h2>
<ol class="arabic">
<li><p>Pour vérifier que vous disposez des objets nécessaires aux tutoriels, exécutez les commandes suivantes&nbsp;:</p>
<div class="relative group text-sm"><div class="highlight-sqlexample notranslate"><div class="highlight"><pre><span></span><span class="ni">SHOW</span> <span class="ni">COMPUTE</span> <span class="ni">POOLS</span><span class="p">;</span> <span class="py">--or DESCRIBE COMPUTE POOL tutorial_compute_pool;</span>
</pre></div>
</div><div data-codeblock-index="2" class="copybutton"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 384 512" class="copybutton-icon icon-copy"><path d="M192 0c-41.8 0-77.4 26.7-90.5 64H64C28.7 64 0 92.7 0 128V448c0 35.3 28.7 64 64 64H320c35.3 0 64-28.7 64-64V128c0-35.3-28.7-64-64-64H282.5C269.4 26.7 233.8 0 192 0zm0 64a32 32 0 1 1 0 64 32 32 0 1 1 0-64zM112 192H272c8.8 0 16 7.2 16 16s-7.2 16-16 16H112c-8.8 0-16-7.2-16-16s7.2-16 16-16z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" class="copybutton-icon icon-copied hidden"><path d="M470.6 105.4c12.5 12.5 12.5 32.8 0 45.3l-256 256c-12.5 12.5-32.8 12.5-45.3 0l-128-128c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0L192 338.7 425.4 105.4c12.5-12.5 32.8-12.5 45.3 0z"></path></svg><span>Copy</span></div></div>
<div class="relative group text-sm"><div class="highlight-sqlexample notranslate"><div class="highlight"><pre><span></span><span class="ni">SHOW WAREHOUSES</span><span class="p">;</span>
</pre></div>
</div><div data-codeblock-index="3" class="copybutton"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 384 512" class="copybutton-icon icon-copy"><path d="M192 0c-41.8 0-77.4 26.7-90.5 64H64C28.7 64 0 92.7 0 128V448c0 35.3 28.7 64 64 64H320c35.3 0 64-28.7 64-64V128c0-35.3-28.7-64-64-64H282.5C269.4 26.7 233.8 0 192 0zm0 64a32 32 0 1 1 0 64 32 32 0 1 1 0-64zM112 192H272c8.8 0 16 7.2 16 16s-7.2 16-16 16H112c-8.8 0-16-7.2-16-16s7.2-16 16-16z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" class="copybutton-icon icon-copied hidden"><path d="M470.6 105.4c12.5 12.5 12.5 32.8 0 45.3l-256 256c-12.5 12.5-32.8 12.5-45.3 0l-128-128c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0L192 338.7 425.4 105.4c12.5-12.5 32.8-12.5 45.3 0z"></path></svg><span>Copy</span></div></div>
<div class="relative group text-sm"><div class="highlight-sqlexample notranslate"><div class="highlight"><pre><span></span><span class="ni">SHOW</span> <span class="ni">IMAGE REPOSITORIES</span><span class="p">;</span>
</pre></div>
</div><div data-codeblock-index="4" class="copybutton"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 384 512" class="copybutton-icon icon-copy"><path d="M192 0c-41.8 0-77.4 26.7-90.5 64H64C28.7 64 0 92.7 0 128V448c0 35.3 28.7 64 64 64H320c35.3 0 64-28.7 64-64V128c0-35.3-28.7-64-64-64H282.5C269.4 26.7 233.8 0 192 0zm0 64a32 32 0 1 1 0 64 32 32 0 1 1 0-64zM112 192H272c8.8 0 16 7.2 16 16s-7.2 16-16 16H112c-8.8 0-16-7.2-16-16s7.2-16 16-16z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" class="copybutton-icon icon-copied hidden"><path d="M470.6 105.4c12.5 12.5 12.5 32.8 0 45.3l-256 256c-12.5 12.5-32.8 12.5-45.3 0l-128-128c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0L192 338.7 425.4 105.4c12.5-12.5 32.8-12.5 45.3 0z"></path></svg><span>Copy</span></div></div>
<div class="relative group text-sm"><div class="highlight-sqlexample notranslate"><div class="highlight"><pre><span></span><span class="ni">SHOW</span> <span class="ni">STAGES</span><span class="p">;</span>
</pre></div>
</div><div data-codeblock-index="5" class="copybutton"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 384 512" class="copybutton-icon icon-copy"><path d="M192 0c-41.8 0-77.4 26.7-90.5 64H64C28.7 64 0 92.7 0 128V448c0 35.3 28.7 64 64 64H320c35.3 0 64-28.7 64-64V128c0-35.3-28.7-64-64-64H282.5C269.4 26.7 233.8 0 192 0zm0 64a32 32 0 1 1 0 64 32 32 0 1 1 0-64zM112 192H272c8.8 0 16 7.2 16 16s-7.2 16-16 16H112c-8.8 0-16-7.2-16-16s7.2-16 16-16z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" class="copybutton-icon icon-copied hidden"><path d="M470.6 105.4c12.5 12.5 12.5 32.8 0 45.3l-256 256c-12.5 12.5-32.8 12.5-45.3 0l-128-128c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0L192 338.7 425.4 105.4c12.5-12.5 32.8-12.5 45.3 0z"></path></svg><span>Copy</span></div></div>
</li>
<li><p>Pour vérifier que vous disposez des informations relatives au compte (noms de l’organisation et du compte), utilisez l’une des méthodes suivantes&nbsp;:</p>
<ul>
<li><p>Vous trouverez ces informations sur l’interface Web de Snowsight, dans le coin inférieur gauche de la page d’accueil.</p></li>
<li><p>Dans la CLI SnowSQL, exécutez SHOW IMAGE REPOSITORIES. La commande renvoie l’URL du référentiel, incluant les noms de l’organisation et du compte.</p>
<p><strong>Exemple</strong></p>
<div class="relative group text-sm"><div class="highlight-sqlexample notranslate"><div class="highlight"><pre><span></span><span class="p">&lt;</span><span class="gi">orgname</span><span class="p">&gt;-&lt;</span><span class="gi">acctname</span><span class="p">&gt;.</span><span class="gi">registry</span><span class="p">.</span><span class="gi">snowflakecomputing</span><span class="p">.</span><span class="gi">com</span><span class="p">/</span><span class="gi">tutorial_db</span><span class="p">/</span><span class="gi">data_schema</span><span class="p">/</span><span class="gi">tutorial_repository</span>
</pre></div>
</div><div data-codeblock-index="6" class="copybutton"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 384 512" class="copybutton-icon icon-copy"><path d="M192 0c-41.8 0-77.4 26.7-90.5 64H64C28.7 64 0 92.7 0 128V448c0 35.3 28.7 64 64 64H320c35.3 0 64-28.7 64-64V128c0-35.3-28.7-64-64-64H282.5C269.4 26.7 233.8 0 192 0zm0 64a32 32 0 1 1 0 64 32 32 0 1 1 0-64zM112 192H272c8.8 0 16 7.2 16 16s-7.2 16-16 16H112c-8.8 0-16-7.2-16-16s7.2-16 16-16z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" class="copybutton-icon icon-copied hidden"><path d="M470.6 105.4c12.5 12.5 12.5 32.8 0 45.3l-256 256c-12.5 12.5-32.8 12.5-45.3 0l-128-128c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0L192 338.7 425.4 105.4c12.5-12.5 32.8-12.5 45.3 0z"></path></svg><span>Copy</span></div></div>
</li>
</ul>
</li>
</ol>
<section id="what-s-next">
<span id="label-snowpark-containers-tutorials-common-setup-what-next"></span><h3>Quelle est la prochaine étape&nbsp;?<a class="headerlink" href="#what-s-next" title="Lien vers cette rubrique" data-nosnippet="">¶</a></h3>
<p>Vous pouvez maintenant explorer le <a class="reference internal" href="tutorial-1"><span class="doc">tutoriel&nbsp;1</span></a>.</p>
</section>
</section>
</section>
<script type="application/json" id="metadata">{
    "categories": "App Development",
    "duration": "20",
    "summary": "This tutorial provides instructions for the common setup required for all Snowpark Container Services tutorials."
}</script>



This tutorial provides instructions for the common setup required for all Snowpark Container Services tutorials.