Test the Function Implementation

Verify that flat file data is processed and moved to Oracle Autonomous JSON Database.

  1. Upload flat file data to the Oracle Cloud Infrastructure Object Storage bucket you defined for incoming data.
  2. To verify that data is loaded into Oracle Autonomous JSON Database, access Oracle SQL Developer Web to query the database for the expected data.
    1. On the Autonomous Database Details page click Service Console.
    2. Click Development.
    3. Click SQL Developer Web.
    4. In the SQL Developer Web Sign in page, enter your Username and Password.
    5. Click Sign in.
    6. Use the Worksheet interface to execute SQL statements that return expected data.
  3. Verify that processed files have been moved by viewing the details page for the bucket you specified to accept processed files. Make sure you select the correct compartment.
  4. Use the Logging Service to get details about workflow execution. For example, use the search interface to search the log for messages prefixed with the text "INFO". The results should show that the files were processed concurrently and that the data was loaded into Oracle Autonomous JSON Database.