Available in...Big Data Platform
Cloud API Services Platform
Cloud Big Data Platform
Cloud Data Fabric
Cloud Data Management Platform
Data Fabric
Data Management Platform
Data Services Platform
MDM Platform
Real-Time Big Data Platform
From the Profiling perspective, you can query and browse a selected database using the SQL
Editor and then to store these SQL queries under the Source Files
folder in the DQ Repository tree view.
You can then open the SQL Editor on any of these stored queries to rename, edit, or
execute the query.
Before you begin
You have selected the
Profiling
perspective.
Procedure
-
In the DQ Repository tree view, expand
Libraries.
-
Right-click Source Files and select New SQL
File from the contextual menu.
The New SQL
File dialog box is displayed.
-
In the Name field, enter a name for the SQL query you
want to create and then click Finish to proceed to the
next step.
The SQL Editor opens on the new SQL query.
If the Connections view is not open, use the
combination to open it.
-
Enter your SQL statement in the SQL Editor.
-
From the Choose Connection list, select the database you
want to run the query on.
-
On the SQL Editor toolbar, click to execute the query on the defined base tables.
Data rows are retrieved from the defined base tables and displayed in the
editor.
A file for the new SQL query is listed under Source Files
in the DQ Repository tree view.
-
Right-click a SQL file and from the context menu select an action to perform.
Note:
- When you open a query file in the SQL Editor, make sure to select the
database connection from the Choose Connection list
before executing the query. Otherwise the run icon on the editor toolbar
will be unavailable.
- When you create or modify a query in a query file in the SQL Editor and try
to close the editor, you will be prompted to save the modifications. The
modifications will not be taken into account unless you click the save icon
on the editor toolbar.