Query Editor
  • 19 Aug 2024
  • 2 Minutes to read
  • Dark
    Light

Query Editor

  • Dark
    Light

Article summary

The Query Editor allows users to write queries against any established database connection. These queries can be saved for future use and are available for quick access. The results of any query can be downloaded and saved as a CSV file.

Enable/Disable Query Editor for Designers

The option Allow Designers to Use Query Editor under System > Settings > Designer Studio > QUERY EDITOR permits all Designer users to access the Query Editor and the ability to execute queries if they are checked.

Accessing the Query Editor

The Query Editor can be found by right-clicking any Designer Folder and selecting Query Editor from the user action menu.


Using the Query Editor

To ensure that data is not caught in the cache, changes in the Query Editor should be followed by a service restart.

  1. Selecting Query Editor will open the New Database Query window. The Connection drop-down menu on the right side of the window allows the user to choose any established database connection. 

  2. In the search bar, enter "entity_account" to search the database connection for the entity_account Table. To inspect the Table schema, expand the list by clicking to the left of the Table name.


     

  3. Generate a query on the table by selecting a query on the action menu when hovering over a Table. In the entity_account action menu, select Generate "Select" Query.
     


    As the Query Editor allows the ability to perform queries on Tables within a selected database, SQL Queries may also be generated manually by providing them as text input in the box on the left-hand side and then clicking RUN.

  4. On the left-hand panel, click RUN.

  5. After the query runs, users can export the results to a CSV file by clicking Download as CSV.

  6. Users can save the query for future use by clicking SAVE, naming the query, and selecting Save if desired. Note that the Save button will no be useable until a query is written.

  7. In the Designer folder, users can see saved queries and re-run them via the action menu.

  8. The different menus that make up the Query Editor can be enlarged by using the || or = icons depending on which window needs to be changed.

All Queries Report

All queries created in Legacy Projects in the query editor are saved to a centralized location and accessed in a Report Format. This Report is accessible at System > Integration > Database Queries.

Queries saved to a Project are viewable like any other Designer Entity.

Actions to perform on Queries within a Project:

Right-clicking on the query allows several actions to be performed on the query. Refer to the following table:

Actions

Description

Edit Database Query

Allows users to edit the query.

Auto Run > Create Interval Flow

Auto Run > Create Scheduled Job Flow
Auto Run > Create Startup Flow

Clicking on any of the options creates automated jobs in the respective job type. These jobs can be found at System > Jobs and Events > Scheduled Jobs. For more information, refer to Understanding Scheduled Jobs.

Auto Run > Enable Run on Import

When the query is imported to the platform, it will run immediately.

Manage

Allows users to perform actions such as Delete, Get Query ID, and Move the Query.

Deployment

Allows to perform repository actions.


Feature Changes

Description

Version

Date

Developer Task

ODBC connections (for example, Snowflake) are no longer selectable in the Query Editor. Query Integration (Add Query) is supported.

9.1

July 9, 2024

[DT-040547]

Updated the Query Editor’s UI.

9.1

July 9, 2024

[DT-041366]

Update the Query Editor’s UI to allow resizing of different aspects.

9.2

August 19, 2024

[DT-041615]


For further information on Administration, visit the Decisions Forum.


Was this article helpful?