Home > Data Nodes > Data Source Node > Explore Data Node > Graph Node > SQL Query Node > Input for SQL Query Node
A SQL Query node requires the following input:
Zero to many data provider nodes, such as Data Source nodes and Transform nodes.
Zero to many input model provider nodes (such as model build nodes and Model nodes)
Data provider nodes are used as follows:
If there are 0 data provider nodes, you define an originating data source node using a SQL SELECT statement that is not constrained by any input sources that must be defined within Data Miner. The statement can contain its own internal table references, such as
Select * from a, b where a.id = b.id
When there are 0 data provider nodes, he source tables or views are hidden from Data Miner. Code generation cannot parameterize such tables in the generated SQL script.
If there are one or more data provider nodes, you can easily reference each data flow within the expression builder interface. You can continue to expose all data sources within the Data Miner workflow.
When a model provider node is connected as input, it allows the you to see the list of model names contained in the node. This is useful in creating SQL that requires a model name.