Can I only publish one database view even if the view is in multiple models?

[ryan_bouquet]

Knowledge Drop

Last tested: Jun 22, 2020
 

Yep, using refinements!

Instead of applying "publish_as_db_view: yes" in the view itself, instead we will use refinements on the one model we want to build it for. There we refine it like so:

view: +pdt_name {

derived table: {

publish_as_deb_view: yes

}

}

That way, the publish parameter is only applied inside the one model instead of for each model the table is included in

This content is subject to limited support.