This example illustrates the usage of the MySQL Bulk Load Snap. In this pipeline, we map the data using the Mapper Snap, insert it into the target table using the MySQL Bulkload Snap, read the data using the MySQL Select Snap and additionally sending the first document to the output view using the Head Snap.

The pipeline:

1. Mapper Snap: Maps the data and writes the result to the target path, enron numeric_table.
   
   
2. MySQL Bulk Load Snap: Loads inputs to the table, enron numeric_table.
   
   
3. MySQL Select Snap: Gets records from the table, enron numeric_table where the clause is col1= 100.
   
   
4. Head Snap: Set to 1, meaning it would send the first document to the output view, and hence the MySQL Select Snap passes the first document only.
   
   

Successful execution of the pipeline gives the following output preview.