Bulk load records into a table

This Pipeline demonstrates 6 records to table TECTONIC.TERENCE_BULK_TEST2 with Oracle - Bulk Load Snap.



Use the following SQL statement/definition to create the target table, beforehand. CREATE TABLE "TECTONIC"."TERENCE_BULK_TEST2" ( "id" NUMBER, "first_name" VARCHAR2(4000), "last_name" VARCHAR2(4000) )
  1. Use a JSON Generator Snap to define the data to upload.


    Here, there are 3 rows of data whose ID column values are strings, which is invalid when inserting into table TECTONIC.TERENCE_BULK_TEST2.

  2. We use the Oracle - Bulk Load Snap with the following configuration to load the data into the target table. Define the account for the Snap to connect to the target Oracle database instance. Choose the Route error data to error view option in the Snaps's Views tab.


  3. Execute the pipeline and observe the results.
    You can see the following outputs in the Snap's output view and error view, respectively:
    1. Three new rows have been added into the target table.


    2. Failed rows are displayed in the error view of the Snap as below:


To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.