Snapshot data from Custom SQL Query Results

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

Creating reusable RDBMS SQL Query

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 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.