Count Query

Many times during the data analysis, you would want to see the count of records a query matches. You can do that in two ways 1) Run the query as is and see the total records matched 2) Change the select clause to count() and run the query

Both of them aren’t an efficient approach to get the records count. In the first case, it fetches the data unnecessarily and might also keep the pagination cursor open on the server side. In second case, you need to change the query to replace select fields with count() and revert back to include fields afterward.

Execute as Count Query option automates the second option. Upon execution, app replaces the select fields in memory with count() and shows the result.