SQL
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. You can also use the SQL component as a source (for example, the first component in the transformation pipeline workflow), and don't strictly need 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
Name = string
A human-readable name for the component.
Query = code editor
The SQL query to execute.