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];

Remarks

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)

Last modified: May 22, 2023

Was this article helpful?