> ## Documentation Index
> Fetch the complete documentation index at: https://docs.maia.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Cloud Storage Load

export const ComponentMetadata = ({warehouses, unsupportedWarehouses = [], componentType, connectionInputs, connectionOutputs}) => {
  const allWarehouses = [...warehouses.map(w => ({
    name: w,
    supported: true
  })), ...unsupportedWarehouses.map(w => ({
    name: w,
    supported: false
  }))];
  return <div style={{
    background: 'var(--colors-background-light, #f9fafb)',
    border: '1px solid var(--colors-border-default, #e5e7eb)',
    borderRadius: '12px',
    padding: '20px 28px',
    marginBottom: '28px',
    boxShadow: '0 1px 4px rgba(0,0,0,0.10)'
  }}>
      <table style={{
    width: '100%',
    borderCollapse: 'collapse'
  }}>
        <tbody>
          <tr>
            <td style={{
    fontWeight: '600',
    paddingRight: '32px',
    paddingBottom: '14px',
    whiteSpace: 'nowrap',
    verticalAlign: 'middle',
    width: '180px'
  }}>Project Availability</td>
            <td style={{
    paddingBottom: '14px',
    verticalAlign: 'middle'
  }}>
              <div style={{
    display: 'flex',
    flexWrap: 'wrap',
    gap: '8px'
  }}>
                {allWarehouses.map((w, i) => <span key={i} style={{
    background: w.supported ? '#dcfce7' : '#fee2e2',
    color: w.supported ? '#15803d' : '#b91c1c',
    border: `1px solid ${w.supported ? '#bbf7d0' : '#fca5a5'}`,
    borderRadius: '9999px',
    padding: '3px 12px',
    fontSize: '0.85rem',
    fontWeight: '500',
    whiteSpace: 'nowrap'
  }}>
                    {w.name} {w.supported ? '✅' : '❌'}
                  </span>)}
              </div>
            </td>
          </tr>
          <tr>
            <td style={{
    fontWeight: '600',
    paddingRight: '32px',
    paddingBottom: '14px',
    whiteSpace: 'nowrap',
    verticalAlign: 'middle'
  }}>Component Type</td>
            <td style={{
    paddingBottom: '14px',
    verticalAlign: 'middle'
  }}>{componentType}</td>
          </tr>
          <tr>
            <td style={{
    fontWeight: '600',
    paddingRight: '32px',
    paddingBottom: '14px',
    whiteSpace: 'nowrap',
    verticalAlign: 'middle'
  }}>Connection Inputs</td>
            <td style={{
    paddingBottom: '14px',
    verticalAlign: 'middle'
  }}>{connectionInputs}</td>
          </tr>
          <tr>
            <td style={{
    fontWeight: '600',
    paddingRight: '32px',
    whiteSpace: 'nowrap',
    verticalAlign: 'middle'
  }}>Connection Outputs</td>
            <td style={{
    verticalAlign: 'middle'
  }}>{connectionOutputs}</td>
          </tr>
        </tbody>
      </table>
    </div>;
};

<ComponentMetadata warehouses={["Snowflake"]} unsupportedWarehouses={["Databricks", "Amazon Redshift", "Google BigQuery"]} componentType="Connector, Orchestration" connectionInputs="One" connectionOutputs="Unlimited" />

The Google Cloud Storage Load orchestration component lets users load data stored on the Google Cloud Storage service into an existing Snowflake table.

This component requires working Google Cloud Storage credentials with "read" access to the source data files.

If the component requires access to a cloud provider (AWS, Azure, or Google Cloud), it will use the [cloud credentials](/docs/guides/cloud-credentials) associated with your environment to access resources.

***

## Properties

<ResponseField name="Name" type="string" required>
  A human-readable name for the component.
</ResponseField>

{/* <!-- param-start:[stage] | warehouses: [snowflake] --> */}

<ResponseField name="Stage" type="drop-down" required>
  Select a staging area for the data. Staging areas can be created through Snowflake using the [CREATE STAGE](https://docs.snowflake.com/en/sql-reference/sql/create-stage.html) command. Internal stages can be set up this way to store staged data within Snowflake. Selecting \[Custom] will allow the user to specify a custom staging area.
</ResponseField>

{/* <!-- param-start:[storageIntegration] | warehouses: [snowflake] --> */}

<ResponseField name="Storage Integration" type="drop-down" required>
  Select the storage integration. Storage integrations are required to permit Snowflake to read from and write to a cloud storage location. Integrations must be set up in advance and configured to support Google Cloud Storage.
</ResponseField>

{/* <!-- param-start:[googleStorageURLLocation] | warehouses: [snowflake] --> */}

<ResponseField name="Google Storage URL Location" type="file explorer" required>
  To retrieve the intended files, use the file explorer to enter the container path where the Google Cloud Storage bucket is located, or select from the list of GCS buckets.

  This must have the format `GS://<bucket>/<path>`.
</ResponseField>

{/* <!-- param-start:[pattern] | warehouses: [snowflake] --> */}

<ResponseField name="Pattern" type="string" required>
  A regular expression pattern string that specifies the file names and/or paths to match. For more information on pattern matching, read the [Snowflake documentation](https://docs.snowflake.com/en/user-guide/data-load-gcs-copy.html).
</ResponseField>

{/* <!-- param-start:[warehouse] | warehouses: [snowflake] --> */}

<ResponseField name="Warehouse" type="drop-down" required>
  The Snowflake warehouse used to run the queries. The special value `[Environment Default]` uses the warehouse defined in the environment. Read [Overview of Warehouses](https://docs.snowflake.com/en/user-guide/warehouses-overview.html) to learn more.
</ResponseField>

{/* <!-- param-start:[database] | warehouses: [snowflake] --> */}

<ResponseField name="Database" type="drop-down" required>
  The Snowflake database. The special value `[Environment Default]` uses the database defined in the environment. Read [Databases, Tables and Views - Overview](https://docs.snowflake.com/en/guides-overview-db) to learn more.
</ResponseField>

{/* <!-- param-start:[schema] | warehouses: [snowflake] --> */}

<ResponseField name="Schema" type="drop-down" required>
  The Snowflake schema. The special value `[Environment Default]` uses the schema defined in the environment. Read [Database, Schema, and Share DDL](https://docs.snowflake.com/en/sql-reference/ddl-database.html) to learn more.
</ResponseField>

{/* <!-- param-start:[targetTable] | warehouses: [snowflake] --> */}

<ResponseField name="Target Table" type="string" required>
  Select an existing table to load data into. The tables available for selection depend on the chosen schema.
</ResponseField>

{/* <!-- param-start:[loadColumns] | warehouses: [snowflake] --> */}

<ResponseField name="Load Columns" type="dual listbox" required>
  Choose the columns to load. If you leave this parameter empty, all columns will be loaded.
</ResponseField>

{/* <!-- param-start:[format] | warehouses: [snowflake] --> */}

<ResponseField name="Format" type="drop-down" required>
  Select a pre-made file format that will automatically set many of the Google Cloud Storage Load component properties. These formats can be created through the [Create File Format](/docs/components/create-file-format) component. Select \[Custom] to specify a custom format using the properties available in this component.
</ResponseField>

{/* <!-- param-start:[fileType] | warehouses: [snowflake] --> */}

<ResponseField name="File Type" type="drop-down" required>
  Select the type of data to load. Available data types are: AVRO, CSV, JSON, ORC, PARQUET, and XML. For additional information on file type options, read the [Snowflake documentation](https://docs.snowflake.net/manuals/sql-reference/sql/create-file-format.html).

  Component properties will change to reflect the selected file type. Click one of the tabs below for properties applicable to that file type.
</ResponseField>

<Tabs>
  <Tab title="AVRO">
    {/* <!-- param-start:[compression] | warehouses: [snowflake] --> */}

    <ResponseField name="Compression" type="drop-down" required>
      Select the compression method if you wish to compress your data. If you do not wish to compress at all, select NONE. The default setting is AUTO.
    </ResponseField>

    {/* <!-- param-end:[compression] --> */}

    {/* <!-- param-start:[trimSpace] | warehouses: [snowflake] --> */}

    <ResponseField name="Trim Space" type="boolean" required>
      When **Yes**, removes whitespace from fields. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[trimSpace] --> */}

    {/* <!-- param-start:[nullIf] | warehouses: [snowflake] --> */}

    <ResponseField name="Null If" type="editor" required>
      Specify one or more strings (one string per row in the dialog) to convert to NULL values. When one of these strings is encountered in the file, it is replaced with an SQL NULL value for that field in the loaded table. Click **+** to add a string.
    </ResponseField>

    {/* <!-- param-end:[nullIf] --> */}
  </Tab>

  <Tab title="CSV">
    {/* <!-- param-start:[compression] | warehouses: [snowflake] --> */}

    <ResponseField name="Compression" type="drop-down" required>
      Select the compression method if you wish to compress your data. If you do not wish to compress at all, select NONE. The default setting is AUTO.
    </ResponseField>

    {/* <!-- param-end:[compression] --> */}

    {/* <!-- param-start:[recordDelimiter] | warehouses: [snowflake] --> */}

    <ResponseField name="Record Delimiter" type="string" required>
      Input a delimiter for records. This can be one or more single-byte or multibyte characters that separate records in an input file.

      Accepted values include: leaving the field empty; a newline character `\` or its hex equivalent `0x0a`; a carriage return `\\r` or its hex equivalent `0x0d`. Also accepts a value of NONE.

      If you set the **Skip Header** property to a value such as 1, then you should use a record delimiter that includes a line feed or carriage return, such as `\` or `\\r`. Otherwise, your entire file will be interpreted as the header row, and no data will be loaded.

      The specified delimiter must be a valid UTF-8 character and not a random sequence of bytes.

      Do not specify characters used for other file type options such as **Escape** or **Escape Unenclosed Field**.

      If the field is left blank, the default record delimiter is a newline character.
    </ResponseField>

    {/* <!-- param-end:[recordDelimiter] --> */}

    {/* <!-- param-start:[fieldDelimiter] | warehouses: [snowflake] --> */}

    <ResponseField name="Field Delimiter" type="string" required>
      Input a delimiter for fields. This can be one or more single-byte or multibyte characters that separate fields in an input file.

      Accepted characters include common escape sequences, octal values (prefixed by \\), or hex values (prefixed by 0x). Also accepts a value of NONE.

      This delimiter is limited to a maximum of 20 characters.

      While multi-character delimiters are supported, the field delimiter cannot be a substring of the record delimiter, and vice versa. For example, if the field delimiter is "aa", the record delimiter cannot be "aabb".

      The specified delimiter must be a valid UTF-8 character and not a random sequence of bytes.

      Do not specify characters used for other file type options such as **Escape** or **Escape Unenclosed Field**.

      The Default setting is a comma: `,`.
    </ResponseField>

    {/* <!-- param-end:[fieldDelimiter] --> */}

    {/* <!-- param-start:[skipHeader] | warehouses: [snowflake] --> */}

    <ResponseField name="Skip Header" type="integer" required>
      Specify the number of rows to skip. The default is 0.

      If **Skip Header** is used, the value of the record delimiter will not be used to determine where the header line is. Instead, the specified number of CRLF will be skipped. For example, if the value of **Skip Header** = 1, skips to the first CRLF that it finds. If you have set the **Field Delimiter** property to be a single character without a CRLF, then skips to the end of the file (treating the entire file as a header).
    </ResponseField>

    {/* <!-- param-end:[skipHeader] --> */}

    {/* <!-- param-start:[skipBlankLines] | warehouses: [snowflake] --> */}

    <ResponseField name="Skip Blank Lines" type="boolean" required>
      When **Yes**, ignores blank lines that only contain a line feed in a data file and does not try to load them. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[skipBlankLines] --> */}

    {/* <!-- param-start:[dateFormat] | warehouses: [snowflake] --> */}

    <ResponseField name="Date Format" type="string" required>
      Define the format of date values in the data files to be loaded. If a value is not specified or is AUTO, the value for the DATE\_INPUT\_FORMAT session parameter is used. The default setting is AUTO.
    </ResponseField>

    {/* <!-- param-end:[dateFormat] --> */}

    {/* <!-- param-start:[timeFormat] | warehouses: [snowflake] --> */}

    <ResponseField name="Time Format" type="string" required>
      Define the format of time values in the data files to be loaded. If a value is not specified or is AUTO, the value for the TIME\_INPUT\_FORMAT session parameter is used. The default setting is AUTO.
    </ResponseField>

    {/* <!-- param-end:[timeFormat] --> */}

    {/* <!-- param-start:[timestampFormat] | warehouses: [snowflake] --> */}

    <ResponseField name="Timestamp Format" type="string" required>
      Define the format of timestamp values in the data files to be loaded. If a value is not specified or is AUTO, the value for the TIMESTAMP\_INPUT\_FORMAT session parameter is used.
    </ResponseField>

    {/* <!-- param-end:[timestampFormat] --> */}

    {/* <!-- param-start:[escape] | warehouses: [snowflake] --> */}

    <ResponseField name="Escape" type="string" required>
      Specify a single character to be used as the escape character for field values that are enclosed. Default is NONE.
    </ResponseField>

    {/* <!-- param-end:[escape] --> */}

    {/* <!-- param-start:[escapeUnenclosedField] | warehouses: [snowflake] --> */}

    <ResponseField name="Escape Unenclosed Field" type="string" required>
      Specify a single character to be used as the escape character for unenclosed field values only. Default is `\\`. If you have set a value in the property **Field Optionally Enclosed**, all fields will become enclosed, rendering the **Escape Unenclosed Field** property redundant, in which case, it will be ignored.
    </ResponseField>

    {/* <!-- param-end:[escapeUnenclosedField] --> */}

    {/* <!-- param-start:[trimSpace] | warehouses: [snowflake] --> */}

    <ResponseField name="Trim Space" type="boolean" required>
      When **Yes**, removes whitespace from fields. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[trimSpace] --> */}

    {/* <!-- param-start:[fieldOptionallyEnclosed] | warehouses: [snowflake] --> */}

    <ResponseField name="Field Optionally Enclosed" type="string" required>
      Specify a character used to enclose strings. The value can be NONE, single quote character `'`, or double quote character `"`. To use the single quote character, use the octal or hex representation `0x27` or the double single-quoted escape `''`. Default is NONE.

      When a field contains one of these characters, escape the field using the same character. For example, to escape a string like this: `1 "2" 3`, use double quotation to escape, like this: `1 ""2"" 3`.
    </ResponseField>

    {/* <!-- param-end:[fieldOptionallyEnclosed] --> */}

    {/* <!-- param-start:[nullIf] | warehouses: [snowflake] --> */}

    <ResponseField name="Null If" type="editor" required>
      Specify one or more strings (one string per row in the dialog) to convert to NULL values. When one of these strings is encountered in the file, it is replaced with an SQL NULL value for that field in the loaded table. Click **+** to add a string.
    </ResponseField>

    {/* <!-- param-end:[nullIf] --> */}

    {/* <!-- param-start:[errorOnColumnCountMismatch] | warehouses: [snowflake] --> */}

    <ResponseField name="Error On Column Count Mismatch" type="boolean" required>
      When **Yes**, generates an error if the number of delimited columns in an input file does not match the number of columns in the corresponding table. When **No** (default), an error is not generated and the load continues. If the file is successfully loaded in this case:

      * Where the input file contains records with more fields than columns in the table, the matching fields are loaded in order of occurrence in the file, and the remaining fields are not loaded.
      * Where the input file contains records with fewer fields than columns in the table, the non-matching columns in the table are loaded with NULL values.
    </ResponseField>

    {/* <!-- param-end:[errorOnColumnCountMismatch] --> */}

    {/* <!-- param-start:[emptyFieldAsNull] | warehouses: [snowflake] --> */}

    <ResponseField name="Empty Field As Null" type="boolean" required>
      When **Yes**, inserts NULL values for empty fields in an input file. This is the default setting.
    </ResponseField>

    {/* <!-- param-end:[emptyFieldAsNull] --> */}

    {/* <!-- param-start:[replaceInvalidCharacters] | warehouses: [snowflake] --> */}

    <ResponseField name="Replace Invalid Characters" type="boolean" required>
      Snowflake replaces invalid UTF-8 characters with the Unicode replacement character. When False (default), the load operation produces an error when invalid UTF-8 character encoding is detected.
    </ResponseField>

    {/* <!-- param-end:[replaceInvalidCharacters] --> */}

    {/* <!-- param-start:[encodingType] | warehouses: [snowflake] --> */}

    <ResponseField name="Encoding Type" type="drop-down" required>
      Select the string that specifies the character set of the source data when loading data into a table. Refer to the Snowflake documentation for more information.
    </ResponseField>

    {/* <!-- param-end:[encodingType] --> */}
  </Tab>

  <Tab title="JSON">
    {/* <!-- param-start:[compression] | warehouses: [snowflake] --> */}

    <ResponseField name="Compression" type="drop-down" required>
      Select the compression method if you wish to compress your data. If you do not wish to compress at all, select NONE. The default setting is AUTO.
    </ResponseField>

    {/* <!-- param-end:[compression] --> */}

    {/* <!-- param-start:[trimSpace] | warehouses: [snowflake] --> */}

    <ResponseField name="Trim Space" type="boolean" required>
      When **Yes**, removes whitespace from fields. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[trimSpace] --> */}

    {/* <!-- param-start:[nullIf] | warehouses: [snowflake] --> */}

    <ResponseField name="Null If" type="editor" required>
      Specify one or more strings (one string per row in the dialog) to convert to NULL values. When one of these strings is encountered in the file, it is replaced with an SQL NULL value for that field in the loaded table. Click **+** to add a string.
    </ResponseField>

    {/* <!-- param-end:[nullIf] --> */}

    {/* <!-- param-start:[enableOctal] | warehouses: [snowflake] --> */}

    <ResponseField name="Enable Octal" type="boolean" required>
      When **Yes**, enables the parsing of octal values. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[enableOctal] --> */}

    {/* <!-- param-start:[allowDuplicates] | warehouses: [snowflake] --> */}

    <ResponseField name="Allow Duplicates" type="boolean" required>
      When **Yes**, allows duplicate object field names. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[allowDuplicates] --> */}

    {/* <!-- param-start:[stripOuterArray] | warehouses: [snowflake] --> */}

    <ResponseField name="Strip Outer Array" type="boolean" required>
      When **Yes**, instructs the JSON parser to remove outer brackets. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[stripOuterArray] --> */}

    {/* <!-- param-start:[stripNullValues] | warehouses: [snowflake] --> */}

    <ResponseField name="Strip Null Values" type="boolean" required>
      When **Yes**, instructs the JSON parser to remove any object fields or array elements containing NULL values. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[stripNullValues] --> */}

    {/* <!-- param-start:[ignoreUtf8Errors] | warehouses: [snowflake] --> */}

    <ResponseField name="Ignore UTF8 Errors" type="boolean" required>
      When **Yes**, replaces any invalid UTF-8 sequences with Unicode characters. When **No** (default), UTF-8 errors will not produce an error in the pipeline run.
    </ResponseField>

    {/* <!-- param-end:[ignoreUtf8Errors] --> */}
  </Tab>

  <Tab title="ORC">
    {/* <!-- param-start:[trimSpace] | warehouses: [snowflake] --> */}

    <ResponseField name="Trim Space" type="boolean" required>
      When **Yes**, removes whitespace from fields. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[trimSpace] --> */}

    {/* <!-- param-start:[nullIf] | warehouses: [snowflake] --> */}

    <ResponseField name="Null If" type="editor" required>
      Specify one or more strings (one string per row in the dialog) to convert to NULL values. When one of these strings is encountered in the file, it is replaced with an SQL NULL value for that field in the loaded table. Click **+** to add a string.
    </ResponseField>

    {/* <!-- param-end:[nullIf] --> */}
  </Tab>

  <Tab title="PARQUET">
    {/* <!-- param-start:[compression] | warehouses: [snowflake] --> */}

    <ResponseField name="Compression" type="drop-down" required>
      Select the compression method if you wish to compress your data. If you do not wish to compress at all, select NONE. The default setting is AUTO.
    </ResponseField>

    {/* <!-- param-end:[compression] --> */}

    {/* <!-- param-start:[trimSpace] | warehouses: [snowflake] --> */}

    <ResponseField name="Trim Space" type="boolean" required>
      When **Yes**, removes whitespace from fields. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[trimSpace] --> */}

    {/* <!-- param-start:[nullIf] | warehouses: [snowflake] --> */}

    <ResponseField name="Null If" type="editor" required>
      Specify one or more strings (one string per row in the dialog) to convert to NULL values. When one of these strings is encountered in the file, it is replaced with an SQL NULL value for that field in the loaded table. Click **+** to add a string.
    </ResponseField>

    {/* <!-- param-end:[nullIf] --> */}
  </Tab>

  <Tab title="XML">
    {/* <!-- param-start:[compression] | warehouses: [snowflake] --> */}

    <ResponseField name="Compression" type="drop-down" required>
      Select the compression method if you wish to compress your data. If you do not wish to compress at all, select NONE. The default setting is AUTO.
    </ResponseField>

    {/* <!-- param-end:[compression] --> */}

    {/* <!-- param-start:[ignoreUtf8Errors] | warehouses: [snowflake] --> */}

    <ResponseField name="Ignore UTF8 Errors" type="boolean" required>
      When **Yes**, replaces any invalid UTF-8 sequences with Unicode characters. When **No** (default), UTF-8 errors will not produce an error in the pipeline run.
    </ResponseField>

    {/* <!-- param-end:[ignoreUtf8Errors] --> */}

    {/* <!-- param-start:[preserveSpace] | warehouses: [snowflake] --> */}

    <ResponseField name="Preserve Space" type="boolean" required>
      When **Yes**, the XML parser preserves leading and trailing spaces in element content. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[preserveSpace] --> */}

    {/* <!-- param-start:[stripOuterElement] | warehouses: [snowflake] --> */}

    <ResponseField name="Strip Outer Element" type="boolean" required>
      When **Yes**, the XML parser strips out any outer XML elements, exposing second-level elements as separate documents. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[stripOuterElement] --> */}

    {/* <!-- param-start:[disableSnowflakeData] | warehouses: [snowflake] --> */}

    <ResponseField name="Disable Snowflake Data" type="boolean" required>
      When **Yes**, the XML parser will not recognize Snowflake semi-structured data tags. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[disableSnowflakeData] --> */}

    {/* <!-- param-start:[disableAutoConvert] | warehouses: [snowflake] --> */}

    <ResponseField name="Disable Auto Convert" type="boolean" required>
      When **Yes**, the XML parser will disable automatic conversion of numeric and Boolean values from text to native representations. Default setting is **No**.
    </ResponseField>

    {/* <!-- param-end:[disableAutoConvert] --> */}
  </Tab>
</Tabs>

<ResponseField name="On Error" type="drop-down" required>
  Decide how to proceed upon an error.

  * **Abort Statement:** Aborts the load if any error is encountered.
  * **Continue:** Continue loading the file.
  * **Skip File:** Skip file if any errors are encountered in the file.
  * **Skip File When n Errors:** Skip file when the number of errors in the file is equal to or greater than the specified number in the next property, **n**.
  * **Skip File When n% Errors:** Skip file when the percentage of errors in the file exceeds the specified percentage of **n**.

  Default setting is **Abort Statement**.
</ResponseField>

{/* <!-- param-start:[n] | warehouses: [snowflake] --> */}

<ResponseField name="n" type="integer" required>
  Specify the number of errors or the percentage of errors required for the load to skip the file. Only used when **On Error** is set to **Skip File When n Errors** or **Skip File When n% Errors**.

  This property only accepts integer characters. Specify percentages as a number only, without the `%` symbol.
</ResponseField>

{/* <!-- param-start:[sizeLimitB] | warehouses: [snowflake] --> */}

<ResponseField name="Size Limit (B)" type="integer" required>
  Specify the maximum size, in bytes, of data to be loaded for a given COPY statement. If the maximum is exceeded, the COPY operation discontinues loading files. For more information, read the [Snowflake documentation](https://docs.snowflake.net/manuals/sql-reference/sql/copy-into-table.html#copy-options-copyoptions).
</ResponseField>

{/* <!-- param-start:[purgeFiles] | warehouses: [snowflake] --> */}

<ResponseField name="Purge Files" type="boolean" required>
  Select **Yes** to purge data files after the data is successfully loaded. Default setting is **No**.
</ResponseField>

{/* <!-- param-start:[truncateColumns] | warehouses: [snowflake] --> */}

<ResponseField name="Truncate Columns" type="boolean" required>
  * **Yes:** The component will automatically truncate strings to the target column length.
  * **No:** The COPY statement produces an error if a loaded string exceeds the target column length.

  Default setting is **No**.
</ResponseField>

{/* <!-- param-start:[forceLoad] | warehouses: [snowflake] --> */}

<ResponseField name="Force Load" type="boolean" required>
  Select **Yes** to load all files, regardless of whether they have been loaded previously and haven't changed since they were loaded. This option reloads files and can lead to duplicated data in a table.

  Default setting is **No**.
</ResponseField>

{/* <!-- param-start:[metadataFields] | warehouses: [snowflake] --> */}

<ResponseField name="Metadata Fields" type="dual listbox" required>
  Snowflake metadata columns available to include in the load.

  Snowflake automatically generates metadata for files in internal stages (i.e. Snowflake) and external stages (Google Cloud Storage, Microsoft Azure, or Amazon S3). This metadata is "stored" in virtual columns. These metadata columns are added to the staged data, but are only added to the table when included in a query of the table. For more information, read [Querying Metadata for Staged Files](https://docs.snowflake.com/en/user-guide/querying-metadata.html).
</ResponseField>