You are viewing an older version of this section. View current production version.
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
TEST PIPELINE mypipeline LIMIT 1; +------+ | id | +------+ | foo | +------+ 1 row in set (1.55 sec)