SingleStore DB

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
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)