# Additional CREATE PIPELINE Examples

Pipelines can be created using the `SKIP`, `IGNORE`, or `REPLACE` options. These options can be used alone or in combination with each other.

## SKIP

The `SKIP ... ERRORS` behavior lets you specify an error scenario that, when encountered, discards an offending row. Refer to [`SKIP ALL ERRORS`](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/load-data/#UUID-8d8456d6-b63b-4a11-94e1-da02f8ee4083.md) example for more information.

## Examples

```sql
CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> SKIP PARSER ERRORS INTO TABLE <table_name>;

CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> SKIP PARSER ERRORS REPLACE INTO TABLE<table_name>;

CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> SKIP CONSTRAINT ERRORS INTO TABLE <table_name>;

CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> SKIP ALL ERRORS INTO TABLE <table_name>;

```

## IGNORE

Unlike `SKIP ... ERRORS` which discards offending rows, `IGNORE` may change the inserted row’s data to ensure that it adheres to the table schema. Refer to [IGNORE Error Handling](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/load-data/#UUID-34c9fa5e-7b4b-ba7c-73e8-e6f37e438cd1.md) for more information.

## Examples

```sql
CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> IGNORE INTO TABLE <table_name>;

CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> IGNORE PARSER ERRORS INTO TABLE <table_name>;

CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> IGNORE PARSER ERRORS REPLACE INTO TABLE <table_name>;


```

## REPLACE

If the `REPLACE` option is specified, existing rows in the table are replaced with the ingested row for each matching `PRIMARY KEY` or `UNIQUE` index.

`REPLACE` can also be used with `IGNORE` and `SKIP`. However, `REPLACE` can come after the `SKIP` or `IGNORE` option.

## Examples

```sql
CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> REPLACE INTO TABLE <table_name>;

CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> SKIP ALL ERRORS REPLACE INTO TABLE <table_name>;

CREATE PIPELINE <pipeline_name> AS LOAD DATA <file_name> SKIP CONSTRAINT ERRORS INTO TABLE <table_name>;

CREATE PIPELINE p AS LOAD DATA <file_name> SKIP CONSTRAINT ERRORS REPLACE INTO <pipeline_name>;

```

> **❗ Important**: - `SKIP CONSTRAINT ERRORS` and `SKIP DUPLICATE KEY ERRORS` are unsupported with pipelines into stored procedures.
> - `IGNORE, SKIP PARSER ERRORS`, and `SKIP ALL ERRORS` are unsupported with non-CSV pipelines.
> - `REPLACE, SKIP CONSTRAINT ERRORS`, and `SKIP DUPLICATE KEY ERRORS` are supported with non-CSV pipelines.

***

Modified at: July 7, 2026

Source: [/db/v9.1/reference/sql-reference/pipelines-commands/additional-create-pipeline-examples/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/additional-create-pipeline-examples/)

(An index of the documentation is available at /llms.txt)