Product Solutions Support
Try MemSQL

TEST PIPELINE

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.

TEST PIPELINE pipeline_name [LIMIT count];

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 useful?