# TEST PIPELINE

The `TEST PIPELINE` statement tests an existing pipeline and looks for any new files to import.

It does not return any output if all the data has already been loaded from the data source. When a pipeline is tested, data extraction and transformation occurs, but no output is inserted into the destination table.

When testing a pipeline, it must first be stopped. An error will occur if the pipeline is currently running.

## Syntax

```sql
TEST PIPELINE pipeline_name [LIMIT count];

```

## Remarks

* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Example

You can limit the number of data source offsets to test by specifying a `LIMIT` clause, such as `LIMIT 1`.

```sql
TEST PIPELINE mypipeline LIMIT 1;

```

```output

+------+
| id   |
+------+
| foo  |
+------+
1 row in set (1.55 sec)

```

***

Modified at: May 22, 2023

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

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