Skip to main content

Creating reusable Visual SQL Query

You are viewing archived documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

Creating reusable Visual SQL Query

Let’s create a reusable visual SQL query using a Query Builder.

Users can join two relevant columns using inner and outer JOIN selection between two or more matching tables. Visual queries assist users in easy column selection and help in performing the necessary operations.

JOIN type selection between two matching tables is classified into 3 types as shown below:

  • Selects all rows from both participating tables as long as there is a match between the columns. (Selected by default)
  • The JOIN operations that allow you to specify a join clause. It preserves the unmatched rows from the first (left) table, joining them with a null row in the shape of the second (right) table.
  • The result set of the full outer join has NULL values for every column of the table that does not have a matching row. For the matching rows, the FULL OUTER JOIN produces a single row with values from columns in both tables.

To learn more, let us walk through the below procedure:

  • Click the ‘QUERY STUDIO’ module.
  • Hover on the ‘Query Builder’ snippet from the left pane options.
  • Click the ‘Query.’

Path: QUERY STUDIO > Query Builder > Query

  • This action navigates the user to the ‘Query’ session page.
  • Select ‘Oracle 11g-QA’ from the ‘Profile’ drop-down list.
  • Click the ‘SQL Query’ toggle button.

  • This action switches the SQL Query to Visual Query.
  • Click the ‘Navigator’ button from the top right side of the page.

  • A ‘Navigator’ slide screen is displayed.
  • Select the ‘ORDERS2’ table from the ‘RDADMIN’ schema.

  • Double tap the ‘ORDERS2’ table.
  • This action loads the visual query as shown below.

  • Select and checkbox three columns.
  • Click the ‘Execute Now’ button.

  • The visual query is executed and the user is navigated to the ‘Results’ tab displaying the output snapshot.
  • Click the ‘Save’ button.

  • An ‘Additional saving options’ pop-up window is displayed.
  • Add ‘Visual Query snapshot’ in the ‘Query Name’ text field and click the ‘Save’ button.

  • A ‘Visual Query snapshot saved successfully!’ toaster message is displayed.

Note: The user can use this Visual SQL Query (Visual Query snapshot) and may run it in any FDR or Validation scenarios.

Was this article helpful?