roger-mahler
commented
9 months ago Faulty nodes:
```sql
with table_columns as (
select table_or_udf_name as table_name, source_column_name as column_name
from facet.table_relation r
join facet.table s
on s.table_id = r.source_table_id
union
select table_or_udf_name as table_name, target_column_name as column_name
from facet.table_relation r
join facet.table s
on s.table_id = r.target_table_id
) select *
from table_columns f
left join sead_utility.view_table_columns c
on c.table_schema = 'public'
and c.table_name = f.table_name
and c.column_name = f.column_name
where f.table_name not like 'facet.%'
and c.column_name is null
```
| table_name | column_name | note |
|---|---|---|
| tbl_dendro | dendro_measurement_id | |
| tbl_chron_controls | chronology_id | |
| tbl_ceramics | ceramics_measurement_id | |
| tbl_dendro_dates | years_type_id | |
| tbl_chron_controls | chron_control_type_id | |
| tbl_chron_control_types | chron_control_type_id | |
| tbl_chronologies | sample_group_id |
Project: sead_api
Remove or change deprecated edges in facet graph