From the studio and in the Data Explorer perspective, you can view the queries executed on different indicators used in an analysis. From the data explorer, you will be able to save the query and list it under the Libraries > Source Files folders in the DQ Repository tree view.
Prerequisite(s): You have selected the Profiling perspective in the studio. At least one analysis with indicators has been created.
To save any of the queries executed on an indicator set in a column analysis, do the following:
In the column analysis editor, right-click any of the used indicators to open a contextual menu.
Select View executed query to open the data explorer on the query executed on the selected indicator.
If the Data Explorer perspective is missing from the studio, you must install certain SQL explorer libraries that are required for data quality to work correctly, otherwise you may get an error message.
For further information about identifying and installing external modules, see Talend Installation Guide.
The data explorer does not support connections which has empty user name, such as Single sign-on of MS SQL Server. If you analyze data using such connection and you try to view the executed queries in the Data Explorer perspective, a warning message prompt you to set your connection credentials to the SQL Server.
Click the save icon on the editor toolbar to open the [Select folder] dialog box
Select the Source Files folder or any sub-folder under it and enter in the Name field a name for the open query.
Make sure that the name you give to the open query is always followed by .sql. Otherwise, you will not be able to save the query.
Click OK to close the dialog box.
The selected query is saved under the selected folder in the DQ Repository tree view.