harrystech/arthur-redshift-etl

No warning when upgrade drops dependent view

tvogels01 opened this issue · 1 comments

Summary

When running an upgrade, we drop the relation with the CASCADE option which means that any VIEWs immediately depending on the relation also get dropped.
There is no warning to that effect. If upgrade could warn about the additional views being dropped, users could easily add them to the upgrade.

Warning:

arthur.py upgrade --only --quiet upstream_schema.upstream_table
2021-10-17 14:26:30 - WARNING - These views are not part of the upgrade: 'downstream_schema.downstream_table'

Or include those views automatically:

arthur.py upgrade --only --include-immediate-views --quiet upstream_schema.upstream_table