Can we view sample 100 records present in the tables present in SQL EDITOR in diyotta 4.5 version
Before using the SQL EDITOR to perform SQL operations on tables, I just want to preview the data prior to any sql’s being run on the table. Is there any option of previewing the data present in the table through SQL EDITOR
In Diyotta 4.5 we have included enhanced features in the UI level and changed the Look and feel also made it ease of use for the users.
we have introduced a new component known as SQL Editor. This is part of the Diyotta tool and when we click on the SQL EDITOR icon it opens a new browser/ in the existing browser window. SQL Editor can be used to run SQL queries based on the datapoint you have chosen.
We can view the Data of the tables selected from the list of tables present in the Database in SQL EDITOR. We use the View Data tab to view the data present in the Table.