# Loading Data Using COPY Command

This scenario describes a Job that loads data into a Snowflake table using the COPY command, where Copy Command Options is customized in ON\_ERROR form in case any record is rejected.

The input data contains several records, one of which violates the length limitation.

```
#Name
Harry
veryveryveryLongName
Jack
```

Then, the input data is inserted into a Snowflake table and the record that violates the length limitation is rejected.

### In this section

* [Creating a Job for loading data using the COPY command](https://help.qlik.com/talend/en-US/components/8.0/snowflake/tmysqlbulkexec-tmysqloutputbulk-tmap-creating-job-for-loading-data-using-copy-command-standard-component-create)
* [Opening a connection to access a Snowflake database](https://help.qlik.com/talend/en-US/components/8.0/snowflake/tmysqlbulkexec-tmysqloutputbulk-tmap-opening-connection-to-access-snowflake-database-standard-component)
* [Creating a Snowflake table](https://help.qlik.com/talend/en-US/components/8.0/snowflake/tmysqlbulkexec-tmysqloutputbulk-tmap-creating-snowflake-table-standard-component)
* [Loading data to the Snowflake table](https://help.qlik.com/talend/en-US/components/8.0/snowflake/tmysqlbulkexec-tmysqloutputbulk-tmap-loading-data-to-snowflake-table-standard-component)
* [Using COPY command to load data](https://help.qlik.com/talend/en-US/components/8.0/snowflake/tmysqlbulkexec-tmysqloutputbulk-tmap-using-copy-command-to-load-data-standard-component-click)
* [Retrieving data from the Snowflake table](https://help.qlik.com/talend/en-US/components/8.0/snowflake/tmysqlbulkexec-tmysqloutputbulk-tmap-retrieving-data-from-snowflake-table-standard-component)
* [Executing the Job](https://help.qlik.com/talend/en-US/components/8.0/snowflake/tmysqlbulkexec-tmysqloutputbulk-tmap-executing-job-standard-component-press)

**Related information**

* [tMysqlBulkExec](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlbulkexec)
* [tMysqlOutputBulk](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqloutputbulk)
* [tMysqlOutputBulkExec](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqloutputbulkexec)
* [tRowGenerator](https://help.qlik.com/talend/en-US/components/8.0/trowgenerator/trowgenerator)
* [tMap](https://help.qlik.com/talend/en-US/components/8.0/tmap/tmap)