'Preview COUNT’ in RDBMS widget assists the user to extract the total records count from its database. This enhancement is included in QC, FDR, TDR, and Validation.
To learn more, let us walk through the below procedure:
- Click the ‘QUERY STUDIO’ module.
- Hover on ‘Query Builder’ snippet from the left pane options.
- Click the ‘Query Chain’ option.
Path: QUERY STUDIO > Query Builder > Query Chain
- The user is navigated to a new Query Chain session page in create and edit mode.
- From the ‘Data Source’ tab, let’s drag and drop an ‘RDBMS Table’ icon onto Query Chain session page.
Note: All the Data Source icons including the ‘RDBMS Table’ get disabled as the user drags the ‘RDBMS Table’ onto the Query Chain session page in create and edit mode.
- Double tap the ‘Read data from Table’ widget.
- A ‘Read data from Table’ pop-up window is displayed.
- Let’s select ‘MSSQL’ from the ‘Database Type’ drop-down list.
- Select ‘MSSQL Northwind’ from the ‘Connection Name’ drop-down list.
- Click the ‘Click here for Navigator’ button.
- A ‘Navigator’ slide screen is displayed on the right side of the page.
- Let’s select ‘dbo.payment’ table from the ‘Tables’ folder.
- Click the ‘dbo.payment’ to load the table.
- The ‘Column Name’ and ‘Data Type’ columns are displayed.
- Now, let’s click the ‘Preview COUNT (*) button.
Note: You can directly use filters and aggregation transformations from the RDBMS Tables widget. This is a new enhancement added as a part of 2022.09 release.
- An ‘Existing Query’ pop-up window is displayed showing the total records count which is ‘15554’ here.