add full outer join

[fatchat]

generated

{{ config(materialized='table', schema='intermediate') }}
WITH cte1 as (

SELECT "t1"."_airbyte_extracted_at",
"t1"."_airbyte_meta",
"t1"."_airbyte_raw_id",
"t1"."data",
"t1"."id",
"t1"."indexed_on",
"t2"."_airbyte_extracted_at" AS "_airbyte_extracted_at_2",
"t2"."_airbyte_meta" AS "_airbyte_meta_2",
"t2"."_airbyte_raw_id" AS "_airbyte_raw_id_2",
"t2"."data" AS "data_2",
"t2"."id" AS "id_2",
"t2"."indexed_on" AS "indexed_on_2"
 FROM {{source('staging', 'airbyte_MS_visit')}} t1
 FULL OUTER JOIN {{source('staging', 'airbyte_Adolescent_Info')}} t2
 ON "t1"."id" = "t2"."id"
)
-- Final SELECT statement combining the outputs of all CTEs
SELECT *
FROM cte1

which ran to produce logs without errors:

[codecov-commenter]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 45.03%. Comparing base (a93ba5c) to head (b7a78af).

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #858 +/- ## ======================================= Coverage 45.03% 45.03% ======================================= Files 76 76 Lines 5249 5249 Branches 1212 1213 +1 ======================================= Hits 2364 2364 Misses 2754 2754 Partials 131 131 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.