Skip to main content

Documentation index: llms.txt. This page is also available as markdown: append .md to this URL or send Accept: text/markdown.

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.