Description:
Streams data from a PSQuery and writes into SQL table
Parameters:
Param Name | Is Required | Inputs Type | Input Default Value | Description |
---|---|---|---|---|
basicAuthConnectionProfile | True | String | The alias for the basic auth connection details | |
psQueryName | True | String | The name of the Query Manager query to be executed | |
psQueryParameters | False | String | Comma-separated list of parameters needed for the query | |
psQueryDataNode | False | String | The value in the JSON response containing the data to be parsed | |
destinationConnectionProfile | True | String | The alias for the connection profile needed to write to a SQL source | |
destinationTableName | True | String | The name of the table to be written to | |
destinationSchema | True | String | The name of the schema holding the destination table | |
createTableIfMissing | False | Boolean | true | Determines whether or not to create a table in the destination schema if one is missing |
truncAndReload | False | Boolean | true | Determines whether or not to truncate the table prior to loading any records |
dropAndRebuild | False | Boolean | false | Determines whether or not to drop the table and rebuild it prior to loading any records. |
chunkSize | False | Integer | 10000 | The number of records to be read before being written |
Examples:
jobName: International Programs Sunapsis Data to XML steps: - stepType: psQueryToSqlStep stepName: IP_SUN_ADDRESS stepParameters: basicAuthConnectionProfile: psQuery_prod psQueryName: IP_SUN_ADDRESS destinationConnectionProfile: ih destinationSchema: intl_prog destinationTableName: IP_SUN_ADDRESS