<div class="section" id="tutorial-bulk-loading-from-a-local-file-system-using-copy">
<h1>Tutorial: Bulk Loading from a Local File System Using COPY<a class="headerlink" href="#tutorial-bulk-loading-from-a-local-file-system-using-copy" title="Permalink to this headline">¶</a></h1>

<p>This tutorial describes how to load data from files in your local file system into a table.</p>
<p>You will learn how to:</p>
<ul class="simple">
<li><p>Create named file format objects that describe your data files.</p></li>
<li><p>Create named stage objects.</p></li>
<li><p>Upload your data to the internal stages.</p></li>
<li><p>Load your data into tables.</p></li>
<li><p>Resolve errors in your data files.</p></li>
</ul>
<p>The tutorial covers loading of both CSV and JSON data.</p>
<dl class="field-list simple">
<dt class="field-odd">Interface</dt>
<dd class="field-odd"><p><a class="reference internal" href="snowsql.html"><span class="doc">SnowSQL (CLI Client)</span></a></p>
</dd>
<dt class="field-even">Est. Time</dt>
<dd class="field-even"><p>20-30 minutes</p>
</dd>
<dt class="field-odd">Est. Credits</dt>
<dd class="field-odd"><p>&lt; 1</p>
</dd>
</dl>
<p><strong>Before You Begin:</strong></p>
<div class="toctree-wrapper compound">
<ul>
<li class="toctree-l1"><a class="reference internal" href="data-load-internal-tutorial-prerequisites.html">Prerequisites</a></li>
</ul>
</div>
<p><strong>Steps:</strong></p>
<div class="toctree-wrapper compound">
<ul>
<li class="toctree-l1"><a class="reference internal" href="data-load-internal-tutorial-create-file-format.html">Step 1. Create File Format Objects</a></li>
<li class="toctree-l1"><a class="reference internal" href="data-load-internal-tutorial-create-stage.html">Step 2. Create Stage Objects</a></li>
<li class="toctree-l1"><a class="reference internal" href="data-load-internal-tutorial-stage-data-files.html">Step 3. Stage the Data Files</a></li>
<li class="toctree-l1"><a class="reference internal" href="data-load-internal-tutorial-copy-into.html">Step 4. Copy Data into the Target Tables</a></li>
<li class="toctree-l1"><a class="reference internal" href="data-load-internal-tutorial-resolve.html">Step 5. Resolve Data Load Errors</a></li>
<li class="toctree-l1"><a class="reference internal" href="data-load-internal-tutorial-remove-data-files.html">Step 6. Remove the Successfully Copied Data Files</a></li>
<li class="toctree-l1"><a class="reference internal" href="data-load-internal-tutorial-congratulations.html">Step 7. Clean Up</a></li>
</ul>
</div>
</div>




Tutorial: Bulk Loading from a Local File System Using COPY¶