Create a JDBC Input
JDBC Connections available:
- DB2
- MS Sql
- MySQL
- Oracle
- PostgreSQL
- Qubole
- Redshift
- Snowflake
Create an Input for JDBC in Hero Platform_
- Open Hero Platform_.
- Open Integration from the navigation menu and select Inputs.
- Click Create New Input.
- Enter a name for the JDBC Input and select an JDBC Connection from the drop-down list.
- Configure the JDBC Input data.
Enter a SQL query to pull data.
- Placeholders
- ${partition}
${checkpoint}
Example query:
select * from <field name> where {checkpoint} and {partition}
Partition and checkpoint placeholders are not supported when the query has more than one table.
The
{partition}
command does not support SQL aliases as part of the select statement. TheSelect
statement can create an alias for ease of reference in the rest of the SQL query, but use actual table/column names for the elements being selected when using{partition}
.- Placeholders
- Select a field from the drop-down menu if partitioning a column input is required.
- The partition column must be a numerical data type field.
- Enter a numerical value for the partition size.
- Select a field from the drop-down menu if checkpointing a column input is required.
- Click the Refresh icon to display field mapping for the Input
- From the field mapping table:
- Confirm or change column names.
- Confirm or change column data types.
- Remove or confirm the arrangement of columns.
- Click OK.