The TEST PIPELINE statement tests an existing pipeline in a MemSQL database. 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

TEST PIPELINE pipeline_name [LIMIT count];

Example

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

TEST PIPELINE mypipeline LIMIT 1;
+------+
| id   |
+------+
| foo  |
+------+
1 row in set (1.55 sec)

Was this Article Helpful?

Thanks For Your Feedback!