Skip to main content

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.

The image below displays a segment of a SQL script being edited within V NATION. The Create SQL tab is active, and the script is in the Override Create SQL phase within the V NATION1 view. The script is associated with the WORK schema and the stg_nation1 table.