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
See the Permission Matrix for the required permission.
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)