May 18, 2022 — Improvements to generating SQL query for Data Marts with filters

A new improvement in SQL query generation allows you to get complete and correct data. To do this, we firstly join data from different tables and then apply filters ‘WHERE’ to the resulting data.

How it used to work before

While generating an SQL query, we would add filters ‘WHERE’ to each ‘SELECT’ from tables. Here’s an example:

01.png

After release

According to the new logic, we add filters at the end of the query after all the joins. See the example below:

02.png

Now you will definitely trust your reports built on complete data.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.