Dacris.Maestro.Data.Select Interaction

Executes a selection query.

Preconditions:

query is a constant name, outputFile (csv) or outputPath (->array), parameters, separator, schemaPath

Sample State.json Input

{
  "sampleKey": {
    "connPath": "$.yourStateKey",
    "timeout": "10",
    "outputFile": "folder1/folder2/yourFile.txt",
    "outputPath": "$.yourStateKey",
    "schemaPath": "$.yourStateKey",
    "separator": "yourText",
    "query": "Txt_File_In_Constants_Folder",
    "parameters": {
      "schema": {
        "your_fieldName": "your_@fieldName"
      },
      "data": {
        "your_fieldName": "yourText"
      }
    },
    "retryTimes": "10",
    "retryDelay": "10"
  },
  "dataConnections": {
    "your_connName": {
      "systemType": "your_systemType",
      "connString": ""
    }
  },
  "customDataProviders": {
    "your_systemType": "yourText"
  }
}