SQL Query

Basic Information

Node Settings

• connection ( string, required) : A connection string or connection tag.

• ResultName (string, optional) : setting description

• queries (List<string>, required) : A list of queries that node executes.

If using connection tag in connection setting make sure that tag exists in database!

Tips and Advanced usage

Use this node to extract data from SQL. It can execute any query. You can set up a multiple queries to extract more table from SQL.

Examples

Example 1

This example extracts all the data from SQL table called ExperimentData. It uses connection tag for the connection.

{
  "properties": {
    "connection": "<storage>",
    "ResultName": "ExportedData",
    "queries": [
      "Select * from ExperimentData"
    ]
  }
}

Example 2

This example extracts the data from the ExperimentData table but it is filtered for the current user and selected project.

In order for this node to work, project metadata must be already available in process contex (i.e. must be selected from the form or stored as metadata in some other way). The username metadata is built it metadata that will reflect the username of currently logged user.

{
  "properties": {
    "connection": "<storage>",
    "ResultName": "ExportedData",
    "queries": [
      "Select * from ExperimentData where User = @username and Project = @project"
    ]
  }
}