---
sourceDocument: Australia Build workflows
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/build-workflows

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Build workflows

ft:clusterId :

    - crworkflow

bundleId :

    - crworkflow

workflow :

    - Creator


---

# Test

# Test JDBC step {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Test the JDBC step before
testing or publishing an action that contains the JDBC step.

## Before you begin

Role required: admin

## About this task

It is mandatory that you test the JDBC step
before testing the action. Testing ensures that the relevant complex object output
schema is created from table columns, which can be used as data pills in subsequent
steps.

## Procedure

1. Navigate to AllProcess AutomationFlow Designer.
2. [Create an action](https://servicenow-prod.fluidtopics.net/OQqBBG3jNnKFj0Kf0dvE5A "Create a reusable component to automate one or more steps of a process.") with a [JDBC step](https://servicenow-prod.fluidtopics.net/Kar6poz~OjqtUG7I0xdtJg "Create a reusable action to send SQL commands to a relational database.").
3. Click Test JDBC Step.  
   The Test JDBC Step pop-up window is displayed.
4. If the JDBC step takes an action input or output of the previous step as its input, provide required input values in theStep input pills field to test the JDBC step.  
   Note:  
   Input values in the Step input pills fields are not needed when records are updated, inserted, or deleted.
5. Click Run Test.  
   * When a SELECT query is executed, Sample Result is displayed in the Test JDBC Step pop-up window. Sample Result includes column names, columns types, and the values of the first row.
   * When an UPDATE, INSERT, or DELETE query is executed, a message is displayed mentioning the number of rows affected.
   {#test-jdbc-step__ul_dgd_vt4_qhb}
6. To use the sample result as the JDBC step output, click Use Result.  
   Note:  
   Use Result is not displayed when records are updated, inserted, or deleted.
7. To retrieve schema of a different table when a SELECT query is executed in the JDBC step, enter the required value in the Step input pills field and click Run Test.

## Result

When a SELECT query is executed in the JDBC step, ResultSet is displayed under
Outputs. The relevant complex object output is populated.
To learn more about complex objects, see [Complex data](https://servicenow-prod.fluidtopics.net/tYVT1pPJOWkjWSc3dPFAWQ "Use a graphical interface to work with collections of complex structured data. Help design users understand the organization of structured data, and add, remove, or configure its individual elements.").

## What to do next

Test and publish the action.

*[\>]: and then