In SNOW you can't do full outer join as in SQL (from my experience). But if they have same base table and you need to get the columns from the extended table not present on base table then you can do a sort of outer join. I had a requirement to present on the portal My tickets from different application but which were related by task table as base table.

DB view name - xyz

Base table - B1

extended table 1 - Ex1

extended table 2 - Ex2

---

---

---

In DB view XYZ add tables as below:

100 - B1 - variable name B11

!include sys_id in field list

*************************************

200 - B1 - variable name B12 - where clause B11_sys_id = B12_sys_id && (B12_<field1> = 'Ex1 identifier' || B12_<field1> = 'Ex2 identifier')

!include sys_id and <field1> in field list

*************************************

300 Ex1 - variable name ex1 - where clause B11_sys_id = ex1_sys_id left join is true

!include sys_id in field list

*************************************

400 Ex2 - variable name ex1 - where clause B11_sys_id = ex2_sys_id left join is true

!include sys_id in field list

*****************DONE**********************************