How to use SQL Editor?

How to use SQL Editor?

Beginner Asked on July 15, 2019 in Diyotta Studio.
Add Comment
2 Answer(s)

SQL Editor in DI Suite is used for browsing database objects.

Steps for creating a new editor.

  1. Go to Studio module.
  2. Click on SQL Editor option in the Object explorer in the left pane of the dashboard.

RE: How to use SQL Editor?

3.Click on new editor on right panel under actions. It opens a pop-up to select a database which user wants to navigate.

RE: How to use SQL Editor?

4.Upon selecting a database, existing datapoints with database(s)/Schema(s) are shown and click on OK. Editor is created.

RE: How to use SQL Editor?

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.

RE: How to use SQL Editor?

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.

RE: How to use SQL Editor?

7.To run the SQL user needs to click on ‘Run SQL’ on right panel under actions.

RE: How to use SQL Editor?

8.Result of SQL is displayed in ‘View Data’ canvas for given SQL.

RE: How to use SQL Editor?

9.User can export the result to a csv file by clicking on ‘Export’ option on right panel under actions.

RE: How to use SQL Editor?

Expert Answered on July 15, 2019.
Add Comment

In Diyotta’s 4.5 version, the SQL Editor has been made into an independent module with much more features.

RE: How to use SQL Editor?

Within the SQL editor module, we can now select the project>datapoint> database/schema>table from the left hand side list as show below:

RE: How to use SQL Editor?

 

After selecting, we can run the query this way: 

RE: How to use SQL Editor?

 

There are options to view the query history and manage/delete the queries too:

RE: How to use SQL Editor?

 

 

 

Expert Answered on July 10, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.