


  
  <section id="metadata-functions">
<h1>Metadata functions<a class="headerlink" href="#metadata-functions" title="Link to this heading" data-nosnippet="">¶</a></h1>
<p>Snowflake provides functions that return metadata information, such as descriptions of the statements used to create database
objects (e.g. tables).</p>
<table class="docutils align-default">
<colgroup>
<col style="width: 29.4%">
<col style="width: 70.6%">
</colgroup>
<thead>
<tr class="row-odd"><th class="head"><p>Function&nbsp;Name</p></th>
<th class="head"><p>Notes</p></th>
</tr>
</thead>
<tbody>
<tr class="row-even"><td><p><a class="reference internal" href="functions/generate_column_description"><span class="doc">GENERATE_COLUMN_DESCRIPTION</span></a></p></td>
<td><p>Generate a list of columns from a set of staged files that contain <a class="reference internal" href="../user-guide/semistructured-intro"><span class="doc">semi-structured data</span></a>.</p></td>
</tr>
<tr class="row-odd"><td><p><a class="reference internal" href="functions/get_ddl"><span class="doc">GET_DDL</span></a></p></td>
<td><p>Get DDL to [re-]create a database object.</p></td>
</tr>
</tbody>
</table>
</section>




Function Name	Notes
GENERATE_COLUMN_DESCRIPTION	Generate a list of columns from a set of staged files that contain semi-structured data.
GET_DDL	Get DDL to [re-]create a database object.

Metadata functions¶