Let’s create a reusable RDBMS SQL query using a Query Builder.
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 ‘Redshift-QA’ from the ‘Profile’ drop-down list.
- Click the ‘Navigator’ button from the top right side of the page.
- A ‘Navigator’ slide screen is displayed.
- Select and click the ‘order_details’ table from the ‘public’ schema.
- This action loads the SQL query as shown below.
- Click the ‘Execute Now’ button.
- The SQL 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 ‘RDBMSSQL Snapshot’ in the ‘Query Name’ text field and click the ‘Save’ button.
- An ‘RDBMSSQL Snapshot saved successfully!’ toaster message is displayed.
