The Query Builder is an embedded query building tool that allows you to build complex SQL queries on a selected DB Interface (an external data source) as well as on Fabric, using an intuitive interface.
Note: The Query Builder is affected by the Schema filtering, which is defined in the DB Interface.
The Query Builder window can be opened in several ways. Select one of the following options:
Instance Groups, right-click and select Open Query Builder > Schema.
Graphit window, click Query Builder in either the SQL or the SQL non-prepared node type.
Broadway, click on the QB button in the DbCommand actor in order to open the Query Builder.
Note: You can query several data source interfaces simultaneously. A new Query Builder tab opens for each interface. The name of the interface is stated in the name tab.
Data Product Schema Editor > Add Table > Create New > from source with SQL query.
Graphit window, click Query Builder icon in either the SQL or the SQL non-prepared node type. A popup opens, where you can build the query and test it. Upon closing, the SQL statement is populated into the Graphit node.
Broadway, click the QB icon in the DbCommand actor. A popup opens, where you can build the query and test it. Upon closing, the SQL is populated into the actor.
Instance Groups, where you can write and test queries either manually or assisted by the DB Interface Explorer.
Views, where you can write and test queries either manually or assisted by the DB Interface Explorer.
You can select the Query Builder, where Fabric is the data source.
The Query Builder is an embedded query building tool that allows you to build complex SQL queries on a selected DB Interface (an external data source) as well as on Fabric, using an intuitive interface.
Note: The Query Builder is affected by the Schema filtering, which is defined in the DB Interface.
The Query Builder window can be opened in several ways. Select one of the following options:
Instance Groups, right-click and select Open Query Builder > Schema.
Graphit window, click Query Builder in either the SQL or the SQL non-prepared node type.
Broadway, click on the QB button in the DbCommand actor in order to open the Query Builder.
Note: You can query several data source interfaces simultaneously. A new Query Builder tab opens for each interface. The name of the interface is stated in the name tab.
Data Product Schema Editor > Add Table > Create New > from source with SQL query.
Graphit window, click Query Builder icon in either the SQL or the SQL non-prepared node type. A popup opens, where you can build the query and test it. Upon closing, the SQL statement is populated into the Graphit node.
Broadway, click the QB icon in the DbCommand actor. A popup opens, where you can build the query and test it. Upon closing, the SQL is populated into the actor.
Instance Groups, where you can write and test queries either manually or assisted by the DB Interface Explorer.
Views, where you can write and test queries either manually or assisted by the DB Interface Explorer.
You can select the Query Builder, where Fabric is the data source.