Select from Table Via JDBC

Use the Select from Table via JDBC activity to read table data by executing a SQL query.

Complete the following properties to use this activity:

SQL - Specify the following information or click the Variable Reference icon to choose a variable:
- SQL query to execute - Enter the SQL query to be executed. The data in the database is case-sensitive.
  
  For example, this query selects specific columns from a table:
```
SELECT column1,column2 from mytable
```
  This query selects the country code and the name of the country:
```
SELECT code, name from country
```
Persist Table - Check this check box to perform query against data that has already been summarized, this helps reducing the query time and database load.
Read all columns from SQL Query - Check this check box to read all the columns from the SQL query.
Columns to read - Click Add to enter the column name and then choose the Type from drop-down list, such as Boolean, Date Time, Decimal, Integer, and String.
Number of rows to return - Enter the maximum number of rows to display (default=200).