What is the difference between the UI vs. SQL modeling?
SQL VS. UI modeling performance
UI Model compiles each step to a so-called CTE (“WITH” statement) - which BigQuery may potentially optimize less than an equivalent statement only built with inline SELECT statements. So technically, you can achieve higher performance with SQL models, but the difference should not be substantial / even noticeable in the vast majority of cases. If SQL Model statements are not written well, there is no guarantee of good performance either. There are also ways to optimize your UI model by only selecting columns you need in the Fields and Output node as well as minimizing the usage of table manipulation nodes.
Was this article helpful?