How to use SQL Editor?
SQL Editor in DI Suite is used for browsing database objects.
Steps for creating a new editor.
- Go to Studio module.
- Click on SQL Editor option in the Object explorer in the left pane of the dashboard.
3.Click on new editor on right panel under actions. It opens a pop-up to select a database which user wants to navigate.
4.Upon selecting a database, existing datapoints with database(s)/Schema(s) are shown and click on OK. Editor is created.
5.Now user can type select query in editor or user can click on View Objects option in right panel where list of existing data objects under that datapoint are shown.
6.User can select a data object in that pop-up and click on it. Then select SQL is generated automatically and populated on editor screen.
7.To run the SQL user needs to click on ‘Run SQL’ on right panel under actions.
8.Result of SQL is displayed in ‘View Data’ canvas for given SQL.
9.User can export the result to a csv file by clicking on ‘Export’ option on right panel under actions.
In Diyotta’s 4.5 version, the SQL Editor has been made into an independent module with much more features.
Within the SQL editor module, we can now select the project>datapoint> database/schema>table from the left hand side list as show below:
After selecting, we can run the query this way:
There are options to view the query history and manage/delete the queries too: