SQL
    • Dark
      Light

    SQL

    • Dark
      Light

    Article Summary

    SQL Component (Transformation)

    Write your own complete SQL SELECT statement.

    This component can run queries on any tables in the project. You may link one or more inputs into the SQL component to indicate which data sources are used within the query. The SQL component can also be used as a source (e.g. the first component in the transformation job workflow) and thus does not strictly require any input links from other components.

    If you require non-SELECT statements, the SQL Script orchestration component allows for custom non-SELECT statements where the output can be used as part of the orchestration flow.


    Properties

    PropertySettingDescription
    NameStringA human-readable name for the component.
    SQL QuerySQL ScriptThe SQL Query. Variables can be referenced with the syntax: ${<variable name>}.
    Read Variables to learn more.

    Strategy

    Runs your own SELECT statement.

    Example

    This example reads from the airports table and adds a CRC32 checksum based on the value of the input field "IATA".

    The query requires a name, and the actual SQL code.

    The query is entered. Notice how the input table is referred to using the special syntax:

    $T{input-name}

    A preview confirms everything is working OK.