Skip to main content

Auto Generate Queries

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

Need to show differentiation for Auto-Generate Queries in explorers

  1. Now users can differentiate between Auto Generate Queries and manual Queries in explorers. When users wish to add an existing Query to use it in any Query Chain or FDR, they must be able to differentiate between the Queries generated through Auto Generate process or manual process.
  2. When users edit any Auto-Generate Query from the explorer and save it, then it will be converted to a normal Query.

First Enhancement:

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

  • The user is navigated to ‘Auto Generate Queries’ session page.

  • Let’s select ‘MSSQL Northwind’ from the ‘Profile’ drop-down list.
  • Click the ‘Download Template’ button to download the sample excel template.

  • Let’s open the downloaded sample excel template.
  • Under ‘Sheet 1’, the user can notice a tabular grid with columns such as QueryName, SQLText, SaveQueryWithoutRunning, and ListofColumns.

Note: The user is required to follow this excel template to fill the respective columns.

  • Let’s click the ‘File Format Guidelines’ sheet.

  • The user here can view the File format guidelines.
  • Let’s close this window and navigate back to the ‘Auto Generate Queries’ session page.

  • Let’s click the ‘Choose File’ button.

  • Let’s select a sample ‘RD Auto Generate Queries-11292021025517’ excel file from the local drive that contains external Auto Generate Queries.
  • Click the ‘Open’ button.

  • The external Auto Generate Queries are uploaded.
  • Let’s select and checkbox both ‘Snowflake 3’ and ‘Snowflake 4’ from the ‘Query Name’ column.
  • Click the ‘Browse Folder’ button.

  • A ‘Choose Folder’ pop-up window is displayed.
  • Let’s suppose select the folder ‘AutoGenQuery Differentiation’.
  • Click the ‘Select’ button.

  • The user is navigated to the ‘Auto Generate Queries’ session page.
  • The Auto Generate Queries path is updated here.
  • Now, click the ‘Generate Queries’ button from the top right corner of the page.

  • Let’s click the ‘QUERY STUDIO’ module.

  • The user is navigated to the ‘Query Explorer’ session page.
  • Click the ‘AutoGenQuery Differentiation’ folder.

  • The ‘Auto Generate Queries’ (Snowflake 4 and Snowflake 3) are added here.

Note: ‘orderdetails-1 and orders’ are normal/manual Queries that were already present in this folder.

  • The user can clearly notice the icon differentiation between Auto Generate Queries and manual Queries.

  • For example, select the second Auto Generate Query (Snowflake 3).

Note: Let’s see if this Auto Generate Query (Snowflake 3) can be differentiated while using it in a Query Chain.

  • Hover on the ‘Query Builder’ snippet.
  • Click and open the ‘Query Chain’ session page in another window.

  • The user is navigated to the new ‘Query Chain’ session page.

  • From the ‘Data Source’ tab, let’s drag and drop the ‘Queries’ icon.

Note: The ‘Queries’ icon gets disabled as the user drags it onto the ‘Query Chain’ session page in create and edit mode.

  • Click the ‘Query (Read data from <Query>)’ widget.

  • A ‘Read data from Query’ pop-up window is displayed.

Note: Here the user can differentiate between Auto Generate Query (Snowflake 3) and other normal/manual Queries.

  • Let’s close this window and navigate back to the ‘AutoGenQuery Differentiation’ folder within ‘Query Explorer’ session page.

Second Enhancement:

  • Let’s select and checkbox the second Auto Generate Query (Snowflake 3).
  • Click the ‘Edit’ button.

  • The user is navigated to the ‘Query Edit’ session page.
  • Here also, the user can view the Auto Generate Query ‘Snowflake 3’ icon differentiation.

  • Click the ‘Save’ button.

Note: Now let’s try to save this Auto Generate Query ‘Snowflake 3’ manually.

  • A toaster message ‘Snowflake 3 saved successfully’ is displayed.
  • Let’s close this window and navigate back to the ‘AutoGenQuery Differentiation’ folder within ‘Query Explorer’ session page.

  • The user notices that the ‘Snowflake 3’ which was previously an ‘Auto Generate Query’ is converted to a normal Query due to the user’s manually saving it.

Was this article helpful?