How to Include Multiple SQL Statements in the Override SQL Part of a View Node
When working with SQL views in your database management system, you might encounter situations where you need to include multiple SQL statements in the override SQL part of a view node. While the Coalesce does not support multiple SQL statements directly in a single override, there is an effective workaround that allows you to achieve this functionality.
You can create another stage in the overwrite SQL code with a different name than the previous stage. When the view node is deployed, both stages are executed in order.
![](https://files.readme.io/e7f6636-override_sql_stage.png)
Updated 4 months ago