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.
Use when the source is anticipated to change frequently

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