Skip to main content

Snapshot Output and Custom reports in a Query Chain

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

Snapshot Output and Custom reports

A Query Chain runs and executes data using different profiles. A Transformation tab transforms the data. The transformed data is loaded to an Output tab. Here, let’s take a Query output snapshot and run it in Query Chain to generate custom reports.

To learn about Query, let us walk through the below procedure:

  • Click the QUERY STUDIO module.
  • Hover on the left pane options to view the Query Builder snippet.
  • Click the Query Chain option.

  • A New Query Chain session page is displayed.
  • From the Data Source tab, drag and drop an RDBMS Table icon and double tap on it.

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

  • Here, let’s checkbox a MySQL-Supplier1M Query which displays its metadata slide screen.
  • Click on Select button.

  • The user is navigated to the Query Chain design page saving and closing the RDBMS Table widget.
  • Click the Transformations tab.

  • Drag and drop the Filters icon and double-tap on it.

  • A Filter data from Data Source pop-up window is displayed.
  • Here, let’s add the expression as S_NATIONKEY = 15.
  • Click on Save button.

  • This action saves the Filter widget.
  • Click the Output tab.

  • Drag and drop an RD Output icon and double tap on it.

  • An RD Output pop-up window is displayed.
  • Click on the Select button.

  • This action saves the RD Output widget.
  • Click the Additional Options tab.

  • Let’s drag the Email icon onto the designer page and double-tap on it.

  • An Email Settings pop-up window is displayed.
  • Here, let’s checkbox Generate result file and include download link and Generate PDF file and include attachment.
  • Click on Save button.

  • This action saves the Email Settings widget.
  • Click on Execute Now button.

  • The Query Chain is executed and here it is passed.
  • The green tick Email Settings icon indicates the email is successfully sent.

  • The execution results sent to the email are displayed in the below screenshot.
  • Click on the PDF report Query Chain Exceptions…

  • A QueryChain Result PDF report file is displayed.

  • Navigate back to the email body and click on the Click here to download option.

  • The Query Chain execution results report is displayed in an excel format.

Was this article helpful?